RIF? Reading Is Fundamental?

Educate the old guy.

Without more information I'm just guessing. It could be that different parameters for these queries results in simply different result sets. If it's accessing more data (the increased number of...

If you have the enterprise level of SQL SErver 2008 or better, you can use the Data Collection, also known as the Management Data Warehouse, to collect performance metrics about...

The precise formulas are totally propriatary, but basically it works off the statistics available about the indexes. The more accurate those stats are to the underlying data and the more...

Jonathan Kehayias (1/19/2012)

---

+1. A really good book isn't necessarily due to the authors own knowledge. ...

And if writing a book carries weight (I'd argue it doesn't, but...) then I do have a book about the Profiler and I also argue for using the server-side trace...

I strongly recommend setting the log to that larger size and leaving it there. Shrinking it over & over and letting it auto-grow over & over, that's causing fragmentation and...

You can change the compatibility level with connections in place. But according to the Books Online, if you do that, you could get incorrect results in queries or other odd...

Performance tuning is hard. It's difficult and it's time consuming and no, there are no reliable and accurate shortcuts.

You can fix some simple stuff by running software like SQL Cop...

There are legitimate practice tests you can take. Check the Microsoft web site. They list them there.

Brandie Tarvin (1/19/2012)

---

If I've already announced this here, I apologize for the repost. I'm just so excited I can't remember where all I've shared the news already.

I am beyond thrilled...

SQLRNNR (1/18/2012)

---

L' Eomot Inversé (1/18/2012)

---

SQLRNNR (1/18/2012)

---

anybody know a good resource for exporting into sqlplan format the xml from sys.dm_exec_query_plan(qs.plan_handle) for a smallish subset of ~100 plans?

I have been able to...

TravisDBA (1/18/2012)

---

Grant Fritchey (1/18/2012)

---

The thing is, you can still use Profiler with all the cool stuff it does for you. It can generate TSQL for you to output trace events...

The thing is, you can still use Profiler with all the cool stuff it does for you. It can generate TSQL for you to output trace events to a file,...

TravisDBA (1/18/2012)

---

TravisDBA (1/18/2012)

---

Dave Ballantyne (1/18/2012)

---

It hasnt been said explicity in this thread , so i will 🙂

Never...