Viewing 15 posts - 17,491 through 17,505 (of 22,226 total)
Krishna Potlakayala (5/11/2009)
But Why a job every night if you have Auto Update statistics ON? You either have to have Auto update Statistics ON or OFF and run a job...
"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
May 11, 2009 at 1:34 pm
Do you mean you're using Visual Studio Team System Database Edition, or just the regular Visual Studio with a database project? I'm asking because you talked about Schema Compare &...
"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
May 11, 2009 at 1:28 pm
I'm assuming that the update statistics is not based on a full scan. It's possible that the data in a sampled scan doesn't result in statistics as good as that...
"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
May 11, 2009 at 1:16 pm
GSquared (5/11/2009)
Grant Fritchey (5/11/2009)
Well to get the thread back "on topic" (as if), this one has managed to raise my blood pressure with his/her response.Suffice to say. I'm done.
I had...
"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
May 11, 2009 at 1:10 pm
I'd crack a joke about only wanting SQL Server info from black belts, but I'd be reading from Itzik, Kalen, Gail... I'm not sure who else. No worries there.
"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
May 11, 2009 at 10:55 am
GilaMonster (5/11/2009)
Samuel Vella (5/11/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
May 11, 2009 at 10:38 am
Hard to know, but I'll bet it's related to the size. Based on your descriptions and the documentation, I'd guess that was 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
May 11, 2009 at 10:36 am
Well to get the thread back "on topic" (as if), this one has managed to raise my blood pressure with his/her response.
Suffice to say. I'm done.
"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
May 11, 2009 at 10:33 am
Samuel Vella (5/11/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
May 11, 2009 at 6:57 am
The issue is, the waitfor is not a part of the procedure itself. So the procs ran in the time reported. It sounds like you're trying to get client side...
"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
May 11, 2009 at 6:51 am
I think Brent & Gail's advice is best. You have to get involved, somehow, with actual database work.
I started out in development by building apps and doing tech support...
"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
May 11, 2009 at 6:45 am
Same question I was going to ask. Why only Indian authors? Wouldn't it be better to just go for the best books, regardless of the ethnic origin of the author?
For...
"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
May 11, 2009 at 6:39 am
What you're proposing isn't an in-place upgrade. You're saying that you want to install 2005 on the same server as 2000 and them migrate the databases over. An in-place upgrade...
"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
May 11, 2009 at 6:36 am
Using the ONLINE rebuild will reduce locking & contention but will increase tempdb use, so be read for that.
I wouldn't get too locked into particular time frames. It reall depends...
"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
May 11, 2009 at 6:31 am
Since we've gone through two year searches in the past for DBA's, I sure can't tell you how to find them. While we weren't trying to get them to know...
"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
May 11, 2009 at 6:14 am
Viewing 15 posts - 17,491 through 17,505 (of 22,226 total)