Viewing 15 posts - 10,486 through 10,500 (of 22,226 total)
If this is occurring over & over, I'd start worrying about my hardware. Have you run consistency checks on these databases to determine what's wrong?
"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 17, 2012 at 4:19 am
If you're not writing your own scripts, you should look to Olla Hollengren or Michelle Ufford. Each person has a set of scripts. I think Olla's are more complete and...
"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 17, 2012 at 4:17 am
Don't give the presenters rum until after their presentations.
Nah, you don't really need anything. Something to take notes. Other than that, be ready to network, ask questions, engage. Lots...
"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 17, 2012 at 4:13 am
DBA is a huge job covering lots of different aspects of technology. For a good general description of the position, I'd suggest Craig Mullins book, Database Administration. It's a little...
"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 17, 2012 at 4:06 am
I've never noticed clustering affecting backup speed before. So, I'd be more suspicious of the virtual machines preventing you from getting proper throughput to the SAN, not the cluster causing...
"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 17, 2012 at 4:03 am
Thing is, those are two different queries. The IN statement can act to filter the results of ABC, but none of the columns from ABC1 are available in the SELECT...
"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 17, 2012 at 3:59 am
If the indexes are less than a 8 pages in size, they won't take a full extent and you'll never get complete defragmentation. You may be seeing fragmentation going up...
"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 17, 2012 at 3:53 am
You can use third party tools to explore the log. They work, but won't supply information that's not there as Gail points out. I think Apex SQL has a log...
"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 17, 2012 at 3:51 am
Sure, but you have to use the 64-bit client. Microsoft has it documented here.
"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 17, 2012 at 3:49 am
I can't see all the configuration, but it looks like you have an instance name of MSSQLSERVER, but the connection is trying to connect to SSSQLSERVER. Possibly change 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 15, 2012 at 1:09 pm
Jeff and Wayne and Jason and Jack and me are all at SQL Saturday #156. What happened? Did the rest of you miss the memo?
"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 15, 2012 at 11:47 am
Gianluca Sartori (9/14/2012)
I never thought it could be that hard!
I know exactly what 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 14, 2012 at 6:23 pm
The simplification step in the optimization process can clean up issues with views, but not always and not always all the way. Depending on what's there, you might be better...
"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 14, 2012 at 1:34 pm
Looking at this, the first thing I'd suggest is you update your statistics. They're pretty badly out of wack. That might be why you're getting such an expensive plan. 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
September 14, 2012 at 11:53 am
jcrawf02 (9/14/2012)
My new career: http://www.geekologie.com/2012/09/now-run-them-through-with-a-katana-londo.php
Where do I go to volunteer?
"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 14, 2012 at 11:20 am
Viewing 15 posts - 10,486 through 10,500 (of 22,226 total)