Duplicate Identity Values?

Can you have duplicate values in a field with the identity property? Of course, and this does it.
DROP TABLE dbo.MyTable

CREATE...

PASS 2011 Pre-Conference Seminars and Spotlight Sessions Released

I have wanted to go to PASS Summit for the last several years, but have yet to get an opportunity...

Do You Ever Physically Defragment Your SQL Server MDF & LDF Files?

Every since the first file was written to a floppy disk drive using DOS, physical file fragmentation has been a...

DQ & MDM Book Available to Download

If you’re looking for a resource on the Data Quality and Master Data Management features in SQL Server 2008 R2,...

PerformancePoint wish list – change a datasource

One item on my PerformancePoint wish list is the ability to change a datasource for an Analytic Chart/Grid.  There is...

PASS Announces Pre-conference and Spotlight Sessions for PASS 2011 Summit

Today, PASS announced the Pre-conference and Spotlight Sessions for the PASS Summit 2011 in Seattle, which will run from October...

SQL Saturday Pensacola

I know it has been almost a month since I posted last and this is not really a “real” post,...

Re-Focusing the Blog a Bit

In recent weeks I've strayed pretty much all over the map with respect to topics. I have another blog, the...

June Question: How Do You Monitor Your SQL Servers?

As DBAs, one of our biggest responsibilities is to monitor our SQL Servers to ensure they are performing as expected....

SQL Exercise During Candidate Interview Process

A discussion of how BPS uses a SQL exercise for candidates and why it is helpful.
At the Boston Public Schools,...