Viewing 15 posts - 8,161 through 8,175 (of 8,416 total)
Kurt W. Zimmerman (4/28/2009)
My approach is quite simple. I've established this as a standard development practice and seems to work just fine.
This type of solution has already been posted,...
April 28, 2009 at 7:21 am
Alexander Kuznetsov (4/28/2009)
Here is very good article about datetime by Tibor:
Ooo! Alexander Kuznetzov!
(and he's a 'grasshopper' :-D)
Thanks for the link, Alex.
Cheers,
Paul
April 28, 2009 at 7:19 am
Dallas Martin (4/28/2009)
SQL SVR may have to perform a full table scan. Not exactly what one desires in...
April 28, 2009 at 7:17 am
Ah. A post from Adam. Must be later than I realized. :w00t:
This is probably feeping creaturism, but it would be great if it could handle more complex...
April 28, 2009 at 7:04 am
Paul, a few of the articles out there may be weak, but sometimes the discussion posts turn out to be real seminars.
Understood! I will look out for them.
/P
April 28, 2009 at 6:50 am
Grant Fritchey (4/28/2009)
Either way, they learned something. The rest of us... in this case, not so much.
Ha! My new waterproof monitor guard saves the day again!!
Seriously, thanks for the...
April 28, 2009 at 6:10 am
Ric Sierra (4/28/2009)
Instead of (if you work with MSSQL2005 or 2008) use the DATE and TIME domains, if apply, and avoid calculations. Do you agree? 😉
:ermm: DATE(n) and TIME(n)...
April 28, 2009 at 6:08 am
mister.magoo (4/28/2009)
EDIT: forget it - when I figure out how to post results I will try again!
Ooo! You removed that just as I was quoting you!
Actually the formatting was...
April 28, 2009 at 6:02 am
Karteek (4/28/2009)
April 28, 2009 at 5:50 am
Best wishes to Barry for a speedy recovery.
On a separate subject, can I ask: Are articles checked or reviewed before publication on SSC?
April 28, 2009 at 5:31 am
To anyone listening,
Just for the record, I have to say that this is a poor article.
The author would do well to seek a review of future articles from one of...
April 28, 2009 at 5:27 am
dawidmocke (4/28/2009)
" WHERE DATEFIELD BETWEEN " & @DATE1 & " 00:00:00" & " AND " & @DATE2 & " 23:59:59.997"
I know this works (please...
April 28, 2009 at 5:20 am
Tao Klerks (4/28/2009)
You've just added another dimension of complexity to SQL Performance tuning for me, now I have to go away and think about this. 🙂
The good news is that...
April 28, 2009 at 5:14 am
Hey Flo,
Great stuff - very handy having that all in one post.
You know, Adam's CLR function may not always offer a performance advantage; however it's memory efficiency and potential...
April 28, 2009 at 4:23 am
If you have 3.5GB or more in your server (or you would like it) you need a very good reason not to move to a 64-bit platform.
Paul
April 28, 2009 at 4:13 am
Viewing 15 posts - 8,161 through 8,175 (of 8,416 total)