chrisph (1/11/2011)

---

Geoff, my main concern is not necessairly immediate monitoring but performance analysis over time. I want to be able to consolidate some of my SQL servers and I...

malleswarareddy_m (1/11/2011)

---

If restore the entire database with other name that is difficult its big database contains 360 gb.

so restore entire dtabase is not possible.I want to restore only one table...

PLEASE read this carefully before you lock pages in memory:

http://support.microsoft.com/kb/918483

“You should make additional considerations before you assign the ‘Lock pages in memory’ user right. If you assign this user right...

I am not too clear on exactly what you need here, but I will say that the way to handle complex string manipulations is to break them down into single...

I...

1) different CPUs/motherboards in the two servers could have a significant affect on query performance

2) if your new box has win2008+, is power mode in the default balanced configuration? ...

IIRC there is a trace flag to change the locking escalation behavior. But you best be VERY careful if you decide to implement it. And it still doesn't...

I would like to add that additional tuning is often required as data volumes grow - and you can't really know that without actually testing with the larger volumes. ...

Dynamic SQL is by far the best way to handle this type of scenario I think. I have gotten 5 orders of magnitude performance improvement by using it for...

GilaMonster (1/13/2011)

---

No, and repeatedly shrinking logs is not recommended.

2. Why to run a full backup after...

Peter Trast (1/13/2011)

---

Koen (da-zero) (1/13/2011)

---

Grant Fritchey (1/13/2011)

---

Koen (da-zero) (1/12/2011)

---

TheSQLGuru (1/12/2011)

---

I am curious what you mean by "advisor" here. Hopefully you do NOT mean Database Tuning Advisor!! Avoid that...

>>For the foreseeable future, the best answer is, get someone in who can tune your structures and your queries.

Not true Grant!! I can ALWAYS make time for some...

1) don't put the clustered index on the table and the order by and then run the two versions. Virtually identical timing and resource usage on my mid-grade laptop.

2)...

farax_x (1/12/2011)

---

HI,

I had the same problem and I changed some queries with [with (nolock)] and fastfirstrow ,... to reduce locking and rebuild with ALLOW_PAGE_LOCKS = OFF, ONLINE = on...

I am...