You know, we may hit 5,000 before May 31st!! :w00t:

Hey, I've used this: DBCC CheckDB ....REPAIR_ALLOW_DATA_LOSS, but it was on a development database, not a production database so the potential loss of data was immaterial. Plus I did...

This?

select top 10

*

from

dbo.SomeTable

order by

SomeDateTimeColumn desc

georgew (5/27/2009)

---

Apologies for any confusion, Lynn. I thought I had the week start day issue covered with "...you need to set the DATEFIRST property to change the first day of...

Both solutions work. Thanks for posting yours.

Is there an emoticon for sarcasm? looks like we really could use one. 😉

Roy Ernest (5/27/2009)

---

I was not talking about you at all Lynn.. 🙂 But I am talking about people who will give that solution as the first solution before anyone can...

Roy Ernest (5/27/2009)

---

I find it strange that every time there is a problem with Transaction log file size, everyone chips in with truncate of transaction log? These answers comes from...

I went back quite a ways to get questions answered. Took a bit of time and definitely tested my memory.

Here is some code to play with. Please notice how I have setup the data. this is how you should post your questions instead of relying on others...

Yes, this looks more like a running totals problem than a ranking problem.

Unfortunately, Jeff's article is still offline. You can get an idea of the process by looking at...

Ya, I know. That's...

Please do not double post. It just fragments any responses you may get regarding your problem.

Post replies here.

Thanks Roy and Gail. Guess being at the top for the last 30 days didn't last long though.

If there is anything you...