Viewing 15 posts - 2,311 through 2,325 (of 2,729 total)
Another option if you don't want to mess around with undocumented SQL commands, would be to look into using the DOS command FORFILES. At my previous job, I had...
July 24, 2013 at 5:39 am
Nope. You still would need to (if you deem it worth the time and effort) go back and compress the non-clustered indexes.
July 23, 2013 at 1:30 pm
Having just dealt with compressing a table with both clustered and non-clustered indexes:
i) I don't believe so. I believe you can compress just the indexes, but you probably...
July 23, 2013 at 11:58 am
/me, munching on popcorn and enjoying the calm, reasoned, rational discourse on writing and expectations of the reader...
😎
July 23, 2013 at 8:03 am
It says something about the sort of advice / recommendations someone gives, that if I see their name as responding to a post, regardless of the subject, I click it.
ALL...
July 22, 2013 at 11:31 am
JAZZ Master (7/22/2013)
crookj (7/22/2013)
Daniel Bowlin (7/22/2013)
crookj (7/18/2013)
The Dixie Flatline (7/17/2013)
opc.three (7/17/2013)
L' Eomot Inversé (7/17/2013)
Revenant (7/17/2013)
The Dixie Flatline (7/17/2013)
bcsims 90437 (7/17/2013)
JAZZ Master (7/17/2013)
SQLRNNR (7/17/2013)
petrifiedputrefied
purified
perforated
penetrated
defenestrated
immolated
disintegrated
violated
breached
Beached
Blond
Bimbo
July 22, 2013 at 11:08 am
Always fun having a slow, gawd can I sneak out yet, sort of day...
Sure, I've got some projects, but anything that requires a server reboot is out, and the big...
July 22, 2013 at 9:54 am
The only time (that I'm aware of) that you need to install patches at (almost) the same time, is in any sort of a DR / HA setup (clustering, log...
July 19, 2013 at 10:29 am
Stefan Krzywicki (7/19/2013)
jasona.work (7/19/2013)
Stefan Krzywicki (7/19/2013)
Brandie Tarvin (7/19/2013)
Stefan Krzywicki (7/19/2013)
Grant Fritchey (7/19/2013)
Sean Lange (7/19/2013)
July 19, 2013 at 10:18 am
Stefan Krzywicki (7/19/2013)
Brandie Tarvin (7/19/2013)
Stefan Krzywicki (7/19/2013)
Grant Fritchey (7/19/2013)
Sean Lange (7/19/2013)
July 19, 2013 at 10:04 am
The general suggestion for autogrowth seems to be, don't. Ideally, either you set your DBs size large enough to encompass all reasonable possible data growth, or you monitor your...
July 19, 2013 at 8:53 am
OK, thanks!
I've been watching the Extended Events, but knowing they may not catch everything, I was hoping for a second method (without the trace flag)
Knowing XEs don't stay forever (seeing...
July 19, 2013 at 7:45 am
opc.three (7/12/2013)
July 17, 2013 at 6:04 am
After reading the "I hate software" posts just now, I have an urge to start a new topic...
Post the most twisted, warped, bizzarre, yet functional SQL code you can...
Whether it's...
July 17, 2013 at 5:21 am
Viewing 15 posts - 2,311 through 2,325 (of 2,729 total)