Judy-363345 (11/13/2009)

---

Hi all,

I got high numbers in SQL Comiplations/Sec and lower number in SQL re-Compilatios/sec using Perfmon.

Some articles said that high SQL Comiplations/Sec means low rate of plan reuse....

Tara-1044200 (11/13/2009)

---

I have more than 300 dbs which i have to move from 2 different drives to a single drive. Is there any script that can automate this process. I...

WOW i always used the for each loop to process files and never knew about multiflatfile feature.

Good one.

Thank you

Moderator:

Please delete all the copies of the original reply.

I think i hit the server during maintenance.

homebrew01 (11/10/2009)

---

We've got some users reporting slow run times for their reports, and I see some blocking, but don't really understand what I'm seeing and am looking for help.

When looking...

homebrew01 (11/10/2009)

---

We've got some users reporting slow run times for their reports, and I see some blocking, but don't really understand what I'm seeing and am looking for help.

When looking...

homebrew01 (11/10/2009)

---

We've got some users reporting slow run times for their reports, and I see some blocking, but don't really understand what I'm seeing and am looking for help.

When looking...

JamesNZ (11/11/2009)

---

Have been looking into general high avilability in SQL Server, and as the boss has ruled out clustering, mirroring seems the next best option.

I've been reading a lot the...

Is your master.dbf on attached storage like ISCSI?

Mani-584606 (10/26/2009)

---

Hi,

I just want to know that is any there way to go back to the same state for Primary and Secondary SQL Instances (i.e state before starting DRT Test)...

I think you have to restart the server after turning it on.

Given that this is a OLTP test.

In step 1 after disabling jobs

Dont forget to restore the last tran log from primary to secondary.

Failing Over to a Log Shipping Secondary

http://msdn.microsoft.com/en-us/library/ms191233%28SQL.90%29.aspx

Changing Roles...

Give us more i love these kind of questions.

Yes if you used

begin tran

something happens

you can issue

rollback tran

http://www.sqlservercentral.com/articles/Administration/fragmentation101/1346/