Case is not a control flow statement, it can't return portions of the query. It returns expressions (values)

That you've been monitoring and recording the index usage stats, taking care to persist the results before server reboots...

Spam. Reported.

sqlnaive (5/10/2013)

---

I was checking in my database and found lots of unused indexes. I found it based on summing up the index seeks, index scans and index lookups and comparing...

The same user, immediately, always. A user...

The backup doesn't write to the transaction log, but while there's a backup in progress space in the log can't be reused. If you're seeing autogrow events, it suggests that...

I gave you more than enough to look in Books Online....

sys.dm_db_task_space_usage and sys.dm_db_session_space_usage

If you have inserts, updates and deletes then you have transactions that can get rolled...

Currently it's required at the end of a merge and the end of the statement prior to a CTE. REquirements may well increase in future as the T-SQL language gets...

Sean Lange (5/9/2013)

---

The difference between delete and truncate is that delete is a dml operation that is fully logged and truncate is DDL operation and is minimally logged. What that...

That would have been caused by exactly the same thing that caused the backups to fail, the database being in single-user mode and an existing connection to the database, hence...

sql-lover (5/9/2013)

---

Killing those ad-hoc queries after X minutes will release the IO pressure. So instead of hammering the SAN for 5+ minutes, if they are not done my 1 min...

What error shows problems with...

Correct, it's CPU and RAM, but how does killing a query that's done a lot of physical IO help? The IO's already done by the time you kill the query,...

Description: Executing the query "BACKUP DATABASE [CPAS] TO DISK = N'D:\Data\MSSQL...." failed with the following error: "Database 'CPAS' is already open and can only have one user at a...