Try Performance Advisor from SQL Sentry

bwilliams:

1) welcome to sql server and the sqlservercentral forums

2) PLEASE PLEASE PLEASE do yourself a favor and learn set-based operations. that code you posted would be an...

I want to add that you should be VERY careful about just implementing all of what the missing index DMVs or DTA give you!! They LOVE to include columns...

2 thoughts:

Boy, if I had a dollar for every time someone has done this . . . 🙂

There are so many companies out there using SQL...

2 years ago I had a client running year end tax stuff (payroll processing client) against 4900 or so databases on a single server (which was manually report shipped from...

bell282 (11/18/2009)

---

well, made some progress.. We have a table with about 300,000 records (and one of the columns is an image)... If we delete all the records out...

Picked mine up while at PASS recently.

Dave Ballantyne (11/20/2009)

---

Seems a bit...

C#Screw: I would check the query plans for each. I wouldn't be surprised that the non-function method uses a scan-based plan thus less IO but longer time while...

Hey Lynn - CONGRATS ON PASSING THE 10000 POINT MARK!!!! :w00t:

Hardware is probably the only viable solution here. Lots of RAM will help to keep more pages of data in cache, but that will not get you very far...

This is not necessarily a good thing. You can have a...

Can anyone comfirm if CPU, IO, etc information is accurately tracked and reported via the referenced DMVs when CLR stuff is being executed??

Paul White (11/19/2009)

---

Paul White (11/19/2009)

---

I must admit I am less than clear how sort order affects nested REPLACEs, but at least REPLACE is documented as being collation-aware so there is...

My vote (although...