|
|
-
|
|
Recently, the IT department at the office undertook a hardware technology refresh cycle. To facilitate the IT department, we were required to send out a list of all installed programs & supporting components so that they could provide us with new computer systems up-to-date with the right versio......
|
|
-
|
|
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....
|
|
-
|
|
Are your SQL Server instances up-to-date? Use official SQL Server Build lists to know about the latest releases of SQL Server....
|
|
-
|
|
In this post, we see that temporary tables allow the use of only 116 characters out of a possible 128. How are temporary tables named, and what happens to the restricted length of 12 characters? What is the naming logic for temporary tables?...
|
|
-
|
|
How can one implement a scenario wherein a table needs to be passed over to a stored procedure, modify the table inside it and then consume the results outside of the procedure? We can share temporary tables through stored procedures and today we look at the various scope definitions of these temporary tables....
|
|
-
|
|
In this post, I explore whether one can use the SQL Server Management Studio (SSMS) can be used to test a connection string. This is related to the post I wrote ealier about how adding the Application Name and the Workstation ID in a connection string are recommended best practices because these would help system administrators and DBAs troubleshoot problems faster....
|
|
-
|
|
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....
|
|
-
|
|
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 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....
|
|
-
|
|
When documenting a database, one of the first things that is done is to document the list of tables in the database and the primary and foreign keys to establish a relationship between them. Today, I will share 7 different scripts to identify primary and 6 different scripts to identify foreign keys within a SQL Server database....
|
|