This is because by default the PK is the clustered index and hence the index IS the table.  You will have to specify the PK as a nonclustered index for...

Run this and see what the file sizes are.

RESTORE FILELISTONLY

FROM DISK = 'backupFilePathAndName'

If the combined file size of all the files in the backup exceed the amount of free space,...

QA 2000 does work with 2005, but there will be some issues with syntax highlighting and with the object browser etc...

You can install Management Studio (Query Analyzer and Enterprise Manager...

Agreed, this is the kind of conversation that is really great to have at the PASS Summit...

I'll also agree with the basic premise of your post, we should get the...

Now I'm going back to my old curmudgeon self.  I would counter that you aren't thinking about far too shallowly.  The whole point of database management systems (not just SQL or Relational...

As a sometime author for this site, I really agree with Andy's sentiment.  I hope that Wayne will continue to contribute his experience with the rest of us.  As far...

Just a couple of points here:

In general I don't think that Read Committed Snapshot isolation would be all that beneficial in a DW/DSS system since you generally don't have concurrency...

Yes, I've used it and it works great.  The Read Committed Snapshot (RCS) Isolation level prevents readers from blocking writers and vice versa.  It CAN greatly enhance concurrency, but may actually...

"I would add that a hint is just that "a hint" not 100% of the time you will get what you asked for"

This seems to be a fairly common misconception. ...

I second Collin here.  NOLOCK is fine for some things (as Andy points out).  However, it can be dangerous too and one MUST understand the tradeoffs involved before you use...

The short answer is yes, SQL Server on the IA64 does have the same kind of backward compatibility that the x86 flavor does. 

Longer answer:  I've never been a big...

Obviously, that was some time ago (an eternity in hardware years) but they were single core Itanium processors and of course the Xeons were x86 type architecture. 

Since then the...

Actually you can... (I know, it's weird) however running that command will have no effect since the database is already set to use the Simple recovery model.

OK, that should do the trick, however there are still several things to keep in mind.

1. Setting the recovery to Simple does not shrink the existing file.  If you need...

Let me guess, Mrs. Dori is a DB2 DBA, that's the term that they use for this...

Anyway what she is talking about is setting the recovery model to "Simple".  I...