Sql Server: EXCEPT statement compare data in two tables

Posted by Sqltimes
On March 29, 2014
0 Comments

EXCEPT is a great operator. More importantly it is a set operator. So, by design it is a bit more efficient. This is part of the great set operators like: INTERSECT UNION EXCEPT UNION ALL EXCEPT Except does two things: Returns values from left query (or data set) that are not in the right query […]

Posted by Sqltimes
On March 21, 2014
0 Comments

Another quick one today: Sometimes, when we receive a new application environment (with in database servers) into our scope of responsibility, there are a list of “sanity” checks we run on them to be sure things are configured correctly. It is a big list, but some of them are listed here: Appropriate backup jobs Maintenance […]

Posted by Sqltimes
On March 20, 2014
0 Comments

Another quick one today: Rare, but sometimes, the need to remove data files from existing databases does arise. Data files (MDF’s & NDF’s) are not like other files on the filesystem to just delete. They are controlled by Sql Server and need to be configured to be deleted; These operations needs to be executed from […]

Posted by Sqltimes
On March 20, 2014
0 Comments

Another quick one today: A few days ago, there was a need to restore a LiteSpeed database backup file into our lab environment. Since we do not use LiteSpeed in our environment we were scrambling to figure out a way. Upon some light reading, it became apparent that there is a command line command to […]

Posted by Sqltimes
On March 18, 2014
0 Comments

Quick one today: Another one of those tasks that keep re-occurring every few days; It is time to blog about it. Database snapshots are a great feature in Sql Server. It is easy to create and brings about immense value with it. In our lab environment, we use it a lot — and for the […]

Posted by Sqltimes
On March 15, 2014
0 Comments

Another quick one today: A lot too often, we find ourselves in a situation where we are pulled into support a new system or help troubleshoot a new database environment. There are a series of checks, I prefer to run when a new system is added to my list of database environments for our team. […]

Posted by Sqltimes
On March 8, 2014
0 Comments

Another quick one today: A few days ago, I wrote a post that illustrates how to generate dummy data; In that there are a couple of DATETIME columns that have random datetime data. This random values are based completely on the RAND() function in Sql Server. Subtracting a random number of days from GETDATE() function […]

Posted by Sqltimes
On March 1, 2014
0 Comments

Quick one today: Sometimes we all need to write/execute stored procedures manually in SSMS. When stored procedures have OUTPUT parameters, the execution is slightly different (counter intuitive). So here is a sample on how to execute a stored procedure with OUTPUT parameters and RETURN statement. 1 2 3 4 5 6 7 8 9 […]

Posted by Sqltimes
On March 1, 2014
0 Comments

Quick post today: Many times in the life of a DBA, we find ourselves in need to quickly create some sample table with dummy data to test some theory. Creating this from scratch every time takes some time (not much, but still some). This is a constant and repeating need and over years this adds […]

Sql Server: EXCEPT statement compare data in two tables

Sql Server Change the ownership of a database

Sql Server: How to remove a data file from an existing database? or How to delete ndf files?

How to extract Sql Server native backup file from LiteSpeed backup.

Sql Server : Create Database Snapshots and restore from snapshot database

Sql Server: Query to list all the permissions of any login

Sql Server: Generate random DATE using RAND() function and GETDATE()

Sql Server: How to execute a stored procedure with OUTPUT parameters and RETURN variables.

Sql Server: How to quickly create a sample table with dummy data