|
|
-
|
|
The ROWVERSION column is an auto-incrementing number. The MIN_ACTIVE_ROWVERSION() non-deterministic function can be used to fetch the lowest active ROWVERSION value in the current database....
|
|
-
|
|
One of the most common mistakes that all developers make is to pass parameters to a procedure based on the expected (ordinal) position and not the expected parameter name. Can you change the parameter sequence within your stored procedure without breaking the calling code?...
|
|
-
|
|
Use a Windows process Id (PID) and not the SQL Server SPID to monitor the SQL Server activity generated by an application process. Use the SQL Server DMV - sys.dm_exec_sessions and the SQL Server Profiler to achieve this goal - very useful when working with applications hosted on a terminal server....
|
|
-
|
|
As Microsoft SQL Server evolves and matures over time, using non-ANSI compliant code will result in rework. One such example is the use of OUTER JOIN operators (*= and *=), which are no longer available with SQL Server 2012. Use the ANSI compliant, SQL-92 syntax instead....
|
|
-
|
|
Returning Result sets is perhaps one of the most common methods used by development teams to debug databse triggers. However, returning result sets from triggers is already marked as a deprecated feature. DBAs can use the "disallow results from triggers" switch to begin educating teams to start moving away from this technique....
|
|
-
|
|
I work with academia frequently, and therefore, get a chance to interact with students and experience the issues they face first hand. I recently had a very interesting experience during one of these visits. I will try to present the experience as a story. The Problem One of the students had devel......
|
|
-
|
|
In a perfect world, any table once designed would never undergo any modifications for the entire life of the product. However, nothing’s perfect and as they say – the only thing that’s constant is that nothing’s constant. Similarly, requirements change and so do table designs. However, there is one ......
|
|
-
|
|
While working on the query editor, I often find myself requiring to switch over to the Object Explorer window. In such cases, I use a little known, underappreciated feature hidden within the pop-up menu of the query explorer. Today, I share this SSMS productivity tip with you....
|
|
-
|
|
We know the sequence in which system databases are made available during restart recovery. However, if a SQL Server instance has multiple user databases, what is the sequence in which these user databases are brought online?...
|
|
-
|
|
What permissions does one need to capture SQL traces using SQL Server Profiler? Is it essential that the user must be a member of the sysadmin fixed server role? This post shows the minimal permissions required for a user to capture SQL traces using the SQL Server Profiler and demonstrates the necessary command to assign a login these permissions....
|
|