B-I-N-G-O

The question has been corrected to fix the typo and include an ORDER by clause.

main.denis, sorry we are not responding fast enough for you. It is the morning here, this...

Sample data of what is in the tables, and what the result should be. Not what you are getting with the query that doesn't work.

Simon was once trying to sell SQL Compare to a company and they questioned the value. He pulled out two phone books from different years and 100lb note. Said if...

Sounds like you need more drives. Also, storing backups on the same physical disk as data is a mistake. If it goes, you lose data.

Make sure you have enough space...

I thought an index was a scale for measurement. Isn't that why it's in all those performance questions?

Use CTRL+F5 to reload the page without cache. Windows caches the page a little too much sometimes.

the newsletters got messed up over the weekend as well. Tomorrow should have them going back out on schedule.

Only what's in the default trace. not sure how much information there is.

You can get a tool like ApexSQL Log to read the log itself if you have backups or...

The log backup clears space from the existing log so that it can be reused. It clears the space of the transactions that are in the log backup.

So if you...

Jeffrey,

I'm not sure there is lost revenue. Unless they think they will get significant "double" purchases, which I doubt.

Transactions don't have names, unless explicitly marked them with a BeGIN TRANSACTION and a name.

There's a wizard for the maintenance plan you can use. Just choose log backups to not mess up anything else you have running.

Yes, we will fix the question and reaward points.

Thanks for bringing this to our attention.

What does it not resolve? We can't see your system or the code, so it's hard for us to answer when you don't provide information.

What is it doing, or not...