Viewing 15 posts - 3,031 through 3,045 (of 19,564 total)
Run the script here and see if it also reports that same size
http://jasonbrimhall.info/2014/03/28/table-space-updated-again/
May 27, 2014 at 10:29 am
I just recently played through this exercise. I was at SQL Saturday Atlanta and my laptop decided to start acting finicky. I have fixed that problem on that...
May 27, 2014 at 9:56 am
Gary Varga (5/27/2014)
May 27, 2014 at 9:52 am
BWFC (5/27/2014)
Robert Sterbal-482516 (5/25/2014)
Am I spoiled by the fact that I'm willing to lug my digital SLR virtually everywhere?
My wife's the same. I've got a smaller, lighter mid-range compact...
May 27, 2014 at 9:51 am
Gary Varga (5/27/2014)
Terrible "side effect" coding style!!!
+10
May 27, 2014 at 9:09 am
Nakul Vachhrajani (5/25/2014)
I got it wrong, but the "correct" answers stumped me. How are "local" temporary tables visible across sessions?
They are not. Take a look at the notes posted...
May 26, 2014 at 7:29 am
Steve Jones - SSC Editor (5/24/2014)
Hany Helmy (5/24/2014)
SQLRNNR (5/23/2014)
Steve Jones - SSC Editor (5/23/2014)
Question changed and points awarded back as you can apparently partition a temp table: http://www.sqlservercentral.com/blogs/sqlrnnr/2014/05/23/can-you-partition-a-temporary-table/
Thanks Steve.
And by...
May 24, 2014 at 10:19 am
Hany Helmy (5/24/2014)
SQLRNNR (5/23/2014)
Steve Jones - SSC Editor (5/23/2014)
Question changed and points awarded back as you can apparently partition a temp table: http://www.sqlservercentral.com/blogs/sqlrnnr/2014/05/23/can-you-partition-a-temporary-table/
Thanks Steve.
And by the way - thanks for...
May 24, 2014 at 10:18 am
Steve Jones - SSC Editor (5/23/2014)
Question changed and points awarded back as you can apparently partition a temp table: http://www.sqlservercentral.com/blogs/sqlrnnr/2014/05/23/can-you-partition-a-temporary-table/
Thanks Steve.
And by the way - thanks for continuing this feature...
May 23, 2014 at 11:58 pm
How long before it ramps up to 3gb?
I have seen SSMS consume GBs of memory before due to returning query results. Is this person running some extremely complicated queries...
May 23, 2014 at 3:28 pm
KWymore (5/23/2014)
SQLRNNR (5/23/2014)
TomThomson (5/23/2014)
SQLRNNR (5/23/2014)
Temp tables...
May 23, 2014 at 2:43 pm
Sean Lange (5/23/2014)
LOL. Apparently I need to endorse my SSC friends more on LinkedIn.
That can't be dwain 😉 there is no giant fish.
May 23, 2014 at 1:42 pm
whereisSQL? (5/23/2014)
TomThomson (5/23/2014)
Revenant (5/23/2014)
Ed Wagner (5/23/2014)
SQLRNNR (5/23/2014)
Ed Wagner (5/23/2014)
crookj (5/23/2014)
Ed Wagner (5/23/2014)
BWFC (5/23/2014)
RingRule
Decree
Dictate
PotatoHead
Toy
Story
Board
Chalk
ongle
May 23, 2014 at 12:59 pm
TomThomson (5/23/2014)
SQLRNNR (5/23/2014)
Temp tables can be...
May 23, 2014 at 12:57 pm
Viewing 15 posts - 3,031 through 3,045 (of 19,564 total)