Viewing 15 posts - 17,461 through 17,475 (of 22,204 total)
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...
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...
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.
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...
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...
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.
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...
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...
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 &...
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...
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...
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.
May 11, 2009 at 10:55 am
GilaMonster (5/11/2009)
Samuel Vella (5/11/2009)
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.
May 11, 2009 at 10:36 am
Viewing 15 posts - 17,461 through 17,475 (of 22,204 total)