Want to Make Your SQL Server Run Faster for Free?

I know I do!
The trick is to properly manage your VLFs.
What are VLFs? The short anser is that VLF...

XQuery for the Non-Expert – XMLNAMESPACE

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
Let’s talk...

I am a Risk Taker

Somewhat of a strange title, but it’s been an interesting journey to understand that I do take risks and to...

Part of the Election Review Committee...

... and I'm wary, but not weary. I'm not weary because I'm looking forward to trying to help. I'm not weary...

Reason for Early Termination of Statement

Wouldn’t you like to know why the optimizer stopped tuning the execution plan you’re looking at? It’s actually possible and...

Recompiles

I’ve looked at cache hit and miss events and at the cache insert and remove events. The only cache-monitoring event...

Scheduled Out

I’m all scheduled out for the next week with newsletters and content ready to go through Nov 29. I’m not...

SQLSaturday#59 Special Interview with Melissa Demcsak, aka SQLDiva

 SQLSaturday#59 Special Interview with Melissa Demcsak, aka SQLDiva
Only two days left until our super SQLSaturday#59 event.  Hope all is well...

What’s New in SQL Server “Denali” CTP1

Denali. No, not that one...

How many of you have heard that the Community Technology Preview (CTP1) for the next version...

XQuery for the Non-Expert – Terminology

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
It’s time...