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...

Check the connection settings for both Management Studio & the App. You may have differences there that are causing the differences in execution time. Stuff like SET IMPLICIT_TRANSACTIONS, SET ANSI_PADDING.

Do...

True, I forgot about that. Thanks.

That's one ugly debate you're entering into. Short answer is, parameterized queries function the same way as stored procedures. SQL Server will be able to reuse execution plans because it...