Ha! Don't hold your breath. I still haven't received the first chapter.

SQLRNNR (3/13/2013)

---

It might be typical for your environment. But that doesn't mean it has to be acceptable.

That many parallelism deadlocks can mean that you have a lot of poor...

SQLRNNR (3/13/2013)

---

You are dealing with a Debbie Downer.

XE is far more than what Grant said and obviously far more than Debbie said. XE can get you information about spinlocks,...

Sergiy (3/13/2013)

---

Year, hard to argue.

Except, probably, for this one:

Grant Fritchey (3/13/2013)

---

But, if you have to do individual inserts (and I'd be curious why), then small sets of transactions, say 10,000...

Extended events are the future. Trace events and Profiler are on the deprecation path. Just on that alone, you're doing the right thing. But the fact is, extended events operate...

What I meant was store the Month & Day values as those, either during the insert/update process or as calculated columns. Performing functions on columns in any kind of criteria...

That's a screen capture of an execution plan. Not the execution plan. There are properties behind all those operators that tell a more complete store than just the graphical pictures.

The amount of storage is the cause of IO, not the potential storage. If there are 300 bytes not used, they're not used. There's no additional cost for that. It's...

No, you won't get a conversion. You may see truncated data of course, but no conversion.

Default ANSI connection settings maybe?

Take a look at the SELECT operator in both plans. Compare every value. What's different?

A million individual insert statements is a horrible approach. Period. Doing it within a single transaction will be painful because you're going to have to have a huge transaction log...

Without the execution plan to look at details, it's hard to know. Recommended indexes are just suggestions. First, I'd take a look at the SELECT operator to see if you're...

You're getting type conversions on a couple of the columns. I'd look to see if that might be causing issues. Also, a Nested Loops join for millions of rows with...

I agree. Constantly learning. I write anyway because someone has to do it. And yeah, the old...

Bhuvnesh (3/8/2013)

---

Grant,...