Agreed, I've just a rebuild and verified that the fragmentation is at...

Hi Gail,

Just double checked and there is no shrink operations what so ever.

Basically the only processes that happen are as follows;

1. 00:15 - A custom T-SQL job runs to find...

Hi,

Thanks for the reply.

You make a good point about defaults not being indicative of poor programming. What I mean is that if you have 2 process that share a...

Hi,

In answer to your question Gail, no it is not turned on. Sorry for the delay in getting back to you.

I was off the impression, lets say I have...

ok, have you tried executing viewing the T-SQL for the step and then executing as an admin users.

Beware though if you have many tables as scripting it could take some...

Hi,

This looks like it could be a permissions problem. Possibly.

When you say 'optimization job' what exactly do you mean, do you mean a step in a maintenance plan such...

yeah no problem, if you need any more info or have any questions then just post them up on the forum or private message me.

Regards,

Hi,

You can save a query result to a text file by either clicking the 'results to file' button at the top of the SSMS and then running the query.

Hi,

Sorry for the delay in getting a response.

You could have a look at the code attached, I've put it together really quickly so it's a little messy but should do...

No problem at all.

If you need anything else then just let us know.

you can get it from here;

http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en

espanolanthony (8/27/2009)

---

so if i have SQL Server version

Microsoft SQL Server 2005 - 9.00.3239.00 (X64) Apr 9 2008 22:41:28 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition...

My understanding of it is, the yes, SP3 will contain all the hotfixes upto SP3.

Any hot fixes released after SP3 obviously wont be in it.

If you looking to see if...

Hi,

Have a look at this, it will give you all the links you need.

http://www.sqlservercentral.com/articles/Administration/2960/

As far as I was aware SP3 will contain all the fixes upto it, then there are...

You could also do it this way (see attachment), may be a bit simpler if you've not done PIVOTS before.

There is probably a better way of doing it, but off...