Sql Server OUTPUT Clause Examples with UPDATE INSERT DELETE MERGE

Posted by Sqltimes
On December 31, 2014
0 Comments

OUTPUT is an interesting clause added starting Sql Server 2005. DELETE Recently, in my previous post, we saw an example with some insight into the usage of OUTPUT clause with DELETE statement. In this post we’ll cover INSERT, UPDATE and MERGE. UPDATE In an UPDATE statement, both INSERTED.* and DELETED.* internal tables are […]

Posted by Sqltimes
On December 27, 2014
0 Comments

Quick one today: Every once in a while, there comes a need to install Sql Server Management Studio on a new laptop. There seems to be some confusion surrounding installation of Management Studio (SSMS) with or without installing the entire engine. Yes, you can install SSMS without installing the entire database engine. Two options: Usually […]

Posted by Sqltimes
On December 24, 2014
0 Comments

Quick one today: A few months ago, this interesting error occurred. As needed new FileGroups were being created and destroyed and that when I ran into this interesting error. Follow these steps to recreate the issue: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 […]

Posted by Sqltimes
On December 20, 2014
0 Comments

Quick one today: In our production code, there are several incidents where “SET ROWCOUNT” was implemented. Over the years, code has evolved with involvement from different developers and they might have made decisions to use this as an immediate fix for the issue at hand. Let’s dig a bit deeper into this feature. Essentially, SET ROWCOUNT […]

Posted by Sqltimes
On December 17, 2014
0 Comments

Question: Paging through records Quite often, when paging through a large set of records, we display a set of records at a time on user interface. Upon clicking next, the next set of records are displayed. In short, this type of paging could be achieved using CTE and ROW_NUMBER(). Every iteration we change the ‘@from’ […]

Posted by Sqltimes
On December 13, 2014
0 Comments

Interesting topic today. When you create UNIQUE constraint on a table, to prevent any duplicate records, there are a couple of options. Create UNIQUE INDEX with necessary columns CREATE UNIQUE CONSTRAINT, if it is a single column In this process, there are a couple of nuances that change this behavior; In particular, the focus is […]

Posted by Sqltimes
On December 10, 2014
0 Comments

Quick one today: Sometimes during normal DBA operations, there would be a need to check for the existence of any active transaction that could be preventing the transaction log from rolling forward with its virtual logs. There is a good command that helps you pull up that exact transaction. 1 2 3 4 5 -- […]

Posted by Sqltimes
On December 6, 2014
0 Comments

Quick one today: Sometimes, there are times where there is a need to quickly prevent/disable any client connections to Sql Server. The occasions that warrant such drastic need are rare, but they do occur once in a while. During a scheduled and planned deployment, we go through the steps to disable web and app servers […]

Posted by Sqltimes
On December 3, 2014
0 Comments

Quick one today: Checking for existence of temporary tables is not the same as regular tables in user databases. See below: 1 2 3 4 5 6 7 8 9 10 11 12 -- -- Sample code to test the existence of temporary table -- CREATE TABLE #Customer( ID BIGINT NOT NULL PRIMARY KEY CLUSTERED […]

Sql Server OUTPUT Clause Examples with UPDATE INSERT DELETE MERGE

Sql Server : Install just the SSMS (Sql Server Management Studio) without entire Sql Server engine.

REMOVE FILE and REMOVE FILEGROUP error message

Sql Server : SET ROWCOUNT limitations

Sql Server : Retrieve the next ‘n’ records after ‘m’ using OFFSET & FETCH.

Sql Server : IGNORE_DUP_KEY setting influences UNIQUE Index and non-UNIQUE index behavior

Sql Server How to find the oldest Active transaction

Sql Server : Disable or prevent all remote connections to Sql Server (aka single user mode)

Sql Server : How to check if a temporary tables exists