Viewing 15 posts - 14,431 through 14,445 (of 22,224 total)
Lots of columns, one table... eh.
Try messing with an 86 table join. That's when life gets interesting.
"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
August 30, 2010 at 8:09 am
Is your database set to Full Recovery mode? If so, you need to be backing up the log files too.
When you back up a database, it backups up the data...
"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
August 30, 2010 at 7:57 am
I'd also suggest reading Books Online. It really is some of the most complete documentation available. But, some additional places to look include, this article that I wrote quite 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
August 30, 2010 at 7:54 am
It may or may not be indexes, who knows based on the information at hand. What I'd suggest is taking a look at sys.dm_exec_requests and see if there are processes...
"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
August 30, 2010 at 7:47 am
RBarryYoung (8/28/2010)
"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
August 28, 2010 at 9:37 am
Steve Jones - Editor (8/27/2010)
BTW, to a large extent, Monday's editorial (Aug 30) is meant for you citizens of The Thread.Thanks for the support.
You're welcome. And thank 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
August 27, 2010 at 4:32 pm
Alvin Ramard (8/27/2010)
WayneS (8/27/2010)
Sigh. (Bang head on desk).How to troubleshoot in 3 easy steps:
1 - Load gun
2 - Aim at trouble
3 - Shoot :w00t:
😛
You aim?...
"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
August 27, 2010 at 9:31 am
Limited is the quickest mode on that, so switching it to Sampled or Detailed isn't going to help.
Are you hitting contention?
"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
August 27, 2010 at 9:29 am
Another vote for Tom LaRock's DBA Survivor. Great little book.
Another book about the DBA job is Craig Mullin's "Database Administration." Also worth a read.
"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
August 27, 2010 at 9:27 am
Alvin Ramard (8/27/2010)
Ok, I'll get this started.Hello everyone. I'm Alvin Ramard and I am NOT a DBA. 🙂
Hell, I'm only letting them call me a DBA because 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
August 27, 2010 at 7:54 am
Brandie Tarvin (8/27/2010)
Alvin Ramard (8/27/2010)
Differential vs incremental, that was my mistake, but I don't care because I'm not a DBA. 😀
ACK! We've been invaded! There's one of those non-DBA...
"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
August 27, 2010 at 7:12 am
DC - When I was a kid it was the Flash. I just loved the idea of running, really fast. But as I got older I become more and 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
August 27, 2010 at 7:00 am
GilaMonster (8/26/2010)
"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
August 26, 2010 at 6:15 pm
chugghin (8/26/2010)
"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
August 26, 2010 at 6:11 pm
chugghin (8/26/2010)
http://www.sqlservercentral.com/Forums/Topic446175-360-1.aspx
If...
"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
August 26, 2010 at 5:04 pm
Viewing 15 posts - 14,431 through 14,445 (of 22,224 total)