Jeff Moden (7/9/2010)

---

Ah.... just found another email from Elena... the Tally Table session in "Approved" and the Hierarchy session has been labeled as an "Alternate" in case someone has a...

GabyYYZ (7/8/2010)

---

Hi folks, I posted a question regarding SQL 2008 Auditing and cycling through the audit logs. What I'd like to know, is there a good intro to Auditing...

I'm not following what it is that your asking for???

doobya (7/8/2010)

---

If you don't mind, I'll just go ahead and disagree with you on all those points. 😉 It all works exactly as I expect it to work according...

I don't know what they're going to call it, but I'd bet that the version number starts with "11."

Thanks for supplying some test data and the expected results. It would be a lot easier to help you if you would have supplied it in the format I've used...

In that case, in addition to reading Part 1 of the article that CC mentioned above, check out Part...

Lowell,

This is neat. I'm storing this in the "bag-of-tricks"!

Someone wrote a complicated view once. It was used in a stored procedure, but since it didn't have all the columns the proc needed, joined back to the tables that...

CirquedeSQLeil (7/8/2010)

---

I did hear something just this last month about an acquisition of a company that sold software that allows you to load balance. The acquisition was of course...

Weren't you just teaching how to do this? 😀 (ducking and running!!!)

Since you posted in a SQL 2005 forum, I'm assuming that you are on that version, which means that the sql 2008 date/time enhancements won't help you:

declare @minutes int =...

declare @testdate datetime

set @testdate = '20080131'

select DATENAME(month, @testdate)

Distinct based upon what?

Your query is producing the correct results for the data you have.

You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts...

If you use a function on a column in the where/join condition, you are essentially forcing a scan. You need to recode your expression to eliminate the function on the...