Viewing 15 posts - 316 through 330 (of 646 total)
If you are bored/Interested like I am then you can use fn_dblog to check the actual operation. I was playing with this and could see:
LOP_BEGIN_XACTLCX_NULL0000:00000cbcNULLTRUNCATE TABLE
.
.
.
.
.LOP_BEGIN_XACTLCX_NULL0000:00000cbdNULLDeferredAllocUnitDrop::Process
January 29, 2016 at 1:13 am
Ed Wagner (1/27/2016)
Ray K (1/27/2016)
Ed Wagner (1/27/2016)
Grumpy DBA (1/27/2016)
SQLRNNR (1/27/2016)
FuzzleManscape
Yuck
Ugh
Charlie Brown
snoopy
January 28, 2016 at 1:51 am
Ed Wagner (1/27/2016)
Grumpy DBA (1/27/2016)
Ed Wagner (1/27/2016)
DisneyMoney
Lots
Many
January 27, 2016 at 6:36 am
I you want to read up on this then here is a quality TechNet article by Paul Randal. Half way down the article is all about the Transaction Log and...
January 26, 2016 at 7:05 am
Ed Wagner (1/26/2016)
Grumpy DBA (1/26/2016)
Ed Wagner (1/26/2016)
djj (1/26/2016)
BL0B_EATER (1/26/2016)
Ed Wagner (1/25/2016)
Revenant (1/25/2016)
bcsims 90437 (1/25/2016)
Ed Wagner (1/25/2016)
Luis Cazares (1/25/2016)
SQLRNNR (1/25/2016)
Sciutoprosciutto
Pancetta
BACON!!!!!!
Kevin 😉
Footloose
musical
Stage
Theater
Drive-in
Movie
Boring
January 26, 2016 at 6:57 am
Ed Wagner (1/25/2016)
Revenant (1/25/2016)
bcsims 90437 (1/25/2016)
Ed Wagner (1/25/2016)
Luis Cazares (1/25/2016)
SQLRNNR (1/25/2016)
Sciutoprosciutto
Pancetta
BACON!!!!!!
Kevin 😉
Footloose
musical
January 26, 2016 at 4:13 am
ZZartin (1/25/2016)
Ed Wagner (1/25/2016)
djj (1/25/2016)
Ed Wagner (1/22/2016)
Jeff Moden (1/22/2016)
TomThomson (1/22/2016)
SQLRNNR (1/22/2016)
Ed Wagner (1/22/2016)
SQLRNNR (1/22/2016)
DonlSimpson (1/22/2016)
SQLRNNR (1/22/2016)
runtsquirt
herder
Sheep
Black
Coal
Graphene
Graphite
epoxy
Repair
Hammer
Time
January 25, 2016 at 7:52 am
Stuart Davies (1/21/2016)
Ed Wagner (1/20/2016)
Ray K (1/20/2016)
djj (1/20/2016)
RoastedChicken
Ribs
Spare
Tyre
January 21, 2016 at 2:48 am
you might be suffering from parameter sniffing?
January 21, 2016 at 1:25 am
SQLRNNR (1/19/2016)
BL0B_EATER (1/19/2016)
Anybody notice the new hair style?
New year, new me. 😛
January 20, 2016 at 2:03 am
Ed Wagner (1/19/2016)
crookj (1/19/2016)
BL0B_EATER (1/19/2016)
crookj (1/19/2016)
whereisSQL? (1/19/2016)
BL0B_EATER (1/19/2016)
Ed Wagner (1/19/2016)
crookj (1/19/2016)
Grumpy DBA (1/19/2016)
Stuart Davies (1/19/2016)
Ed Wagner (1/18/2016)
Revenant (1/18/2016)
SQLRNNR (1/18/2016)
reasonablejustified
Perspective
Parallax
Green Lantern
Sinestro
Comic
Hero
Villain
Cpt America (75 years!)
Avenger
Vision!
Sight
goggles
January 19, 2016 at 8:32 am
wow, 32GB - that's some serious kit right there.
January 19, 2016 at 8:28 am
Alvin Ramard (1/19/2016)
MVP? That's Microsoft Vice President, right? 🙂
Could be worse, they could have asked why we are talking about basketball in an IT interview.
January 19, 2016 at 8:27 am
crookj (1/19/2016)
whereisSQL? (1/19/2016)
BL0B_EATER (1/19/2016)
Ed Wagner (1/19/2016)
crookj (1/19/2016)
Grumpy DBA (1/19/2016)
Stuart Davies (1/19/2016)
Ed Wagner (1/18/2016)
Revenant (1/18/2016)
SQLRNNR (1/18/2016)
reasonablejustified
Perspective
Parallax
Green Lantern
Sinestro
Comic
Hero
Villain
Cpt America (75 years!)
Avenger
January 19, 2016 at 8:02 am
Ed Wagner (1/19/2016)
crookj (1/19/2016)
Grumpy DBA (1/19/2016)
Stuart Davies (1/19/2016)
Ed Wagner (1/18/2016)
Revenant (1/18/2016)
SQLRNNR (1/18/2016)
reasonablejustified
Perspective
Parallax
Green Lantern
Sinestro
Comic
Hero
January 19, 2016 at 7:25 am
Viewing 15 posts - 316 through 330 (of 646 total)