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...

Antivirus Exclusion Policy for SQL Server

Anti-virus & SQL Server on one system together are friends not enemies, if configured properly.
Anti-virus are very useful programs from security,...

Colorado SQL Events for April 2014

SQL Meetings are training events for SQL Server professionals and those wanting to learn about SQL Server. Please note that...

Curation and Performance

I’m trying out a new web site from Microsoft called Curah! that is all about curation. Curation is basically what...