Shark Energy (10/8/2009)

---

Ok so then once you have tuned it as best you can (all indexes are in, the 100% in execution plan where it should be and so forth)...

Arggghhh. This is just frustrating.

I'm sorry, I don't understand. Why do you want to test SQL Server components specifically? Do you mean you want to test the functions that these components support? If not,...

Yep. Gail's articles are excellent starting points.

Basically, you just need to gather data. Identify which procedures are causing the most pain and then start tuning them. Use perfmon & trace...

There really isn't a magic formula. Two databases can max out an instance or you could put 200 databases on an instance and still have room for more. It just...

Have you tried watching trace events to see where or when you're getting either recompiles or cache miss events? If you can nail down when it occurs, you might be...

Bhuvnesh (10/8/2009)

---

Hi,

Below query is giving error : "Must declare the scalar variable "@tblRules"."

please tell me how can i use table variable in the below scenario. i cant use temp...

Usually, but not always, when you run the query in SSMS, you will get a line number for the error. But that's a pretty thin reed to hang your troubleshooting...

Oh, and I'm not sure this was suggested, have you updated the stats on the new server? If so, did you use the FULL SCAN option? If not, I'd try...

Rambler (10/8/2009)

---

Is there an easy way to find that from the execution plan? I've looked at the ex. plan, but it's too complex and I'm not sure what exactly to...

ritesh.kansara (10/8/2009)

---

to create the view, I've gone into the management studio and selected view - new view and copy and pasted the above SQL statement into it. I've saved...

Hammmer. That's the answer. A good hammer will fix or replace just about...

We just took the Scout Troop to the local range for a camp-out & shoot. The club that runs the range brought in a stack of .22's for the guys...

Lynn Pettis (10/7/2009)

---

Jeff Moden (10/7/2009)

---

Lynn Pettis (10/7/2009)

---

The last letter I got from her was dated 9/30. She said it was hard to believe that it had be 65 days...

A few functions, mainly system stuff like backups, will show up with estimated completion times in the sys.dm_exec_requests DMV. You can try it, but no guarantee it will work for...