If you are looking to spread around your data and log files for multiple databases then you will want to drill down further and get read and write figures for...

gotta ask........who's jonathan?

preventative steps - ensure no connections to database then backup the database

Use the alter database modify file method to move the file, preserves dbowner, dbid and default database settings for...

Using the last_batch column in sys.sysprocesses is one way to go here, looking for any connections that have not executed SQL for a time that you would consider means the...

Jeff Moden (12/27/2009)

---

I guess I don't understand the supposed dilema here... if Cumulative Updates really are cumulative and include all fixes since the last service pack, isn't that just as...

There's not that many, the log reader agent and the distribution agent should be disabled. Snapshot as well if you have that enabled. Keep an eye on log growth whilst...

This web site, sql-server-performance.com. explore microsoft technet, use google.com/microsoft to search and refer to Books Online, which you can download from technet.

Get hold of SQL Express or the developer edition...

You should get mostly 64K read and writes on your data drive. Activity such as db backups can be in larger chunks.

activity on log drives would be mostly 4K sequential...

the 'product' is MSCS - Microsoft clustering services, which is at the Os level. You install SQL server on top of that. It allows a physical server to act as...

Thats a big question with no easy answer. Two things I would say though, I wouldn't want to start from where you are and replication would be my last choice...

To cover the first part of your question SQL retrieves data in extents, which are 64K. This is why it is best to format your data drives with a blocksize...

DTS info are all in tables starting sysdts%

select name from msdb..sysobjects where name like 'sysdts%' and type = 'U'

job info they all start sysjobs%

select name from msdb..sysobjects where name like...

run

dbcc sqlperf(logspace)

and post result for relevant database

whilst in database run

dbcc opentran

and post result

Impact of shrinking log file can be minimal if you do it immediately after a log backup or when the log has a small active portion. Still good practice to...

there should be a number of scripts on this site designed to monitor for blocking, many actively monitor for blocks of a certain length and fire off code to store...