Going back on topic for just a moment, Gail, did you enjoy the exchange with the guy that wanted to delete his log over on SO? People can be such...

Loundy (2/24/2012)

---

This has helped me in the past: Full command line - regsvr32 "C:\Program Files (x86)\Common Files\microsoft shared\MSEnv\TextMgrP.dll"

Also, If you have a 3rd party IntelliSense installed (such...

Brandie Tarvin (2/24/2012)

---

Is anyone else having trouble getting to topics they've responded to in the past couple of days?

I just tried to check a couple of topics via the notification...

Oh, well then... maybe you need an index.

Oh, and are you on the latest service pack? They had quite a few issues with the RTM version and SP1 didn't fix...

Sounds like the index is no good, but I'll bet you already figured that out.

To get started with spatial, I'd pick up a copy of Alistair Aitchison's book, Beginning Spatial....

It's a fairly thick set of data. I've outlined it all in the second chapter of my Query Tuning book.

Yep, if I suspect a code or structure problem with a query, it's off to the execution plan.

Now, you can query the cache directly. I've posted a few examples over...

You can query the cache, but the output is XML, not text. The DMO you need is sys.dm_exec_query_plan. It needs a plan handle. You can get those from sys.dm_exec_query_stats, sys.dm_exec_procedure_stats...

They can, but it really depends on what you're doing it for, what kind of data is underneath, etc. If you're reading up...

GilaMonster (2/22/2012)

---

Question for those of you who have organised SQLSaturdays

Would you have been irritated if your regional mentor or an organiser of another SQL Sat in the same area had...

dopydb (2/22/2012)

---

hi Grant

good point on the monitoring..

i really dont think its a memory issue as it has 26gb of ram- which is relative i know- but i have seen just...

Stuff like ESX Replication[/url] and DoubleTake make VMs pretty hot. There are whole lot of other management aspects to VM that make them great. My personal take is, unless you...

Virtualization of the server adds a layer of processing and is therefore slower, no matter what.

That said, there are a bunch of reasons to use virtual machines in different environments...

You need to gather metrics on the 2000 server and then pass those on. The code and structure are not going to change by migrating from 2000 to 2005. That...

As far as the apathy goes, most people are apathetic about almost all their basic rights. I'm pretty sure a healthy majority of people would be willing to sacrifice freedom...