Providing the log records are there. Backups are still (and probable always will be)...

why not....

Hint hell:

SELECT CompanyName, OrderDate, ProductName, OD.UnitPrice, Quantity, SUM(OD.UnitPrice) * Quantity TotalPrice

FROM Orders O with (INDEX = CustomerID)

INNER LOOP JOIN [Order Details] OD WITH (INDEX =...

Do you have a backup of master?

Can you post the table definitions (as create scripts), some sample data (as insert statements) and your expected results please?

Does the file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG" exist? Is it readable?

Do you have a backup of the master database?

Can you do a check of the C drive? It looks like...

Triggers have uses, but I'm not sure that business logic is a good one.

For me, auditing is the main use. In 2008 Change data capture and change data tracking can...

I had one of those investment-type spams that made me laugh because of the coincidence in it.

It started

"Since you are not a client of XYZ bank ..." with XYZ bank...

Chad Churchwell (11/7/2008)

---

I use sys.dm_db_index_usage_stats to find obselete indexes that have not been accessed and are unneeded overhead in the database.

I also use sys.dm_db_missing_index_group_stats and sys.dm_db_missing_index_details to identofy indexes that...

Barkingdog (11/6/2008)

---

From the user's perspective their application appears to stop functioning until we use sp_who2 to find the user causing the block and ask that user to close the open...

Look up ALTER DATABASE in books online. It will be one of the Modify File options.

ALTER DATABASE < DB name > SET OFFLINE WITH ROLLBACK IMMEDIATE

The (unexpected) answer is both.

Physical and readahead reads are physical IOs, ie they are reads from the physical disk. Logical reads are reads from memory.

So, your second query required more...

That's a wide-open question

SQL not running

SQL running but no accepting connections

Database corruption

Backup failures

Drive failure (data file, log file or both)

User deleted data accidentally

Deadlocks

Query running yesterday, giving error today

... etc

If you...

Assuming the DB is in full/bulk logged and there is a database...

Almost. For the sample data you...