Viewing 15 posts - 3,211 through 3,225 (of 9,643 total)
From BOL (this article):
Rebuilding an index drops and re-creates the index. This removes fragmentation, reclaims disk space by compacting the pages based on the specified or existing fill factor setting,...
March 11, 2010 at 7:26 am
Leon Venediktou (3/10/2010)
March 11, 2010 at 7:02 am
Nice article Jason. I'll be interested in what you find from Event Notifications.
March 11, 2010 at 6:48 am
Elliott W (3/10/2010)
March 10, 2010 at 7:06 pm
Vivek29 (3/9/2010)
It will.I witnessed it.See my post..I said after clearing cache, perform shrink operation.:smooooth:
But why would you need to clear the cache (RAM) to shrink tempdb (disk)? Makes no...
March 9, 2010 at 2:02 pm
CirquedeSQLeil (3/9/2010)
Vivek29 (3/9/2010)
Run this before performing shrink operation.Use tempdb
go
DBCC FREESYSTEMCACHE(ALL);
DBCC FREESESSIONCACHE;
then perform your shrink operation.
Thanks
Vivek
Why?
Because shrinking TempDB is going to slow everything down, you might as well refresh the cache...
March 9, 2010 at 1:34 pm
Lynn Pettis (3/8/2010)
Paul White (3/8/2010)
Anyone else noticed the frenzy of poor advice recently? Moderately aggravating.
Yes, I have. I just hope I haven't been a party to some of...
March 9, 2010 at 10:44 am
Roy Ernest (3/8/2010)
Of Topic...On an average how many people attend SQLSaturdays?
The 3 Orlando ones have been between 225-275. I think they've been as small as 75-100 and as big...
March 8, 2010 at 11:58 am
WI-DBA (3/8/2010)
March 8, 2010 at 7:40 am
I don't know of a way to do it in the report body because the PageNumber and TotalPages items are only allowed in a page footer or header. Why...
March 6, 2010 at 9:23 am
Are you re-running your select of next_run_time in the VB.NET app after you set the time.
March 6, 2010 at 9:06 am
Hope that works out for you.
March 5, 2010 at 1:37 pm
GilaMonster (3/5/2010)
Jack Corbett (3/5/2010)
If you are already known as a top-level person (Grant, Gail, etc..), then the cert is unnecessary.
When you're bidding for work (consulting), a collection of qualifications can...
March 5, 2010 at 1:25 pm
Here's a KB Article that talks about how TCP Offloading works and how to enable/disable it.
March 5, 2010 at 10:00 am
Lynn Pettis (3/5/2010)
Okay denizens, looking for ideas and suggestions here.Thanks.
Posted there. Amazingly my mind worked and recalled a blog post I read a few weeks ago that might apply.
March 5, 2010 at 9:54 am
Viewing 15 posts - 3,211 through 3,225 (of 9,643 total)