TempDB is accounting for 70% of your read and 70% of your write activity. Where is the TempDB LDF file located? Is it on the volume with...

Short answer: the backup is transactionally consistent to the point when it finished (8pm).

Longer answer: consider this thread: http://www.sqlservercentral.com/Forums/Topic958470-391-1.aspx#bm958540

The counters supplied are for the Physical Disk (_Total) counters, so it's impossible to say much more than "your disks are being hammered by writes". But, it's impossible to...

sp_spaceused outputs two resultsets. The first, which you've quoted, includes the transaction log size. The second contains data size. Reserved is the total KB, er, reserved, and...

The main factor driving compression rates (these aren't customisible), is the compressibility of the data. If your database is 25 GB of JPEGs, encrypted data (TDE!), or other such...

Yes. SQL Server 2008 Developer has all the features of Enterprise Edition. See http://msdn.microsoft.com/en-us/library/cc645993(SQL.100).aspx

SQL Server 2008 R2 Developer has all the features of Datacentre Edition - a few...

The reason you're getting an index scan is because of the % wildcard at the start. If you think about an index on a last name, you'll have an alphabetical...

While I absolutely agree with the others that you need free space in your data files to perform maintenance, you may be able to get by by disabling your non-clustered...

A reorganisation typically follows the same rules as a rebuild, it's just the "how" that changes (reorg shuffles stuff around, rebuild rebuilds). The main difference between the two is...

If you have 2xQuad core processors, then you have 8 cores, and should see 8 "CPUs" in Task Manager. (If you are hyper-threading, you'll see more.) Kevin's suggestion would...

TDE works by encrypting every page before writing it to disk, and decrypting every page when reading it into memory. This means that there is no performance hit having...

The usual reason for this is the size of the index is so small that index fragmentation figures make little sense. I can't remember if it's 100 pages (800...

Is this a SQL Server 2005 Replication question?

Processes are put into the suspended state if they are waiting on another resource. Use the following query to find out what...

Thanks Jim, the BETWEEN version works indeed. However, that doesn't really help me as it is beyond my control what WHERE clause is being thrown at me. Seems like taking...

Paul Randal is quite good at explaining stuff, but that article may be a little intimidating - but well worth the read.

In short, because the full backup process backs up...