A little piling on in this case is good.

I've worked on systems that let the code handle all referential constraints. It failed. Every time. I'm sure it's possible to do,...

You can open the properties of the first operator of the plan when looking at the graphical plan. That will contain the information about which plan guides have been used,...

GilaMonster (2/13/2014)

---

Grant Fritchey (2/13/2014)

---

The fact that you have four clustered index scans and a heap scan should be a bigger concern than sorting cost. And, what the heck, that's a...

There are lots of blog posts on DBA interview questions. Just do a search for them.

The fact that you have four clustered index scans and a heap scan should be a bigger concern than sorting cost. And, what the heck, that's a completely different execution...

GilaMonster (2/12/2014)

---

Benki Chendu (2/12/2014)

---

GilaMonster (2/12/2014)

---

Benki Chendu (2/12/2014)

---

Gila - I would need help in showing my client a document which says 5000 is an agreed value. I can then convince them...

Assuming there's more to this query than in the plan you posted, to get improved sort performance, the best mechanism is eliminating the sort entirely from the plan. This is...

Personally, if it's on the forums, I skip it. If I can't understand what's being asked, even to guess at it, I'm not about to go through the pain of...

Here's an article[/url] I wrote on doing backups that includes new material from SQL Server 2014. It covers all the basics. This is an older article[/url] I wrote on the...

Personally I wouldn't sweat the hot spot aspects of identity columns. That used to be a pretty major problem back in the day (say, SQL Server 7 and earlier), but...

It's possible the query is being run from more than one database.

The real problem is, this is an imprecise mechanism for identifying long running queries. It's completely dependent on the...

A NULL for the Object name would just imply that you're seeing ad hoc or prepared queries that don't have an object because they're not being called by a stored...

pmadhavapeddi22 (2/12/2014)

---

jeff,

I have re written the query by joining the de norm table in from clause, but the no of

reads and cpu are high with the new query. Old query...

Another vote for the Enterprise Policy Management Framework. That really made Policy Based Management take off and be useful in our organization.

I just got in touch with Jorge Segara who wrote the book. He should be by here shortly to get you an answer.