|
|
-
|
|
Starting SQL Server 2012, the WITH APPEND option in the CREATE TRIGGER statement has been deprecated. This option was used for compatibility levels 65 or lower to create another trigger of the same type on any given table....
|
|
-
|
|
It is a myth that the ROWVERSION column holds a unique value across a database. In this post, I demonstrate that a possibility exists for having duplicate values in a ROWVERSION column when using Bulk-Insert operations (SELECT…INTO)...
|
|
-
|
|
Many ISVs do not educate users that database performance may degrade immediately after an upgrade - especially one that changes the compatibility level of the database to support a higher version of SQL Server. Today, we explore the reason behind his performance degradation - recompilation of cached plans....
|
|
-
|
|
How do you know when your index was last rebuilt or reogranized? How many records changed during this rebuild/reorganization operation? Read this post for answers to all these questions....
|
|
-
|
|
Almost every product comes with a set of predefined system default data. There are very few product teams who use row constructors (introduced in SQL Server 2008) to populate their default data. What these teams fail to realize is that many a times, the conventional approach may have a negative impact on the time it takes to insert the data and also reduces the overall efficiency of the entire data load operation....
|
|
-
|
|
SQL Server 2012 (“Denali”) introduces many new features directed towards improving server efficiency and availability and developer/administrator productivity. SQL Server 2012 no longer supports compatibility level 80 (SQL Server 2000) and this introduces the user to error message: 15048, which arises when an incorrect database compatibility level is used....
|
|
-
|
|
Whenever we talk about inclusive date comparison & filtering in T-SQL, the only two options that come to mind are the BETWEEN clause and the greater than (>) and less than (<) operators paired with the equal to operator. Today, let us attempt to find out if there is a difference between the two.......
|
|
-
|
|
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....
|
|
-
|
|
How can connection strings be used to change the behaviour of an application? In this post, we explore the use of the system function APP_NAME(), which returns the application name for the current session if set by the application....
|
|
-
|
|
What would you do if someone tells you to parse and compile a T-SQL query without executing it? While there is no mechanism to realize this requirement through the SSMS UI, one can use the SET option - NOEXEC. This post is a quick introduction to the NOEXEC option....
|
|