Viewing 15 posts - 16,786 through 16,800 (of 22,219 total)
That could be the compile time and the time needed to move the data from disk to memory and from there to your machine. All that adds up. Instead of...
"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
August 6, 2009 at 6:29 am
It does depend on what you're trying to do. You can save a query as a view, a procedure, a function... If it's just a pre-defined select statement, you probably...
"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
August 6, 2009 at 6:27 am
A CTE can be used multiple times within a single statement, but it can't be shared across statements. If you need to use it twice, you'll either have to create...
"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
August 6, 2009 at 6:24 am
Jeff Moden (8/5/2009)
He's mine, please... all mine... pork chops in progress. I don't want to start a dog pile on him, but he's mine.
I recognize that mood. Have fun!
"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
August 6, 2009 at 5:46 am
Grant Fritchey (8/5/2009)
I'm feeling a bit stupid. I thought RPG = Role Playing Game.
While I may be that old, I did get my start in IT a little later than...
"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
August 5, 2009 at 9:31 am
TheSQLGuru (8/5/2009)
Grant Fritchey (8/5/2009)
I can't support .rar compression files at work (don't ask). Can you zip the files?Grant, aren't you supposed to be doing WORK at work?? 😀
SSHHHHHH!
"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
August 5, 2009 at 9:23 am
I'm feeling a bit stupid. I thought RPG = Role Playing Game.
"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
August 5, 2009 at 9:23 am
We've been using Microsoft Visual Studio Team Edition for Database Professionals. It allows us to hook right into the existing development metholodogies with labelling, version control, build #'s, the works....
"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
August 5, 2009 at 7:43 am
Jack has largely nailed it. ORM tools speed up development, but at the cost on the database side of things. Using the tool straight, no modifications, you get lowest common...
"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
August 5, 2009 at 6:55 am
sward (8/4/2009)
I'm not really sure what you could use to get this using Top 1. Am i...
"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
August 5, 2009 at 5:53 am
I can't support .rar compression files at work (don't ask). Can you zip the files?
"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
August 5, 2009 at 5:48 am
sanketahir1985 (8/3/2009)
No, i m running the trace from my local pc.
Through the graphical user interface? If you're running a trace through TSQL, it's not running on your local machine, it'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
August 5, 2009 at 5:45 am
Steve Jones - Editor (8/4/2009)
"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
August 5, 2009 at 5:33 am
Exclusive locks are occuring because data is being manipulated, inserted, deleted or updated. Where's the issue?
"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
August 3, 2009 at 7:12 pm
Queries don't automatically use multiple processors to run. MAXDOP defines a limit on how many processors can be used, not on how many will be used. SQL Server also uses...
"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
August 3, 2009 at 1:31 pm
Viewing 15 posts - 16,786 through 16,800 (of 22,219 total)