Actually, the included columns make the leaf index entries larger. Therefore, fewer entries per page, which translates to more B-tree above. So there is a size cost for the entire...

Nice article.

Consider adding the checksum column as an INCLUDE column to the PK index on the table. Your milage may vary because:

1) The lookup transformation component only needs to read...

I'm just getting into this myself, but here is what I understand:

1) Yes, each instance has its own service master key, and each of them needs to get backed up...

There have been other QoD's that contained "mistyped" code that would cause unintended results. This one is just different because the SQL syntax analyzer catches an error and writes an...

I would vote for a comment on the ADD CONSTRAINT that it had an intentional syntax error. Sort of like editors adding "[sic]" in a quote to let people know...

In addition to duration, I would look at start and stop times of each call. The duration is just the amount of time within SQL Server. If there is something...

Definitely break that delete into multiple smaller batches/transactions if at all possible. Also, make it "restartable" by simply rerunning the script/query, in case something like this happens again.

Any transaction...

Oops, I checked. The two part schema.object form of name is considered "fully qualified" for plan caching; you don't need to prefix names with the database.

Sorry for sharing my confusion....

Full three part naming helps the query optimizer recognize and reuse queries in the execution plan cache. Queries with unqualified names, including those in stored procedures, have to be fully...

Yes, you should definitely avoid using the sp_ prefix. Not just the performance hit, since it always checks the master and resource databases first. Also, the next version of SQL...

Actually, you've got it backwards! It's "what's the value to the community?" of having the MVP designation?

A noobie looking at a blog or forum may not know who is...

About 90% of people who think they are doing "data modeling" are actually doing "database design." Which is it you are trying to do?

A commercial tool which I have used,...

You may also be running afoul of a "new" Windows security feature, if your Enterprise edition is a more recent SP than the original Standard edition install. So I would...

Yes, the database owner is one of the more important things to watch out for.

If you do detach and reattach databases (especially system databases) to move them, make sure you...

As of SQL Server 2005, you can use ALTER DATABASE and just take the database OFFLINE during the move. See BOL under "Moving Database Files." This section has separate instructions...