Viewing 15 posts - 14,446 through 14,460 (of 22,232 total)
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
You're just going to have to do the work. You will be able to code & automate some of it, assuming your db & schema names map reasonably well. 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
August 26, 2010 at 4:59 pm
GilaMonster (8/26/2010)
The deadline has been set for about 3 weeks.
The requirements were finished...
"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 4:55 pm
WayneS (8/26/2010)
Stefan Krzywicki (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 1:25 pm
Yeah, that setting could certainly result in different execution plans.
To see the plan, try querying the DMV sys.dm_exec_query_plans. You'll need to get a plan handle, probably from sys.dm_exec_query_stats and 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 26, 2010 at 11:37 am
On a guess, check the ANSI settings for the connections. I'll bet you one of them is different.
"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 7:03 am
Sounds like the owner of the database was deleted. You just need to set the owner to a valid login
"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:32 am
WayneS (8/25/2010)
Alvin Ramard (8/25/2010)
GilaMonster (8/25/2010)
Anyone want to help an apparent newbie to create a critical, large database?http://www.sqlservercentral.com/Forums/Topic975128-1292-1.aspx
If he's doing this for my bank, then I'm changing bank! :w00t:
Hah! Read my...
"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 25, 2010 at 4:44 pm
Viewing 15 posts - 14,446 through 14,460 (of 22,232 total)