Do we have to stop and restart the services when we change the service account password?

No, but I would advise doing so just to make sure that the password is...

American Association of Retired Persons -->  http://www.aarp.org/sk/membership2.html?keycode=U5LAD6

A 'geriatric' ? organization. However, I doubt that I will be 'retired' ... Ill probably work till my 'end of days'

Got really side-tracked ... maybeI'll get back to it in another week or two ...

Only 2 more years until I can join AARP

Have a great day my friend !

CP/M --> http://en.wikipedia.org/wiki/CP/M

MP/M --> http://en.wikipedia.org/wiki/MP/M

I do remember typing faster than 1200 baud on an acoustic modem ... couldn't keep up with 9600 when it came out though...

I'm not quite as old as dirt. I once worked on an Altair computer. I even worked with CPM and MPM. Oh, don't forget PIP ! Well enough on the...

Possible posting the table structure and index structure may help - especially if you are updating non-primary index columns. But the bottom line is that you will probably need to...

Ninja's_RGR'us,

In real estate the rules are: location, location, location

For a working DBA they usually are: stewardship, backup, recovery

For a seeking DBA I like to say: information, information, information

I'm no more...

8 Gb of RAM with /3GB, now 16 Gb of RAM. Why would you remove the /3GB switch ? Am I missing something here ???

... and yet another reason to go back to the 'old' mentality (pre v7.0) of waiting until SP2 for a given SQL release is 60 days old before implementing the...

This ad is kind of 'light' on the requirements. Could you add a bit more than "expert" ...

As a preventative measure I execute UPDATEUSAGE, UPDATE STATISTICS, sp_recompile and sp_refreshview on a daily basis for all but my largest databases (those less than 50 Gb). On the larger databases,...

As of this posting the KB article no longer exists !!!

I would definitely call MS/PSS to make sure your SQL and Sharepoint environment is up to snuff while letting CA do their thing. Your location in the world should not...

I would weigh the business criticality and political visibility of the systems as major factors in deciding whether or not to engage a contractor. 3-5 days is not a long...