Ah, so it would be extra recompilation, but no manual cache management. Thank you. This is what happens when I don't run a Google search before posting. :blush:

Gail, thank you for the reply.

It also seems likely that you'd end up...

Thank you so much for this series.

I have a question about when an index is finished building. For this question, let's say we're talking about a table with no indexes...

Schodoodles (5/6/2011)

---

SQL Server is already used by F1 teams .... a quick web search finds that Microsoft has this as one of their case studies... maybe I'm one of the...

HIPAA and, to a much lesser extent, PCI are what we have to comply with. The approach we took was to actually turn it into a competitive advantage of sorts....

Steve, thank you very much for the quick reply.

To expand on the Clayton's question, what are the advantages registering for the Summit via SSC rather than directly through PASS? I've never been to a PASS Summit, so I...

Suresh, to get that information for all tables in the database, remove the WHERE clause from the original query.

My number 1 incorrect assumption has been that I know enough about SQL Server.

WRONG!!!!!

There's something to learn or improve on every day without even including the new...

Hopefully these concerns won't be a big deal once Microsoft, Oracle, et al finish their SQL-AutoMagic modules.

If you read the blogger's bio, he's a financial journalist turned tech journalist. I'd be surprised if he could spell "relational database" without a spell checker.

James, you hit it right...