Viewing 15 posts - 11,476 through 11,490 (of 49,562 total)
zsafakhah (10/1/2013)
what additional information you need?
As yourself if you could solve a problem with the little information you've given. Ask yourself what you'd want to know if someone asked you...
October 1, 2013 at 8:06 am
WayneS (10/1/2013)
L' Eomot Inversé (9/27/2013)
GilaMonster (9/27/2013)
Thursday at Summit is going to be sooo funny. Just saying...I hope you'll not leave us wondering ...
Well, lets just say that some folks will...
October 1, 2013 at 8:00 am
alanspeckman (9/30/2013)
While keeping one witness for one production database instance makes sense to me, why on earth would I want one witness for multiple DB instances?
Why wouldn't you? Witness has...
October 1, 2013 at 7:57 am
Test it and see. You have to do that with anything tuning advisor suggests. Can't say a thing more without seeing query, table structures and indexes.
October 1, 2013 at 6:38 am
christian.terhart (10/1/2013)
I guess the only disadvantage is performance if you have a long statement on a heavilly changed table?
Or lots and lots and lots of changes on a seldom-read table.
October 1, 2013 at 6:34 am
Well, when you restore you're replacing the old database, so it doesn't matter what or where the old database had anything.
October 1, 2013 at 6:34 am
jasona.work (10/1/2013)
Well, should be a rather interesting next couple days / weeks / (REALLY hope not) months with the US Government going into shutdown.
I was reading through some of the...
October 1, 2013 at 6:33 am
No where near enough information. We can't see your screen, you're going to have to explain a lot more for anyone to even be able to guess.
October 1, 2013 at 5:39 am
Snapshot isolation does not create a copy of the entire table in TempDB, so the rest of your question is moot, that's not how it works at all.
October 1, 2013 at 5:28 am
The standby file is NOT an ldf. It's a separate file that should have a different extension to show that it's something different. It is NOT a database log file.
October 1, 2013 at 5:26 am
homebrew01 (9/30/2013)
could you do "truncate table" instead of delete ? Should be faster, and no logging since you don't care about data recovery.
There is no such thing as a...
September 30, 2013 at 12:08 pm
A temp table is dropped as soon as the scope in which it was created ends, that scope is the dynamic SQL, so it's created, populated and then dropped at...
September 30, 2013 at 10:30 am
That truncate will fail. Disabling the foreign keys is not sufficient, tables with foreign keys can't be truncated no matter what the state of that constraint.
Edit: Oh, and truncate will...
September 30, 2013 at 9:57 am
Brandie Tarvin (9/30/2013)
GilaMonster (9/30/2013)
Anyone want to help on the blocking thread?I would take a look at it if I had a link to it.
The one in recent posts with the...
September 30, 2013 at 9:48 am
Please note: 2 year old thread.
Also, NOLOCK is not a good thing to have everywhere, locks are for consistency, for correct data. I don't know many users that like...
September 30, 2013 at 9:46 am
Viewing 15 posts - 11,476 through 11,490 (of 49,562 total)