Viewing 15 posts - 871 through 885 (of 1,187 total)
Chad Crawford (3/4/2009)
.786 isn't a valid millisecond for the datetime datatype...
All datetimes end in either .xx0, .xx3 or .xx7
.xx9, .xx0 and .xx1 are rounded up/down to .xx0
.xx2, .xx3, .xx4...
March 4, 2009 at 10:13 am
Ninja's_RGR'us (3/4/2009)
...
I'm going to go with:
b) 2009-02-09 16:35:56.789
UPDATE: I ran the result and got c) 2009-02-09 16:33:56.790. (My original second choice.) Why do the milliseconds get rounded up?
Thanks,
webrunner
It's the...
March 4, 2009 at 8:35 am
***********SPOILER ALERT***********
john.arnott (3/3/2009)
For one additional degree of difficulty: What's the result from this query?
select DATEADD(HOUR,5,DATEADD(MINUTE,-59,'2009-02-09 12:34:56.789'))
a) 2009-02-09 07:34:57.789
b) 2009-02-09 16:35:56.789
c) 2009-02-09 16:33:56.790
d) 2009-02-09 16:35:56.790
I'm going to go with:
b) 2009-02-09...
March 4, 2009 at 6:54 am
Hi Steve,
I got this message in place of the daily SQL Server Central newsletter. Was there a problem with the outgoing message?
FILE QUARANTINED
----------------
The original contents of this file have been...
February 27, 2009 at 7:00 am
Thanks for the article. As you said, I hope I will never need it - though just last week I saw the first, trivial, error that I repaired with the...
February 17, 2009 at 8:03 am
Fiendish question, yet practical. (I got it wrong by choosing 1,4,5,7,8)
Nice work.
Thanks,
webrunner
February 11, 2009 at 6:59 am
Thanks, Jeff,
This is good advice for any type of forum post for help. But especially useful for SQL.
- webrunner
February 9, 2009 at 9:09 am
Good question (though I got it wrong :(). The only quibble I have with the formatting is the use of the term "function(s)" in the question.
The "(s)" doesn't make sense...
February 6, 2009 at 7:44 am
Here are the movies from 2008 that I highly recommend:
Doubt
The Dark Knight
Juno
The Curious Case of Benjamin Button
WALL·E
Kung Fu Panda
Mamma Mia!
I'd also recommend Eagle Eye, Iron Man, and The Hulk. They...
January 30, 2009 at 9:59 am
Congratulations, Steve!!!
You've earned it - even if you do wear a t-shirt in your photo[/url]! :w00t:
(See the discussion to get the joke.)
Cheers,
webrunner
January 30, 2009 at 9:35 am
I think this may be a more general database technology problem than a specific feature lacking in SQL Server, but I wish there were some way to load balance databases....
January 23, 2009 at 11:40 am
Stephanie J Brown (1/13/2009)
Steve Jones - Editor (1/13/2009)
OK, I'm really confused now. I was going to change the picture to a new shirt, but most people like the shirt.
Allow...
January 13, 2009 at 9:50 am
majorbloodnock (1/13/2009)
gcopeland (1/13/2009)
majorbloodnock (1/13/2009)
Given your stated opinions earlier in this thread, I think Steve can fairly safely take that as a compliment. 😉
Given "my stated opinions"...Is that the best you...
January 13, 2009 at 9:27 am
Update 2: We restarted the SQL server as part of a firmware upgrade, and, as odd as it may sound, the jobs in question are now running properly.
I'm not sure...
January 9, 2009 at 4:26 pm
mhaskins (1/9/2009)
webrunner (1/9/2009)
...
1. If the current photo says what you like, then leave it.
2. If you want to dress up a bit, you could make a polo shirt with...
January 9, 2009 at 8:45 am
Viewing 15 posts - 871 through 885 (of 1,187 total)