Date tables are amazing! I can't tell you how many times I've found this simple little thing to be a huge time saver. Just being able to bang...

My start in computers had nothing to do with software, but a book. The "Tom Swift" novels by Asimov. I thought working with computers would be the neatest...

I think the assumption in the example is that all fields are being created as NOT NULL by default.

Table 3 doesn't get created because there is no PK defined on...

I'd definitely be a solid, dependable, four-door sedan.

Currently drive a Mercedes-Benz E320, before that a Camry

Red-Gate will launch SQL-Satellite, the first product capable of giving you a birds eye (from many thousands of miles up) view your VLDB.

With infinite drill-down (TM, (c), PDQ) you will...

SQL Server Central for the WIN!

I just migrated a 2008 project to 2010 and all sorts of stuff just broke. Couldn't find half of the DLLs - saved the...

I love the idea of an ebook. I have a number of PDF versions of the hard copy books I have that are great when I want to find...

I have always told any of my employers that "anything is possible, it just might not be probable". If a user told me that doing "x, y and z"...

I'm still not sold on the idea of hydrogen powered vehicles. I've read several articles regarding how "safe" they're going to be because of the delivery system will be...

I don't think we have gone off topic. This salary survey is interesting in the pay scales on average for the various jobs, but as far as trying to...

I've been a member of SSC for quite a while now and usually turn to this site first when I have an issue with SQL Server. If I don't...

This is what I posted on the MS forum for SQL Server in response to this column:

I think enums would be a great feature to add to SQL. I would...

I've often wanted to switch to Open Office, but I found that it's track record for reading/rendering (the last is the most important) of MS documents was not always 100%.

When...

Why was the answer "concurrent" and "continuous"?  The default for sync is "native".  I don't see anything in BOL that states the need to use "concurrent".

The only difference I can...

I agree, the question was misworded.  The question asked "What file groups can be placed on an NTFS compressed volume in SQL Server 2005?"

A database file is NOT a...