Viewing 15 posts - 18,991 through 19,005 (of 22,219 total)
It'll still result in poor performance and recompiles. I still think the better approach is a wrapper proc calling x number of other procedures.
"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
December 18, 2008 at 11:09 am
I grew up on Redneck. I can mostly understand it, but I can't really speak it much any more (except the occasional y'all that comes out every now & then).
"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
December 18, 2008 at 10:14 am
Ah, but other DMV's will capture the parameters, the execution plan, aggregate performance characteristics... And they all join together and all through TSQL queries...
"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
December 18, 2008 at 8:31 am
I just checked and, according to one my local Oracel DBA's, the situation is the same there, so I'm not sure what your Oracle guys are getting at.
"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
December 18, 2008 at 7:47 am
Ah, reading the entire article... what a concept.
"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
December 18, 2008 at 7:18 am
I thought your name was Carpal Tunnel? Now I'm so confused.
"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
December 18, 2008 at 6:57 am
Heck yeah.
I mean, did you ever see this before:
http://support.microsoft.com/kb/931279
Great. Something else to worry about.
"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
December 18, 2008 at 6:55 am
And make sure you have enough space on the disk.
You might have problems with the query you're running as well.
"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
December 18, 2008 at 6:54 am
Is it the query that's slow or the insert? Can you post an execution plan?
"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
December 18, 2008 at 6:50 am
User tables, as has already been stated, are your tables. This is opposed to system tables (and views) which are the management tables (and views) for SQL Server itself.
"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
December 18, 2008 at 6:49 am
Gail beat me to it. You're in a brave new world. Use the DMV's and DMF's liberally. They're great and provide a lot more information in a much clearer fashion...
"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
December 18, 2008 at 6:47 am
That's a huge topic. I posted an article [/url]on it that just barely scratches the surface. It can at least get you started so that you can begin to ask...
"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
December 18, 2008 at 6:40 am
Why on earth would you need millions of records in a front-end app? People won't even read thousands of records. Most people don't go past the first screen, except 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
December 18, 2008 at 6:37 am
I would really want to see the common access paths of the queries prior to trying to decide the cluster. Honestly, if SITE_ID is the most frequently used query mechanism,...
"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
December 18, 2008 at 6:31 am
Good luck. I assume you're not getting paged on the deadlock events? I would be, so I'd sure as heck get a resolution in place prior to Christmas.
"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
December 18, 2008 at 6:29 am
Viewing 15 posts - 18,991 through 19,005 (of 22,219 total)