Viewing 15 posts - 39,316 through 39,330 (of 49,571 total)
RBarryYoung (5/5/2009)
Jan Van der Eecken (5/5/2009)
Sure, just gimme a shout when you are at the airport.Heh. I so wish I could afford to follow through on this... 🙂
Exchange rate...
May 5, 2009 at 9:22 am
tobe_ha (5/5/2009)
There is a clustered...
May 5, 2009 at 6:33 am
GilaMonster (5/5/2009)
tobe_ha (5/5/2009)
Is there a History where I can see, what recovery models were set in the past?
It doesn't appear to be stored in the default trace (I just checked),...
May 5, 2009 at 6:29 am
Paul White (5/5/2009)
May 5, 2009 at 6:08 am
There's no way to downgrade database versions. A DB on SQL 2008 has a slightly different file structure and different system tables, and that's regardless of the compatibility level. SQL...
May 5, 2009 at 6:03 am
tobe_ha (5/5/2009)
Is there a History where I can see, what recovery models were set in the past?
It doesn't appear to be stored in the default trace (I just checked), so,...
May 5, 2009 at 5:59 am
Paul White (5/5/2009)
It might be that the SSIS package is running the whole thing in a transaction; however the SELECT...INTO will be bulk-logged if the database is set to Simple,...
May 5, 2009 at 5:53 am
Can you explain more? model.bak would be a backup file and it is in no way necessary for SQL's operation. the Model database, consisting od Model.mdf and Model.ldf are.
Does the...
May 5, 2009 at 4:03 am
Probably SSIS is running all of them in a transaction, which means that the log cannot truncate until the commit occurs. If that's the case, you won't be able to...
May 5, 2009 at 4:02 am
michael vessey (5/5/2009)
from experience RPC starting is required if the Command timeout occurs and the command is killed before any results (even the 1st row) is returned.
Shouldn't be. I did...
May 5, 2009 at 2:47 am
These might help you a bit. They're purely on indexing, not rewriting bad code.
May 5, 2009 at 2:39 am
I found that replacing the < and > with < and > removes the closing tags, but that's not fun to do.
May 5, 2009 at 1:55 am
Jeff Moden (5/4/2009)
May 5, 2009 at 1:42 am
Marios Philippopoulos (5/4/2009)
It's odd, this proc is taking 3 input params, I just don't see why this portion is not listed.
Not sure either. I just hauled a plan out of...
May 4, 2009 at 3:29 pm
Use Perfmon (Windows performance monitor). Under SQL Server:Buffer Manager there's a counter for Lazy writes/sec
May 4, 2009 at 3:18 pm
Viewing 15 posts - 39,316 through 39,330 (of 49,571 total)