I don't think we intended this, but we'll have to decide how to handle it.

Cool

Kids do streaming and games

I downloaded the MCM prep videos and watched them. I read a decent amount on it but still read more on my phone. I also...

Index key column is the column used in the index, and used by the optimizer to decide of the index is applicable. It's also used by the execution engine to...

Partitioning isn't an option with Workgroup Edition. Need Enterprise Edition for that.

2mm isn't a lot. 200mm, yes. However that depends on table design. If I had a narrow table, say...

If you get tired, stop off...

Haven't heard from anyone about Sp1 for R2 as of yet. I'd expect it soon

Wind, and too much of it.

The problem comes in when T-SQL grows and what was an acceptable word in the previous version is not in this one.

The RDBMS, adhering to some strict academic definition or not, is certainly not dead or a dead end. It works extremely well for many solutions. There might be improved ways...

A few scripts that might help: http://www.sqlservercentral.com/search/?q=copy+backup+to+server&t=s

The index spool is expensive (http://ask.sqlservercentral.com/questions/6268/what-is-index-spool)

However I'm not sure what you're trying to do with the indexed CTE or using triggers to update a table. Is this queried often and...

First, you really need to think about breaking this down and hiring someone with experience. I understand the boss might not want to do that, but perhaps you can collect...

You'll have to test things. There isn't a way to be sure what's best, but here are a few suggestions. Note that the "view" isn't run, but incorporated into the...

Do...