Viewing 15 posts - 18,541 through 18,555 (of 22,226 total)
I can't seem to open the new zip attachment. Sorry.
Looking at the query some more, you've got correlated sub-queries in the select list. This is effectively RBAR (row-by-agonizing-row) processing. Those...
"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 3, 2009 at 5:34 am
Lynn Pettis (2/2/2009)
Matt Miller (2/2/2009)
Lynn Pettis (2/2/2009)
Phil Factor (2/2/2009)
Steve, you're supposed to be on holiday!
Typical geek, can't stay away. I should know, I do the same thing here, even...
"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 2, 2009 at 10:59 am
I agree MSDN. You might also see if there's an introductory DBA book that has a good chapter on it.
"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 2, 2009 at 9:30 am
Unless you're having troubles with the system, I wouldn't recommend changing the PK's on the tables.
That said, int is likely to index a bit better than char(10), so you'll get...
"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 2, 2009 at 9:29 am
idrees.butt (2/2/2009)
I really wana read the books but they will be expensive 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 2, 2009 at 8:49 am
GilaMonster (2/2/2009)
I'd also recommend T-SQL Fundamentals by Itzik Ben-Gan. I've only glanced through it, but it looks good.
I agree. This is also a very good resource. Thinking about it some...
"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 2, 2009 at 8:06 am
idrees.butt (2/2/2009)
Actually I find it always difficult to even understand the topics by which people post their problems. The content is so technical or specific that...
"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 2, 2009 at 7:52 am
I agree with Jeff, portable code is a myth.
For the type of query you're running, let me say one thing, look at the execution plan for each query. I wouldn't...
"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 2, 2009 at 6:58 am
Nice one. Sharp & direct.
"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 2, 2009 at 6:53 am
I do agree with Jeff, but an acquaintance of mine does have a book that could be useful, SQL Server 2008 Accelerated by Rob Walters.
"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 2, 2009 at 6:50 am
You should be able to just give the user execute privileges to the procedure(s).
"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 2, 2009 at 6:38 am
Not without a third party log reading tool.
Why not run a server side trace and capture the transactions being run. Then you can figure out the bad actor.
"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 2, 2009 at 6:37 am
Every system is different, but I personally wouldn't sweat fragmentation until it at least got as high as 20% and probably I wouldn't do a rebuild until I saw fragmentation...
"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 2, 2009 at 6:35 am
krypto69 (1/30/2009)
They run ad-hoc queries, that are taking too long to return. Here's...
"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 2, 2009 at 6:28 am
This was removed by the editor as SPAM
February 2, 2009 at 6:23 am
Viewing 15 posts - 18,541 through 18,555 (of 22,226 total)