|
|
-
|
|
Can connection strings help application implement auditing and changing behaviours based on the calling application? Can a well-defined connection string aid administrators in troubleshooting problems with an application? Here's a best practice that I follow: Always use the Application Name and Workstation Id parameters....
|
|
-
|
|
Completion mode for Intellisense in the SSMS for SQL 2012 does not work in the same way as it used to in SQL 2008. In today's post, I explore how to toggle completion mode and make Intellisense in SSMS 2012 behave similar to SSMS for SQL 2008....
|
|
-
|
|
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?...
|
|
-
|
|
Have you ever wondered as to which database is first made online when a SQL Server instance starts? When are user databases made available in the startup sequence? When is the tempdb available? Today, I try to find answers to these questions....
|
|
-
|
|
If you wish to copy the column headers from the results tab of the SQL Server Management Studio (SSMS) alongwith the results to another program like Excel, use the built-in functionalities of the SSMS demonstrated in this post....
|
|
-
|
|
Queries appear to behave in a similar way under NOEXEC and FMTONLY SET options. Hence, how is FMTONLY different from NOEXEC? Does it really execute a query when there are no visible side-effects of the query execution? Today's post attempts to answer this question....
|
|
-
|
|
If applications need to know the format of the response and test a query without actually running the query in SQL 2012, they can use sp_describe_first_result_set, sys.dm_exec_describe_first_result_set or sys.dm_exec_describe_first_result_set_for_object. The query is parsed, compiled, executed and only the meta-data is returned to the client application....
|
|
-
|
|
The FMTONLY option can be SET to ON if applications need to know the format of the response and test it without actually running the query. The query is parsed, compiled, executed and only the meta-data is returned to the client application. ADO makes use of such a mechanism as a "dry-run" before actually executing a query. The FMTONLY is recommended only for SQL 2008 R2 and below....
|
|
-
|
|
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....
|
|