Viewing 15 posts - 76 through 90 (of 206 total)
Can you do it in the GUI and rather than apply script out the T-SQL and post it on here along with an overview of the schema of the table...
October 6, 2010 at 3:07 pm
GilaMonster (10/6/2010)
RichardDouglas (10/6/2010)
oh god, great point Gail, you might want to check your index fragmentation too. Paul Randall did a great demo on how shrinking your files causes fragmentation.
That's only...
October 6, 2010 at 3:00 pm
marc 96091 (10/6/2010)
Also, is there anyway to make Tlog backups smaller? When I've run them in the past they've been several gigs for a whole days worth and I...
October 6, 2010 at 2:53 pm
GilaMonster (10/6/2010)
RichardDouglas (10/6/2010)
October 6, 2010 at 2:45 pm
GilaMonster (10/6/2010)
Shawn Melton (10/6/2010)
October 6, 2010 at 2:40 pm
If you want to add more weight to it talk about management of virtual log files. Google/Bing "VLF" and "SQLSkills". Kimberley and Paul have some great blogs on the subject....
October 6, 2010 at 2:37 pm
My god :pinch: that is some scary stuff.
October 6, 2010 at 2:29 pm
Hi sorry for the delay and thank you for your reply.
I'm quite removed from the day to day running of the DWH as things stand but I want to bring...
October 6, 2010 at 2:18 pm
Just tweeted that SSC's 1 millionth post is imminent, I wonder how that will affect the number of posts coming in.....
October 6, 2010 at 2:10 pm
Ray K (10/6/2010)
Are we there yet?(And damn! I just noticed my last post netted me 1,000 points! Personal milestone for me!)
Congratulations, wouldn't it have been cool if your...
October 6, 2010 at 2:05 pm
Wow less than 1000 to go. Will be any day now!
October 6, 2010 at 2:22 am
Ninja's_RGR'us (10/5/2010)
RichardDouglas (10/5/2010)
Ninja's_RGR'us (10/5/2010)
I haven't got anything... are they sending mail directly to your box or on the ssc messages center?
I have a subscription to this thread which will email...
October 5, 2010 at 10:05 am
Ninja's_RGR'us (10/5/2010)
I haven't got anything... are they sending mail directly to your box or on the ssc messages center?
I have a subscription to this thread which will email me
October 5, 2010 at 9:59 am
Viewing 15 posts - 76 through 90 (of 206 total)