"As many as are necessary, but no more."

Indexes are used to speed up queries but have the downside that they may slow down inserts and updates. Hence you need to...

I'm not sure I've understand what you want here.

If you want all records greater than a month old, why isn't 2008-01-03 23:48:36.024 in your result set?

If you are deleting an entire table you could use TRUNCATE TABLE, which only logs the page deallocations rather than having an entry for each row deleted. I'm not aware...

I think you need to do something like

select * from (

SELECT a.Employeeid, a.FromDate, a.ToDate,

ROW_NUMBER() OVER(PARTITION BY a.Employeeid ORDER BY a.FromDate) AS sick_sequence

FROM #tempsick a

join #tempsick b on...

And one of the (many) things I learned from The Thread...

Do I get a prize for reading every post on The Thread before posting?

...and the answer to what you were thinking is "probably about 5 hours spread over 3 days"....

Congratulations! I don't remember how I found this site, but I'm glad I did. Keep up the good work.

majorbloodnock (1/26/2009)

---

I can easily see this being a parallel scenario. Company docks money from employee for reboots, employee bills company for loss of earnings when reboot was caused by a...

That's the first time in many years I've have to go and look up the definition of a word because I had absolutely no...

A couple of years too late for me too, but mine was a bit simpler 🙂

My 'wish...

Haven't you then got a paperweight instead of a phone?

Steve Jones - Editor (1/20/2009)

---

I've love to have a secure cell phone, something that couldn't be scanned or eavesdropped on, but at $3,000+ a copy, I'm not sure I'd get...

No, he just thought Robert Plant should be...as reported here!

BTW, billboards in the UK are currently reminding people...

eric.gunn (1/19/2009)

---

I was recently checking out some of the new HP home computers with touch and my first thought was cool. After a minute it changed to cool, but...

Excellent article!

The first two recommendations probably apply to anyone providing a service (which is probably most people!). I've known far to many situations where being asked for someone resulted...