|
|
-
|
|
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...
|
|
-
|
|
After installation of SQL Server 2012 SP1, one may encounter a situation where the CPU spikes to 100%, NGEN errors are encountered and Event Viewer has the error message: "Detection of product '{A7037EB2-F953-4B12-B843-195F4D988DA1}', feature 'SQL_Tools_Ans', Component '{0CECE655-2A0F-4593-AF4B-EFC31D622982}' failed." This post directs to the Microsoft KB article with the solution....
|
|
-
|
|
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_property_lists, sys.dm_fts_semantic_similarity_population...
|
|
-
|
|
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 presents the answer to this interview question....
|
|
-
|
|
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....
|
|
-
|
|
Microsoft SQL Server 2008 introduced the DATE and TIME data-types. TIME could be added to DATETIME in SQL 2008, but can longer be done so in SQL Server 2012. In this post, we look at the Msg #402, and associated workaround....
|
|
-
|
|
In this post I explore sys.sequences, a new Catalog View introduced in SQL Server 2012 in order to keep a track on the SEQUENCE objects....
|
|
-
|
|
If Visual Studio 2010 SP1 is installed over an existing SQL Server 2008 R2 (RTM or earlier than CU7), the Intellisense feature in the SQL Server Management Studio (SSMS) may stop working. This is a known issue and a fix is available for the same under Microsoft KB2531482....
|
|
-
|
|
This post explores new DMVs introduced in SQL Server 2008R2 and 2012 related to the SQL Server Operating System (SQLOS)....
|
|
-
|
|
Semi-colons as statement-terminators has been around for as long as I can remember, however, they have only been made mandatory in the newer statements. However, as documented in the T-SQL Syntax Conventions, using semi-colons as statement terminators will be required in a future release of SQL Server. However, care needs to be taken not be use them on batch separators....
|
|