|
|
|
|
-
Olga Medvedeva Liked 3 Months ago through Blogs | 1 Point
In this post, we take a look at the Dynamic Management and Catalog Views related to Resource Governor introduced in SQL Server 2012: sys.dm_resource_governor_resource_pool_affinity and sys.resource_governor_resource_pool_affinity...
|
|
|
-
Olga Medvedeva Liked 3 Months ago through Blogs | 1 Point
In this post, we take a look at the Full-Text and Semantic Search related Dynamic Management and Catalog Views - sys.fulltext_semantic_language_statistics_database, sys.fulltext_semantic_languages, sys.registered_search_properties, sys.registered_search...
|
-
Olga Medvedeva Liked 3 Months ago through Blogs | 1 Point
Having the same non-qualified column name/alias in the ORDER BY clause results in an error. But what would happen if we define duplicate column aliases in the SELECT clause? Will SQL Server consider this to be an ambiguous column name? This post present...
|
-
Olga Medvedeva refreshed 3 Months ago through Blogs | 1 Point
Having the same non-qualified column name/alias in the ORDER BY clause results in an error. But what would happen if we define duplicate column aliases in the SELECT clause? Will SQL Server consider this to be an ambiguous column name? This post present...
|
|
|
|
|
-
Olga Medvedeva Liked 3 Months ago through Blogs | 1 Point
In this post I explore the database and index related DMVs introduced in SQL Server 2012, namely: sys.dm_db_uncontained_entities, sys.dm_db_log_space_usage and sys.dm_db_fts_index_physical_stats....
|
|
|