I've never heard of such a thing. You could simply add a parameter to your function and pass in the calling procs name. It'll be interesting to see if someone...

You may run into problems with this:

FORMAT(BUMetrics.ProjectCompletionDate, 'mm') AS MONTH, FORMAT(BUMetrics.ProjectCompletionDate, 'yyyy') AS YEAR

That's not TSQL syntax.

Yeah, I would have expected to see it begin offering completions when you were typing the schema. That's what I see on my machine. Are you using the November CTP?

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