Viewing 15 posts - 256 through 270 (of 479 total)
"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...
February 4, 2009 at 4:43 am
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?
February 3, 2009 at 7:14 am
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...
February 3, 2009 at 6:42 am
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...
February 2, 2009 at 7:03 am
Derek Dongray (1/30/2009)
...and the answer to what you were thinking is "probably about 5 hours spread over 3 days". 🙂
And one of the (many) things I learned from The Thread...
January 30, 2009 at 4:40 am
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"....
January 30, 2009 at 4:00 am
Congratulations! I don't remember how I found this site, but I'm glad I did. Keep up the good work.
January 29, 2009 at 9:51 am
majorbloodnock (1/26/2009)
January 26, 2009 at 10:08 am
Jeff Moden (1/23/2009)
Everything else sounds pretty copasetic.
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...
January 26, 2009 at 5:08 am
majorbloodnock (1/23/2009)
Excellent. Good article. Pity it was too late for me to have used.....
A couple of years too late for me too, but mine was a bit simpler 🙂
My 'wish...
January 23, 2009 at 7:24 am
kgayda (1/21/2009)
...removing the battery...
Haven't you then got a paperweight instead of a phone?
January 21, 2009 at 9:04 am
Steve Jones - Editor (1/20/2009)
January 21, 2009 at 7:33 am
Steve Jones - Editor (1/21/2009)
Wings? Paul McCartney? Was he in Led Zeppelin? 😀
No, he just thought Robert Plant should be...as reported here!
BTW, billboards in the UK are currently reminding people...
January 21, 2009 at 5:26 am
eric.gunn (1/19/2009)
January 19, 2009 at 7:35 am
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...
January 13, 2009 at 7:34 am
Viewing 15 posts - 256 through 270 (of 479 total)