Viewing 15 posts - 16,606 through 16,620 (of 22,226 total)
Just presented on this yesterday during 24 Hours of PASS.
Perfmormance Monitor: free, built into to Windows, useful for monitoring server and SQL Server at a strategic level
Trace Events: free, built...
"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
September 3, 2009 at 11:56 am
Matt Miller (9/3/2009)
Grant Fritchey (9/3/2009)
Elliott W (9/3/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
September 3, 2009 at 11:47 am
Bob Hovious (9/3/2009)
I hope Jeff never sees this thread...
You mean Cardinal Moden of the SQL Inquisition? :w00t::w00t::w00t:
Torquemada wishes he had Jeff's skill with the pork chop.
"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
September 3, 2009 at 11:29 am
Elliott W (9/3/2009)
Grant Fritchey (9/3/2009)
Well, Mass recently tried to tax purchases made outside their state lines... so, I wouldn't be surprised if they're trying to manage other people's business too.
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
September 3, 2009 at 11:15 am
Elliott W (9/3/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
September 3, 2009 at 10:42 am
I've heard that Adam Machanic may have a few CLR procedures that speed up the process of submitting multiple values. He mentioned it yesterday during his 24 Hours of PASS...
"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
September 3, 2009 at 8:41 am
You've got two foreign keys that are going to try to cascade an update or delete on the same table... It's a circular reference.
Since you're on 2008, why don't you...
"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
September 3, 2009 at 8:09 am
I don't know that you'd have to learn TSQL to be a DBA, but your job is going to be infiinitely more difficult if you don't.
Three books I'd suggest, especially...
"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
September 3, 2009 at 8:07 am
Sourav (9/1/2009)
2) Is it required to free the deadlock manually?
3) What is the way, SQL...
"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
September 3, 2009 at 8:03 am
Do you have the instance where it occurred?
If it's a syntax error, I doubt you'll see it in the trace events because it won't execute, it'll fail to get...
"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
September 3, 2009 at 7:55 am
I'm pretty certain there are several scripts that could do that for you in the Scripts section over on the left. Do a couple of searches there and I think...
"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
September 3, 2009 at 7:52 am
Each table referenced by the query will be addressed by the optimizer and the best index that the optimzer can find will be used. As noted above, this depends on...
"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
September 3, 2009 at 7:50 am
Thanks for posting that. I hadn't heard.
"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
September 3, 2009 at 7:43 am
That's a tough question. There are so many comparisons these days between our current financial situation and the Great Depression. I don't think most of the comparisons hold up, 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
September 3, 2009 at 6:20 am
CirquedeSQLeil (9/2/2009)
Can't wait for the audio to be made available for download.
Yeah, me too. I only got to see the first half of Adam's presentation. I need 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
September 2, 2009 at 1:11 pm
Viewing 15 posts - 16,606 through 16,620 (of 22,226 total)