Viewing 15 posts - 12,766 through 12,780 (of 22,232 total)
Craig Farrell (4/14/2011)
I'm going to assume I'm just too...
"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
April 14, 2011 at 6:08 am
mohammed moinudheen (4/14/2011)
I have seen many job postings which requires people knowledgebale 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
April 14, 2011 at 6:04 am
Nice article Craig. The company I left put up a SQL Superman job to try to replace me, despite my protests. My old boss just kept saying "Let's see what...
"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
April 14, 2011 at 6:01 am
GilaMonster (4/14/2011)
fname lname-1111520 (4/14/2011)
"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
April 14, 2011 at 5:58 am
Craig Farrell (4/13/2011)
Is it just me or does the constant resizing of the new ad 'Click here to monitor SSC' annoy the hell out of the rest of you, too?
There'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
April 13, 2011 at 12:21 pm
ChrisM@home (4/13/2011)
CirquedeSQLeil (4/13/2011)
Grant Fritchey (4/13/2011)
Teh Gila Monster has teh big scares on me and makes me afeared fer me woefully inadequate sexual equipment.*cough*
That should help.
Don't you have to turn your...
"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
April 13, 2011 at 12:15 pm
ChrisM@home (4/13/2011)
Grant Fritchey (4/13/2011)
ChrisM@home (4/13/2011)
varun.dubey29 (4/13/2011)
"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
April 13, 2011 at 12:14 pm
Timothy Straub (4/13/2011)
Thanks for the info and yes I am testing the performance of a query. I was hoping to be able to test a separate DB...
"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
April 13, 2011 at 10:06 am
CirquedeSQLeil (4/13/2011)
How many of you would walk out on a job without completing it (as a contractor/consultant) - if you were getting paid?
Hard one to answer. Unless there was a...
"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
April 13, 2011 at 10:04 am
Stack overflow is pretty good too.
"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
April 13, 2011 at 9:12 am
It's going after the instance. Why would you do that?
I mean, for testing purposes, fine, but I wouldn't suggest running that in production.
"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
April 13, 2011 at 9:11 am
After the fact, when everything is done, without a trace file available? You can't. If you have a trace running, you can use that to get the user (assuming you're...
"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
April 13, 2011 at 9:10 am
Patrick_Fiedler (4/13/2011)
You can take the following statement:
selectcntr_value as [PageLifeExpectancyInSeconds]
fromsys.dm_os_performance_counters
whereobject_name like '%:Buffer Manager%'
and counter_name like 'Page life expectancy%'
If the value falls below...
"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
April 13, 2011 at 6:19 am
ChrisM@home (4/13/2011)
varun.dubey29 (4/13/2011)
"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
April 13, 2011 at 6:12 am
First thing I'd do is bump the cost threshold for parallelism up to a much higher number. The default of 5 is ridiculously low. Start at 30 and then adjust...
"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
April 13, 2011 at 6:00 am
Viewing 15 posts - 12,766 through 12,780 (of 22,232 total)