Also DBCC SQLPERF(LOGSPACE). Perhaps it just filled up due to something wierd but is now mostly empty.

Hot off the presses, and quite appropriate for this post:

Paul White on Temp Object Caching

1) Use Temporary Tables in EVERY situation that you can. I my 45000 or so hours of SQL Server experience and training, the situations where you cannot are pretty rare...

Everything any GUI that interacts with SQL Server just sends in TSQL. Using Profiler to capture what tools do is a GREAT way to learn how things work both with...

This sounds like a gaps and islands problem. Search Itzik Ben-Gan gaps and island sql server for some solutions.

BTW, my guess is that any solution that involves a...

So this seems to be a pretty straight-forward running-total problem, where you simply get the earliest contestant with a running total that crosses some minimum score. Read up stuff by...

1) Why is a DELETE a no-go?

2) You didn't give us enough information. The key missing component is how many rows will remain in each table. Take it...

This looks like an interesting problem. Key questions:
1) if a user has 3 100 value rows and they put in 300, do you show all 3 of the...

Modern cameras, with their immense pixel count,  can take pictures with tens of megabytes of size. That is a lot to put into the buffer pool. It could represent thousands...