Viewing 15 posts - 17,476 through 17,490 (of 22,219 total)
I agree 100% with what Lowell has said.
I will add some caveats though. Be careful about nesting views. It can lead to all kinds of performance issues as well as...
"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 12, 2009 at 6:31 am
It will change the restore operations, as outlined above.
You need to determine the level of recovery that the business needs. Currently, with a full backup and an incremental backup once...
"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 12, 2009 at 6:25 am
trayalacheruvu (5/12/2009)
There are few queries which is taking time to execute..but in the application level they have set that connection timeout period as 100 sec. for testing purpose 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
May 12, 2009 at 6:22 am
David Burrows (5/12/2009)
Anything and everything is fair game.
Including DBA's :satisfied:
Pork Chops, lock and load :w00t:
Especially DBA'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
May 12, 2009 at 6:06 am
Actually, I cheated a bit more than that. I only searched Amazon, bypassing Google entirely. I'll freely admit to a bit of laziness. Instead of searching for "sql server" 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
May 12, 2009 at 5:39 am
Sajal Dam wrote the SQL Server 2000 version of Query Performance Tuning Distilled, and his name is still on the 2008 version since about 20% of the text is still...
"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 12, 2009 at 4:07 am
I'm entirely unsure of what I changed, but it's working now. I feel like an idiot because it should have worked. It looks good now... thanks for the help.
"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 8:42 pm
I'm sorry. You're right. That was just a typo I made after I copied & pasted. I'm using the correct property or I'd get an error. It's just not returning...
"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:03 pm
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
Viewing 15 posts - 17,476 through 17,490 (of 22,219 total)