Viewing 15 posts - 16,366 through 16,380 (of 22,229 total)
We just took the Scout Troop to the local range for a camp-out & shoot. The club that runs the range brought in a stack of .22's for the guys...
"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
October 7, 2009 at 4:02 pm
Lynn Pettis (10/7/2009)
Jeff Moden (10/7/2009)
Lynn Pettis (10/7/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
October 7, 2009 at 3:57 pm
A few functions, mainly system stuff like backups, will show up with estimated completion times in the sys.dm_exec_requests DMV. You can try it, but no guarantee it will work for...
"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
October 7, 2009 at 11:25 am
ritesh.kansara (10/7/2009)
i don't understand. I created a select statement ehich worked and then tried to create a view which involved copying the select statementregards
R
I asked if the other objects being...
"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
October 7, 2009 at 11:18 am
Congrats to your daughter Lynn. That really is an accomplishment. And its' one that fewer and fewer people can lay claim to any more.
"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
October 7, 2009 at 9:32 am
I don't run perfmon all day, but I do run Microsoft Operations Manager 24/7 and it's consuming performance monitor counters. As long as you're not collecting too much data or...
"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
October 7, 2009 at 9:00 am
You can use code and SMO to replicate what SSMS does, but no, there's not any easy way to do it with TSQL alone. Besides, SSMS is useful, just don'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
October 7, 2009 at 8:58 am
Rambler (10/7/2009)
I'm aware of the fact, that I'm comparing apples...
"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
October 7, 2009 at 8:56 am
rockingadmin (10/7/2009)
both the tables will have unique values. that's y i make them as primary key.
can i make custid in table2 as primary key and create a composite...
"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
October 7, 2009 at 8:27 am
Alvin Ramard (10/7/2009)
Lynn Pettis (10/6/2009)
Steve Jones - Editor (10/6/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
October 7, 2009 at 7:49 am
The problem is, because the systems are radically different, as well as different versions of SQL Server, you're comparing apples to cannonballs. Best advice is what the post above says,...
"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
October 7, 2009 at 7:47 am
Follow the advice in Gails articles or pick up a book on performance tuning (<cough>, look down, <cough>). You need to gather metrics to identify where your bottlenecks are, 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
October 7, 2009 at 7:44 am
What about using VARCHAR(MAX) and use sp_executesql. According to BOL the @stmt parameter in sp_executesql is only limited by available memory.
"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
October 7, 2009 at 7:40 am
sys.dm_exec_query_stats is what I would recommend as well, but remember that it only shows the queries that are currently in cache. If queries have been executed during the day but...
"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
October 7, 2009 at 7:38 am
You should be able to see the operations that are taking so much CPU within SQL Server. If nothing else, take a look at sys.dm_exec_requests to see what operations are...
"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
October 7, 2009 at 7:36 am
Viewing 15 posts - 16,366 through 16,380 (of 22,229 total)