Viewing 15 posts - 16,606 through 16,620 (of 22,219 total)
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
GilaMonster (9/2/2009)
Grant Fritchey (9/2/2009)
GilaMonster (9/2/2009)
Hell Grant. 425 attendees! That's going to be one of the best-attended sessions so far.
Thanks. I was told the max number was 435. I only saw...
"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 8:56 am
GilaMonster (9/2/2009)
Grant Fritchey (9/2/2009)
What is wrong with using Avg. Disk Queue Length?
Two things.
Firstly, SQL can and does drive it very high if it does large read-ahead reads. If the storage...
"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 8:45 am
Jack Corbett (9/2/2009)
Steve Jones - Editor (9/2/2009)
GilaMonster (9/2/2009)
Nah. Forgotten about it already.She says that Jack, but let's see if she invites you to train on Tues or Wed night ...
I'll...
"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 7:59 am
GilaMonster (9/2/2009)
Hell Grant. 425 attendees! That's going to be one of the best-attended sessions so far.
Thanks. I was told the max number was 435. I only saw 410. Still, that'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
September 2, 2009 at 7:38 am
GilaMonster (9/2/2009)
Hey Grant.I completely disagree with your choice of disk counter. Just so you know. 😉
Please, disagree away. I just tried the find the bare bones basic counters. 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
September 2, 2009 at 7:37 am
Alvin Ramard (9/2/2009)
Jack Corbett (9/2/2009)
Now whenever I read one of your posts I'll have the correct voice in my head:-P
Next up for me...
"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 7:36 am
Jack Corbett (9/2/2009)
Enjoying Gail's session on indexing on 24 hours of PASS. Don't know how much I'll retain being up this early.
I'm definately getting the download on that one.
"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 7:34 am
Viewing 15 posts - 16,606 through 16,620 (of 22,219 total)