Viewing 15 posts - 16,336 through 16,350 (of 22,219 total)
Preet_S (10/12/2009)
The problem was as...
"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 13, 2009 at 8:43 am
GSquared (10/13/2009)
Grant Fritchey (10/13/2009)
mazzz (10/13/2009)
IIRC someone who frequents the Thread writes fiction - have I imagined this? Any pointers as...
"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 13, 2009 at 8:19 am
mazzz (10/13/2009)
IIRC someone who frequents the Thread writes fiction - have I imagined this? Any pointers as to who 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
October 13, 2009 at 7:46 am
jcrawf02 (10/9/2009)
Don't suppose Jeremiah recorded it, or you have an upcoming session somewhere else on LiveMeeting...
"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 9, 2009 at 11:58 am
Hmmm... Is the cost threshold for parallelism the same on all the servers?
"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 9, 2009 at 6:17 am
Absolutely. You have an obligation to yourself to maintain or grow your skill set. Or, you can let your skills stagnate and atrophy and hope that the job your in...
"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 9, 2009 at 5:55 am
Jeff Moden (10/8/2009)
Grant Fritchey (10/7/2009)
As far as targets go, there are two types of vehicles on the ocean. Targets and submarines.
Heh... I was scrolling "up" through the thread when 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
October 8, 2009 at 11:13 am
What do you mean performance testing or functional tests? Many of the functions supported by these have examples that you can use listed in Books Online.
"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 10:34 am
Shark Energy (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 7:58 am
Arggghhh. This is just frustrating.
"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:55 am
I'm sorry, I don't understand. Why do you want to test SQL Server components specifically? Do you mean you want to test the functions that these components support? If not,...
"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:41 am
Yep. Gail's articles are excellent starting points.
Basically, you just need to gather data. Identify which procedures are causing the most pain and then start tuning them. Use perfmon & trace...
"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:34 am
There really isn't a magic formula. Two databases can max out an instance or you could put 200 databases on an instance and still have room for more. It just...
"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:31 am
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
Viewing 15 posts - 16,336 through 16,350 (of 22,219 total)