I'm a little confused. You don't have any kind of WHERE clause on your queries.

This will be updating all records in the table where the join criteria is true, if...

You should try enabling the code and getting an estimated execution plan. That will tell you where the problems are.

Most likely you'll see that you're getting a table scan.

Holy cow. We've been lucky so far then. We've been naming the project after the database. What a mess.

With the initial release, I did find that we were hacking the...

You could change the default file group first. Probably not a good idea to be mucking with that too regularly, but...

ALTER DATABASE dbname

MODIFY FILEGROUP mygroup DEFAULT

Make sure you go into Tools, Options and the select the Text Editor and Transact SQL. The general section there has "Statement Completion." You can get it turned on there....

What about adding a statement from TFS using the tf.exe to get the the version of the project, add that to a variable and pass that variable into the command...

I can't take credit for it. One of the guys in my shop, Scott Abrants, is one of those obsesive compulsive types who has to find the deep dark secret...

Not a problem. Provide a variable, say the TFS version number or something, in the build command line and set the extended property for the database in a Post-Deployment script.

Actually,...

Yes, absolutely. Visual Studio Team Edition for Database Professionals, AKA DBPro, AKA DataDude. This tool has turned around our build & deployments. As a matter of fact, I think the...

First off, the second sample query won't work because the urlpage isn't included in the group by.

For the denormed table, I found that setting the clustered index to the date...

If you look at the execution plans for the two queries, the scalar function looks like the simpler plan. It simply has a clustered scan and a scalar operation. The...

You should probably take a look at the binary data type. I'm not terribly familiar with its use, but I think that's what you need for storing .DOC files. VARCHAR(max)...

Good article. I'm looking forward to more.

Can you point me to a good resource on maintenance considerations, if any, for Compact databases?

Not knowing the structure or the code, it's hard to make suggestions. If you haven't already, check out this white paper from Microsoft. They outline a number of things you...

I think this is a case of buyer beware, your mileage may vary, some assembly required... You get the drift.

Scalar functions, as Adam very clearly outlines, unless they're very...