Viewing 15 posts - 16,351 through 16,365 (of 22,221 total)
Have you tried watching trace events to see where or when you're getting either recompiles or cache miss events? If you can nail down when it occurs, you might be...
"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 8, 2009 at 7:09 am
Bhuvnesh (10/8/2009)
Below query is giving error : "Must declare the scalar variable "@tblRules"."
please tell me how can i use table variable in the below scenario. i cant use temp...
"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 8, 2009 at 6:46 am
Usually, but not always, when you run the query in SSMS, you will get a line number for the error. But that's a pretty thin reed to hang your troubleshooting...
"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 8, 2009 at 6:44 am
Oh, and I'm not sure this was suggested, have you updated the stats on the new server? If so, did you use the FULL SCAN option? If not, I'd try...
"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 8, 2009 at 6:00 am
Rambler (10/8/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 8, 2009 at 5:57 am
ritesh.kansara (10/8/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 8, 2009 at 5:51 am
Dave Ballantyne (10/8/2009)
Can anyone wave their magic sql wand ?http://www.sqlservercentral.com/Forums/Topic799860-149-1.aspx
EDIT :
Maybe its ItalianOlgi's first day on the job
Hammmer. That's the answer. A good hammer will fix or replace just 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
October 8, 2009 at 5:42 am
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
Viewing 15 posts - 16,351 through 16,365 (of 22,221 total)