Viewing 15 posts - 631 through 645 (of 717 total)
antony-688446 (6/13/2010)
Come on, give the guy a break - you can see that Null has been cropped off! Not another huge discussion on assumptions!
But for all you know there...
June 13, 2010 at 11:14 pm
I got it wrong because I didn't read the question correctly, I thought it was asking how many rows where returned.
But in any case even 3 is not the correct...
June 13, 2010 at 1:13 am
lmu92 (6/11/2010)
For two reasons:
#1) it requires at least a little more effort to run it before answering (for those who otherwise would...
June 11, 2010 at 7:01 pm
My initial reaction was that it would return one row, but I thought this is too easy for a question worth 3 points. So I looked a little more and...
June 11, 2010 at 9:49 am
CirquedeSQLeil (6/10/2010)
nelsonj-902869 (6/10/2010)
michael.kaufmann (6/10/2010)
Very interesting behavior--especially given the fact that BOL states one cannot set the MODEL database to READ_ONLY (that's why I...
June 10, 2010 at 3:25 pm
Hugo Kornelis (6/10/2010)
June 10, 2010 at 9:40 am
Great question, thanks! Though it would be nice for a little explanation behind the results.
Considering that BOL states:
"The following operations cannot be performed on the model database:
•Setting the database or...
June 9, 2010 at 9:16 pm
DLathrop (6/9/2010)
Full three part naming helps the query optimizer recognize and reuse queries in the execution plan cache.
I understand that you need to use two part naming, but I have...
June 9, 2010 at 3:55 pm
Nadrek (6/9/2010)
B) Always use three part naming, so you either execute:Adventureworks.Person.(otherprefix)ReturnSomething
or
Master.dbo.(otherprefix)ReturnSomething
both of which make it explicitly obvious what you're calling.
That sounds nice, but it causes problems...
June 9, 2010 at 10:56 am
Interesting article, thanks. I'm not sure I will end up using it, but I will keep it in the back of my mind for when an issue might come up.
June 9, 2010 at 10:53 am
Neeraj Gupta-485504 (6/8/2010)
Could you please elaborate the use of binary checksum function.
Here is a link to BOL for it: BINARY_CHECKSUM
Essentially you could do something like:
UPDATE A
SET LastName = B.LastName
FROM...
June 9, 2010 at 10:37 am
Jason, thanks for this great article, I can't wait to get our production server upgraded so we can actually start using some of these features!
June 8, 2010 at 10:30 pm
JohnSQLServerCentral (5/6/2010)
June 8, 2010 at 10:29 pm
Great question, thanks Jason!
The old don't start your SP names with SP_
I really wish I knew all of this 13 years ago... 😉
June 8, 2010 at 10:00 pm
Viewing 15 posts - 631 through 645 (of 717 total)