Sure. Go read this book by Denny Cherry.

I was wondering who was going to break it to him.

Congrats Jason.

You can always look at the backup files themselves to understand the structure of the database that was backed up. I have an article on that on Simple-Talk[/url].

SQLRNNR (2/19/2014)

---

Grant Fritchey (2/19/2014)

---

rodjkidd (2/19/2014)

---

Jason,...

rodjkidd (2/19/2014)

---

Jason, not sure about...

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...