Viewing 15 posts - 3,151 through 3,165 (of 7,484 total)
What happens if, in the final select that does return the data, you replace "= 'Year End'" by "LIKE 'Y'", and similar for "= 'All'" ?
September 7, 2013 at 1:46 pm
I recall once threating to kick the stuffing out of someone who was tasked to fix an instead of trigger that he had written to assume only one row and...
September 7, 2013 at 1:28 pm
Is there any indication whether their "will not fix" applies just to 2011 or does it cover 2014 too, so that we can expect to see no fixed release for...
September 7, 2013 at 1:14 pm
Jack Corbett (9/6/2013)
Steve,I can take this one. Especially since I've been burned by it.
Be sure to mention the pesky bug in the article. do...
September 7, 2013 at 7:21 am
Does the removing the duplicates job include adding a constraint to make sure the problem doesn't recur?
September 7, 2013 at 7:14 am
Not sure what one row at a time means (or indeed what the relevance of a batch is) here; the specification of T-SQL makes it quite clear that the statement...
September 7, 2013 at 6:57 am
Revenant (9/6/2013)
SQLRNNR (9/6/2013)
L' Eomot Inversé (9/6/2013)
Ed Wagner (9/6/2013)
SQLRNNR (9/5/2013)
crookj (9/5/2013)
jasona.work (9/5/2013)
SQLRNNR (9/5/2013)
crookj (9/5/2013)
batgirl (9/5/2013)
Cliff Jones (9/5/2013)
crookj (9/5/2013)
Ed Wagner (9/5/2013)
Gatling GunVulcan
Spock
He's dead Jim
"It's just a flesh wound...."
What? I'm not dead yet.
Yes,...
September 6, 2013 at 10:52 am
Ed Wagner (9/6/2013)
SQLRNNR (9/5/2013)
crookj (9/5/2013)
jasona.work (9/5/2013)
SQLRNNR (9/5/2013)
crookj (9/5/2013)
batgirl (9/5/2013)
Cliff Jones (9/5/2013)
crookj (9/5/2013)
Ed Wagner (9/5/2013)
Gatling GunVulcan
Spock
He's dead Jim
"It's just a flesh wound...."
What? I'm not dead yet.
Yes, you are, now lie back...
September 6, 2013 at 7:43 am
ksatpute123 (9/6/2013)
http://technet.microsoft.com/en-us/library/ff486956.aspxI believe the question was picked directly from here.
I hope not. If it was, whoever did the question totally misunderstood the page; the question is about metadata; the...
September 6, 2013 at 7:14 am
Interesting question.
I haven't used this stuff, so my answer was based on very limited knowledge and was wrong. I'm a bit confused about this stuff. The...
September 6, 2013 at 6:50 am
This question is somewhat confused and the answer is wrong.
It says the files "not be removed immediately" and asks how to force this garbage collection to occur. ...
September 5, 2013 at 11:26 am
Excellent question, correct answer and explanation. This is something where people can easily go wrong, as some of the MS documentation is a bit confused.
Hany Helmy (9/3/2013)
September 4, 2013 at 7:05 am
Toreador (9/3/2013)
Don't worry, he can't spell my nickname properly either 😉
For some reason he never gets mine wrong :-D.
If my nickname were Toreador I think I would change it...
September 3, 2013 at 9:28 am
Hugo Kornelis (9/3/2013)
L' Eomot Inversé (9/3/2013)
September 3, 2013 at 8:44 am
sknox (9/3/2013)
Nobody's mentioned what I consider to be the biggest problem with this question yet.
I'm talking about the following two answer choices:
The first query returns a Tally table and the...
September 3, 2013 at 6:41 am
Viewing 15 posts - 3,151 through 3,165 (of 7,484 total)