Viewing 15 posts - 11,236 through 11,250 (of 22,214 total)
It's a fairly thick set of data. I've outlined it all in the second chapter of my Query Tuning book.
February 23, 2012 at 12:41 pm
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...
February 23, 2012 at 12:36 pm
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...
February 23, 2012 at 12:32 pm
SqlSpider... (2/22/2012)
Will these indexed views improves the Performance..?
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...
February 23, 2012 at 8:09 am
GilaMonster (2/22/2012)
Would you have been irritated if your regional mentor or an organiser of another SQL Sat in the same area had...
February 22, 2012 at 7:38 am
dopydb (2/22/2012)
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...
February 22, 2012 at 6:44 am
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...
February 22, 2012 at 6:42 am
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...
February 22, 2012 at 6:09 am
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...
February 22, 2012 at 4:18 am
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...
February 21, 2012 at 8:52 am
Jeez Jeff. Next time mark it URGENT or NEED HELP NOW. Then I'd be sure to ignore it.
By the way, as far as posting goes, I didn't set it up...
February 20, 2012 at 4:03 am
It partly depends on your table structure. What's the cluster key? If you're looking at a heap, or if the cluster key distributes the data across the whole database, then...
February 20, 2012 at 3:49 am
Yes, sorry, SQL Data Compare, you're right.
Hmmm... I think you need to view server state to make that work.
February 16, 2012 at 10:09 am
Stefan Krzywicki (2/16/2012)
Brandie Tarvin (2/16/2012)
February 16, 2012 at 7:49 am
Jeff Moden (2/16/2012)
Grant Fritchey (2/16/2012)
Get a copy of Red Gate SQL Compare and just capture the data that exists in one database, but not the other. Very easy that...
February 16, 2012 at 6:49 am
Viewing 15 posts - 11,236 through 11,250 (of 22,214 total)