Thanks Gail

Besides finding the cause of blocking on my system, is it safe to say that if I find queries in my cache where the elapsed_time is more...

I just use variables for the per/second counters

declare @v1 bigint,...

Thanks for your help

Perry Whittle (10/31/2012)

---

SQLSACT (10/31/2012)

---

Perry Whittle (10/31/2012)

---

SQLSACT (10/31/2012)

---

Hi Guys

Please help me understand something the Cluster Quorum and specifically Node and Disk Majority

I understand that if you have an even amount on...

Perry Whittle (10/31/2012)

---

SQLSACT (10/31/2012)

---

Hi Guys

Please help me understand something the Cluster Quorum and specifically Node and Disk Majority

I understand that if you have an even amount on nodes on your...

Have a look at these

http://www.sqlservercentral.com/articles/AlwaysOn/91408/

http://www.sqlservercentral.com/articles/FCI/92196/

That column shows null for adhoc and prepared statements

Guess I'll have to do some serious digging..

Thanks

Grant Fritchey (10/26/2012)

---

SQLSACT (10/25/2012)

---

Grant Fritchey (10/23/2012)

---

There is a setting called 'Optimize for Ad Hoc Workload' that could help you out. Instead of storing a plan each time a query is...

Thanks Guys

SQLSACT (10/26/2012)

---

Hi All

Please help me understand something

I'm testing SQL Agent job ownership

When I make the owner SA, the job executes but when checking the history of the job, it shows...

Grant Fritchey (10/23/2012)

---

There is a setting called 'Optimize for Ad Hoc Workload' that could help you out. Instead of storing a plan each time a query is run, the first...

Thanks for this

Jeff Moden (10/21/2012)

---

The unused space is calculated simply by finding the total space allocated and subtracting the space used by data and indexes. If you want to do a...

GilaMonster (10/14/2012)

---

For a VLF to be marked inactive by a log backup, none of the log records within that VLF must be needed for anything. Anything includes checkpoint, active transaction,...

GilaMonster (10/13/2012)

---

Active. The log records are still needed by something, in this case the checkpoint.

A VLF is only inactive when none of the log records in it are needed for...