Fill Factor should be chosen depending data modification on the table so that page splits won't occur often resulting in fragmentation. It is just percentage of page you want...

How about using "SP_MSFOREACHDB"

Depends on the version of LITESPEED that you are using, or it’s a native backup.

We upgraded to the latest version of litespeed to solve it the last time we saw...

I wouldn't run Update stats job in SQL 2005, by default auto update stats option is set to on in SQL 2005, That update stats job cause you lot...

Set up replication to run under same account as SQL server account, If you want to set up different account assign SA role to that Login, this should fix your...

You can use activity monitor to findout from which SID, Host name and Database name the connections are coming from. There is no way to findout what is the...

Are you refereing to Instance name? Like Default and Named instance.

Nothing will happen, you will see bunch of error messages in SQL server log. Script out the failed subscription and drop the failed subscriber form the publisher, just to keep...

Try this!

select serverproperty ('MachineName')

Best practices is to place TempDB MDF and LDF files in different drive than other user databases. The reason is tempdb log file will use complete disk space some times,...

It incresase performance at disk level

Make sure both results are same when you run these statements, assuming default instance name.

select @@SERVERNAME

go

select serverproperty ('ComputerNamePhysicalNetBIOS')

EnjoY!

Check the windows events logs and SQL server logs.

I don't think you will face any challenges, Upgrade Passive node and failover SQL instance to passive node and do the failover\failback few times before you upgrade other node. It...

Did you try to start from SQL Server Configuration Manager?