Viewing 15 posts - 4,231 through 4,245 (of 8,416 total)
Saravanan T (4/5/2010)
I'm rebuilding and reorganizing only the indexes which it required.
Are you sure? If you are using a Maintenance Plan, the answer is almost certainly 'no'.
Remember that...
April 5, 2010 at 4:28 am
One other daft method I have seen from time to time:
SELECT DATEADD
(
...
April 5, 2010 at 4:06 am
wallace.dave (4/5/2010)
April 5, 2010 at 3:57 am
General recommendations:
1. Get a faster link 😉
2. Only rebuild or reorganize indexes that absolutely require it
3. Spread the bare-minimum of rebuilds and reorganizations out over time
4. ...
April 5, 2010 at 3:43 am
If you mean the size of the log backups, then the answer is no.
The BULK_LOGGED recovery model allows the index rebuild to complete faster, since it will be minimally logged,...
April 5, 2010 at 2:47 am
Setup:
-- For the demo
USE tempdb;
GO
IF OBJECT_ID(N'dbo.WorkQueue', N'U')
IS NOT NULL
DROP...
April 5, 2010 at 2:36 am
isakhnov (4/5/2010)
Do you know how bad is the performance? Original implementation was retrieving this info...
April 5, 2010 at 1:13 am
david_wendelken (4/4/2010)
He didn't care if it worked on December 31st, he only cared that it could be announced to work on that date.
Nice story. I would have laughed harder...
April 5, 2010 at 1:05 am
The Dixie Flatline (4/4/2010)
April 5, 2010 at 1:00 am
Tom.Thomson (4/4/2010)
Unfortunately Steve they aren't listed in any shape or form in the new post notifications email
My notification emails contain an un-subscribe link...?
Though, I do have to click 'show quoted...
April 4, 2010 at 3:40 pm
Thanks Hugo. I read the blog and the Connect item.
Seems to me that things have changed since the Connect item, given the results of your tests.
If the information in...
April 4, 2010 at 3:17 pm
The Dixie Flatline (4/4/2010)
Going from 10 to 2 seconds, even if there are 100 such monthly reports, represents saving only 800 seconds (15 minutes) of machine time a month.
Developer A...
April 4, 2010 at 3:06 pm
Jeff Moden (4/4/2010)
I usually don't even both looking at the QOD.
That's a shame - there have been some really good discussions on the QotD on occasion. I lot of...
April 4, 2010 at 2:57 pm
Jeff Moden (4/4/2010)
Considering the subject matter in the article, I suspect the article is about "proven but unsupported" things such as the "Quirky Update" methods.
I'm not sure it is...the last...
April 4, 2010 at 2:52 pm
April 4, 2010 at 2:25 pm
Viewing 15 posts - 4,231 through 4,245 (of 8,416 total)