I've never used this, so I don't have a good answer for you. The suggested Microsoft answer is to switch to using SSRS to generate HTML. They don't have a...

Server-side trace, not Profiler, please. The Profiler gui can have serious negative impacts on performance and really shouldn't be used against production systems.

Further, since you're on 2008, you could look...

And just using snapshot isolation, as opposed to read committed snapshot, requires changes to the code which people are usually not prepared to make. I'd just recommend using read_committed_snapshot as...

I'd be interested in seeing the execution plan to better understand how things are resolving, but, this alone will lead to scans of the temporary table:

ON CAST(Machine.MachineKey AS VARCHAR(50)) COLLATE...

Gazareth (2/19/2014)

---

Grant Fritchey (2/18/2014)

---

"I can't believe you're asking me all these product specific questions. You shouldn't be writing your queries using product specific language because that eliminates the ability to...

"I can't believe you're asking me all these product specific questions. You shouldn't be writing your queries using product specific language because that eliminates the ability to quickly and easily...

The first server on both systems has pretty similar waits. It's the second servers where things get different, especially with the async_network_io, which doesn't usually indicate network problems. Normally it's...

It's not that you set up full blow failover clustering. But you have to set up the clustering services. The documentation is pretty clear on exactly how you have to...

Buy more memory. My laptop has 32gb of ram. Running a SQL Server instance on 4gb in this day and age is crazy.

Problem with only having the wait statistics after the query and not both before and after is that we can't tell what waits were experienced by the query. You need...

Nicely done. Absolutely excellent first article.

If I may, I'd like to clarify a couple of points. I wouldn't classify XML as a separate plan type (although I probably did in...

It could be the network configuration, but it's hard to say. I'd suggest capturing the query metrics on both machines, the execution plans on both machines, and, most importantly, the...

Patches should pretty much always be applied, but it sounds like you have some type of translation issue going on. Something in your code has told SQL Server to expect...

rodjkidd (2/18/2014)

---

Went to the London UG / SQLSupper with Mark Souza, Connor Cunningham et al for 2 hours of, I guess you would call a State of the Union...

Ingrate!

Kidding.

Interesting take. I sure don't think that management hands down tablets for us. In fact, the opposite. We should be telling management what we're doing and how we're doing it....