Viewing 15 posts - 11,236 through 11,250 (of 22,224 total)
LutzM (2/25/2012)
Jeff Moden (2/25/2012)
Returning to the original subject of this thread, I can now say I've seen just about everything on this fine forum.http://www.sqlservercentral.com/Forums/Topic1257783-391-1.aspx
<shudder>
It becomes rather scary when seen in...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 25, 2012 at 12:28 pm
Jeff Moden (2/25/2012)
Returning to the original subject of this thread, I can now say I've seen just about everything on this fine forum.http://www.sqlservercentral.com/Forums/Topic1257783-391-1.aspx
That's just an ouchie. No other way to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 25, 2012 at 12:18 pm
I'd suggest picking up a copy of Itzik Ben-Gan's excellent book, TSQL Query Fundamentals
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 25, 2012 at 12:17 pm
Lynn Pettis (2/24/2012)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 25, 2012 at 5:06 am
Stefan Krzywicki (2/24/2012)
BrainDonor (2/24/2012)
HowardW (2/24/2012)I'm not convinced these things are a massive opportunity to learn new skills in details,
I think it depends on the presentation you go to and...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 24, 2012 at 10:02 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 24, 2012 at 5:09 am
Loundy (2/24/2012)
sqlzealot-81 (2/23/2012)
Try re-registering TextMgrP.dll.
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 24, 2012 at 4:57 am
Brandie Tarvin (2/24/2012)
I just tried to check a couple of topics via the notification...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 24, 2012 at 4:38 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 23, 2012 at 2:50 pm
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....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 23, 2012 at 12:46 pm
It's a fairly thick set of data. I've outlined it all in the second chapter of my Query Tuning book.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 22, 2012 at 7:38 am
Viewing 15 posts - 11,236 through 11,250 (of 22,224 total)