Viewing 12 posts - 76 through 87 (of 87 total)
GilaMonster (3/17/2014)
Siberian Khatru (3/17/2014)
assumed the log was truncated as part of the log backup procedure.
It is. Truncate means to mark portions of the log as reusable. It happens...
March 17, 2014 at 7:17 am
GilaMonster (3/17/2014)
March 17, 2014 at 7:10 am
humbleDBA (3/14/2014)
GilaMonster (3/14/2014)
Siberian Khatru (3/14/2014)
For me, the keys were not needing to worry about getting all of the rows back, plus the minimal logging aspect.
Well....
Both delete and truncate can...
March 14, 2014 at 8:07 am
Eric M Russell (3/14/2014)
humbleDBA (3/14/2014)
Eric M Russell (3/13/2014)
Siberian Khatru (3/12/2014)
March 14, 2014 at 7:49 am
For me, the keys were not needing to worry about getting all of the rows back, plus the minimal logging aspect. Both Gail and Jeff were helpful beyond that though...
March 14, 2014 at 4:44 am
GilaMonster (3/13/2014)
Siberian Khatru (3/13/2014)
March 13, 2014 at 6:54 am
GilaMonster (3/13/2014)
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...
March 13, 2014 at 4:14 am
Jeff Moden (3/12/2014)
Siberian Khatru (3/12/2014)
Shrinking my files down to a manageable level which should solve my disk space crunch a bit.
Shrinking your files will also make a narly trainwreck out...
March 12, 2014 at 1:56 pm
GilaMonster (3/12/2014)
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.
Well, thanks for...
March 12, 2014 at 12:15 pm
GilaMonster (3/12/2014)
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...
March 12, 2014 at 10:15 am
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.
See, it's the...
March 12, 2014 at 9:23 am
More clarification -
The idea here is to presumably provide a fairly recent set of data for testing, also presumably without any schema changes versus production per say. As...
March 5, 2014 at 10:40 am
Viewing 12 posts - 76 through 87 (of 87 total)