Viewing 15 posts - 46 through 60 (of 831 total)
Kev T (11/25/2014)
For those that may not know, it is because of the move from the Julian Calendar to the Gregorian calendar in 1752 saw 11 days in September never...
November 25, 2014 at 2:57 am
Yeah, I also put "none of the above" because of the 4Gb recommended minimum for non-Express editions.
November 14, 2014 at 2:08 am
Just took a blind guess at this one because I've never used the wizard--I'd import a flat file using BULK INSERT and then spend hours reading through the error tables...
November 6, 2014 at 2:46 am
I confess I cheated: I found an animated GIF on your blog that had pictures of all the shirts in it, and counted the frames. 🙂
October 31, 2014 at 5:38 am
Think about it for a second. If you could somehow achieve what you wanted, all that will happen is that the same client will do the same thing, but get...
October 17, 2014 at 2:36 am
Maybe the author chose the column name deliberately to catch out people who just run the SQL rather than thinking about their answer? I mean, the error about incorrect syntax...
October 15, 2014 at 1:58 am
Stefan Krzywicki (9/11/2014)
Oh thank goodness a reasonable answer. It isn't varchar(7) it is datetimeoffset(7)
That's disappointing--I was kind of hoping that the VARCHAR(7) date would turn out to be the octal...
September 11, 2014 at 7:26 am
This is one of those questions where I'm glad I didn't read the documentation and selected what looked like the most logical answer, because BOY is that documentation for ALTER...
September 2, 2014 at 3:37 am
I thought the interesting part was that the actual "name" part of the table name *is* only 116 characters long--apparently, the # showing it's a temporary table is counted as...
August 21, 2014 at 1:38 am
Internal note: try reading the *whole* MSDN bit about TABLOCK before answering...missed that very important last line! 🙁
August 20, 2014 at 8:52 am
LutzM (8/19/2014)
It has been even worse last weekend... Approx. 85 out of 100 posts were plain spam.
The Monday newsletter e-mail was somewhat interesting--I think it highlighted 40-odd new posts in...
August 20, 2014 at 2:40 am
Gary Varga (8/19/2014)Perhaps craft instead of art? Some might also be tempted to say it is not the artistry but the laziness.
Except it could be argued that the person who...
August 19, 2014 at 7:30 am
I probably count as both, too, but the distinction with me is that I'll take the "artist" approach for something that I know will only happen a few times--the extra...
August 19, 2014 at 4:02 am
I turned 7 in the middle of 77--I just about remember all the bunting being up for the Silver Jubilee. Can't remember if that was the year that everyone from...
August 15, 2014 at 2:56 am
Does such a thing even exist? Reliable, maybe, effortless is a bit of a stretch, though. 🙂
August 13, 2014 at 7:02 am
Viewing 15 posts - 46 through 60 (of 831 total)