Go to Start > programs > Microsoft SQL Server > Configuration Tools > SQL configuration manager > expand SQL Network Configuration > Protocols for 'instancename' > right click tcp\ip >...

Run the command on your fragmented database- it will not execute anything, only print the command. You can run this on a copy of live if need be, it will...

600 databases on one instance?? That maintenance schedule must be fun!

This will show you all of your index's which are fragmented between 5% and 40% - you can easily change this to execute the command rather than just print. and...

Yes they are both windows services but the Agent will use very little memory. You should always leave 4GB for the OS. The SQL service can take the rest. The...

Its coming back saying 2 SQL accounts are orphaned but I wouldn't think the error I am getting would be due to orphaned accounts?

Its not actually specifying an account in the error but yes ive checked all the accounts and none are locked\disabled.

Cheers for your time though.

As a DBA in organizations where I have worked, we don't own the data, the business do. The only real reason they would need access to live data is if...

Alan,

Thanks for the code, works a treat and as you say, its easy to modify for the other services other than just the instance.

CHeers - I do have a powershell script but I have no idea if its possible or how to insert this into a SQL table.

I want to input the...

DBCC LOGINFO < this will show you the amount of VLFs you have

I would always

1) pause the passive node

2) run the service pack on the passive node

3) fail the sql instance to the passive node and test

4) if test is successful, run...