Viewing 15 posts - 9,691 through 9,705 (of 49,571 total)
Siberian Khatru (3/13/2014)
March 13, 2014 at 4:32 am
As with all hints, use sparingly, only where needed and only after understanding exactly why the hint is needed. It's not something to dump onto every single statement.
March 13, 2014 at 2:15 am
jbonavita (3/12/2014)
If I stick with the trigger, will this slow down the actual insert or update
Yes. Whether it will be a noticable slow down is another matter. Test!
March 13, 2014 at 12:42 am
Jeff Moden (3/12/2014)
Using "Statistics TIME, IO" will also be way off if there are any non iTVF functions in the mix.
IO will be. Time, if you look at the final...
March 13, 2014 at 12:39 am
Jeff Moden (3/12/2014)
Yes... according to MS definitions... which I happen to disagree with and only because they cause so much confusion. 😉
According to how things behave. Adding a third category...
March 13, 2014 at 12:37 am
Jeff Moden (3/12/2014)
GilaMonster (3/12/2014)
MyDoggieJessie (3/12/2014)
TRUNCATE will be faster and be minimally logged.Fully logged. It's efficiently logged, but it is fully logged, not minimally logged. Minimally logged has a specific definition.
I...
March 12, 2014 at 2:54 pm
MyDoggieJessie (3/12/2014)
March 12, 2014 at 12:35 pm
Grace09 (3/12/2014)
Other SQL Servers (same version) all have the min server memory setting changed to 1 GB, that's why I wonder if I should change mine too.
Maybe find out...
March 12, 2014 at 12:30 pm
Have you tested the query option? Does it execute in acceptable time?
March 12, 2014 at 12:30 pm
About that. There will be other pages (allocation pages) which get deallocated as well, there will be some metadata changes which get logged, but close to that.
March 12, 2014 at 12:09 pm
karthik.bj (3/12/2014)
But however if you see a need to roll back, use delete. DELETE LOGS ALL NECESSARY DATA FOR ROLLBACK and occupies space.
So does truncate. Truncate can be rolled...
March 12, 2014 at 9:57 am
Truncate logs a lot less than delete. It doesn't log the full page images as it doesn't need to. It logs the same amount as a drop table does, just...
March 12, 2014 at 9:37 am
MyDoggieJessie (3/12/2014)
TRUNCATE will be faster and be minimally logged.
Fully logged. It's efficiently logged, but it is fully logged, not minimally logged. Minimally logged has a specific definition.
March 12, 2014 at 9:17 am
Generate the table scripts and change the schema name afterwards. Then use something like bcp, SSIS or straightforward INSERT ... SELECT to move the data.
March 12, 2014 at 8:34 am
Viewing 15 posts - 9,691 through 9,705 (of 49,571 total)