Rolling back transactions with cursors and local variables.

I’ve been doing some work on a credit card payment system lately. Obviously this needs to be robust and consistent...

Smart Moves with SQL Server VMs – Data Movement

Today marks another installment in my ‘Smart Moves with SQL Server VMs’ blog post series. Today we are going to...

Webcast Follow-Up: Introduction to Columnstore Indexes

Similar to yesterday’s post, I have a follow-up for another Pragmatic WorksTraining on the T’s session that I delivered last month....

Analyzing CXPACKET waits

One of the most common wait types you will see on a SQL Server is the CXPACKET wait type.
This...

Dedicated Administrator Connection

By David Postlethwaite

At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...

this isn’t thunderdome

When I received my first MVP award for SQL Server it was fairly abstract to me until I went to...

Vote for me at SQLBits

SQL Bits XII is coming this July to Telford in the UK and voting is underway for sessions. I’ve submitted...

Webcast Follow-Up: Introduction to Clustered Indexes and Heaps

Last month, I presented a session for Pragmatic WorksTraining on the T’s titled Introduction to Clustered Indexes and Heaps.  I’d meant to...

[SQL Snacks Video] SQL Server Table Partitioning 101

I hope you’re hungry for another SQL Snack! In fact, this will be one of a series of snacks (dare...

Answer - Objective Question (How many Null values in an unique constraint can be inserted in SQL Server)

Question:- How many NULL value allowed in a column in which Unique constraint is defined in SQL Server?

Options:-

a) 1

b) 2

c) More...