1) sysprocesses is deprecated and will be removed from SQL server (in the next build if my memory serves). Like Grant said, you really should switch to various system...

just binoogle the two words and several useful support articles and blog posts show up at the top.

That says it all right there. I have come across...

Glad I could help!! 🙂

Perhaps you could post your solution? One reason is so others can search for your issue and find a solution. The other is...

Fast tlog disks on both machines, and a very low latency fat network connection are key to good mirroring throughput. You should do a file IO stall and wait...

datetime is a datatype for storing a date value that includes the time. What you are asking for is the date ONLY (no time), and in a specific format....

For me the biggest limitation in Standard Edition is the RIDICULOUSLY LOW maximum memory. Fortunately you can supplant that with SSD storage to some degree, although I will caution...

Hey Erland!! What are you doing here - are you lost? Welcome to SSC.com! 😀

There is at least one bug fix for CMEThread waits: http://support.microsoft.com/kb/2492381

dedicatedtosql (7/17/2013)

---

Thank you very much for the reply. So all the memory that SQL Server process is taking up is called the Buffer Pool. In other words when we configure...

jallmond (7/17/2013)

---

TheSQLGuru (7/16/2013)

---

I think another of the root causes is that DPVs just never got any real loving from the product team and haven't had much attention in many years...

jallmond (7/16/2013)

---

UPDATE: For anyone that may encounter a similar issue.

I've dug a bit deeper, and I think what is happening is that sometimes the generated query plan undergoes partition...

I am not sure full text indexing will help with the '%' + column + '%' join ...

I would LOVE to help you with this, but it goes WAY beyond the primary purpose of a forum post - that being short, targeted, straight-forward assistance. What you...

Local variables inside sprocs get you plans that use either average density for equality or 30% of all rows for inequality. This can help in some cases, but it...