The solution posted by Cadavre looks very complete.

One possible change, when looking at the situation where there are fewer columns, in the SELECT clause, I'd probably use COALESCE instead of...

I believe it's part of this report.

That book is absolutely the place to start.

Performance monitor is one of the tools you'll use to capture metrics. Those metrics are listed in the book. You're also going to...

It would be very helpful to know the error.

You can attach an image by scrolling down. There's a section below called Attachments.

Company I worked for did regular searches of the internet for the use of their name. One hit came back on Ebay. A stolen laptop was being advertised for sale...

ScottPletcher (4/13/2015)

---

Yeah, a couple of hundred rows with no overlap is not much of a test bed. But the plan still shows what I expected: the UNION-only queries concat...

It made me curious, so I put this together real quick:

SELECT a.City,

a.PostalCode

FROM Person.Address AS a

WHERE a.City...

And if you are getting multiple results, instead of DISTINCT which is an aggregation command, use TOP 1 with an ORDER BY of some sort. That's much more likely to...

SQLRNNR (4/13/2015)

---

Grant Fritchey (4/13/2015)

---

SQLRNNR (4/13/2015)

---

Grant Fritchey (4/13/2015)

---

SQLRNNR (4/13/2015)

---

Grant Fritchey (4/11/2015)

---

I'd suggest checking out Jonathan Kehayias article in Simple Talk on monitoring tempdb usage through extended events[/url]. If it doesn't include...

Brandie Tarvin (4/13/2015)

---

edyeh (4/13/2015)

---

I did an analysis showing procs that use high I/O and cpu resources, but I'd like to isolate the procs using the tempDB the most without going...

Especially when doing an ONLINE rebuild, it's a combination of the transaction you're running to rebuild the indexes (might want to break that down to smaller transactions) combined with the...

Yes. A query hash is based on the query itself. So:

DBCC CHECKDB('Myfirstdatabase')

Is going to have a different hash value than:

DBCC CHECKDB('ADifferentDatabaseEntirely')

No shocks there at all.

SQLRNNR (4/13/2015)

---

Grant Fritchey (4/13/2015)

---

SQLRNNR (4/13/2015)

---

Grant Fritchey (4/11/2015)

---

I'd suggest checking out Jonathan Kehayias article in Simple Talk on monitoring tempdb usage through extended events[/url]. If it doesn't include capturing the queries,...

The biggest part of the undertaking won't be making the calls to the objects. The biggest part of the work is all the modifications you'll have to make to all...

I'm with Gail.

Although, if you wanted to you could make this a derived table and then GROUP BY the function. But I don't think it will help your performance any....