GSquared (2/28/2008)

---

Alternately, if you don't often select by year, month, day, but do often join on the whole date, you can add a calculated column:

alter dbo.TableA

add DateColumnDate as cast(convert(varchar(25), DateColumn,...

David Jackson (2/28/2008)

---

This looks complex but will use your index.

where CreatedDate between dateadd(dd, datediff(dd,0,Getdate()),0) --midnight TODAY

and dateAdd(ss,-1,dateAdd(dd,1,dateadd(dd, datediff(dd,0,Getdate()),0)))...

Nicely done, Gregory Jackson. Outstanding intro to the pitfalls of doing calculations in the WHERE clause.

Manie Verster (2/28/2008)

---

😎 I have to agree that identity columns are indeed evil! Especially when someone before you created a database and now you sit with the problems. Example: I...

I believe that is correct... I say "believe" because I've never had to do it... I've only read about it. Gails snapshot option is also viable.

Rumor has it that creating a table on a different filegroup will do what you ask.

You know why #77? You get "eight" more 😉

Was doing some research on Tally tables and...

Just curious... did that solve your problem or did you die? 😉

Heh... nah... it's only 0.229 M rows... same as the other two tests...

I did mislabel it though... probably due to low Caffeine with a Niquil kicker, as well... the last...

Okidoki... first things first... If you don't already have a Tally table, now is the time to add one to your arsenal of SQL prestidigitation... a Tally table (also known...

Perfect... I'll be back soon...

Sorry... just as a courtesy, I should post the code for making a Tally table, huh?

--===== Create and populate the Tally table on the fly

SELECT TOP 19000 --equates to...

Yep... I'm aware of that, but thanks for making sure, Ian.

So far as using spt_Values as a source of numbers in production, I NEVER do it... I always use a...

Ok... is there anything like a CustID or EmployeeNum or some column that I can relate back to that uniquely identifies a given row? Not quite the same as...