Viewing 15 posts - 196 through 210 (of 221 total)
Truly a good question because it provoked a lot of thought as to which techniques are possible, valid and practical.
I got it "right" (yay!), but after reading the discussion I...
December 2, 2010 at 5:38 am
This is not a particularly very well designed question. What is a comment and what is the definition? I would say the comments inside an object are part of the...
December 1, 2010 at 2:26 am
Great question.
But the version should have been specified. In SQL 2000 you can see the execution plan even for encrypted procs. Although that would probably have been a dead giveaway...
November 26, 2010 at 12:48 am
Good question!
I was pretty sure that the first create would fail since the operator ^ isn't described in BOL under arithmetic operators. It never occured to me that it could...
November 10, 2010 at 1:06 am
Oleg Netchaev (10/29/2010)
looked so ridiculous that it made me think...
October 29, 2010 at 12:43 pm
Carlo Romagnano (10/29/2010)
I think the question author tried to confuse us with the syntax for compound operators
I think the question author CONFUSED himself with the syntax for compound operators,...
October 29, 2010 at 6:18 am
I realized there was probably a 50% risk of getting it wrong which I did. :crying:
Interestingly in BOL it wasn't specified whether assigning a new identifier with NEW_BROKER actually enabled...
October 26, 2010 at 6:39 am
Good question!
Maybe I shouldn't admit it, but Activity Monitor is something I had completely missed. DOH!
October 20, 2010 at 4:05 am
Hugo Kornelis (10/13/2010)
October 13, 2010 at 4:21 am
MHilsher (9/24/2010)
I've got some similar situations in a database that I'm working with and found that the alternative seems to be just as bad. We've created functions to get...
September 24, 2010 at 9:22 am
jeff.mason (9/24/2010)
September 24, 2010 at 7:45 am
sjimmo (9/24/2010)
Hugo Kornelis (9/24/2010)
--------------------------------------------------------------------------------
if the table is used in replication, ..., SQL Server requires that a surrogate key with the UNIQUEIDENTIFIER data type is also present in the table.
I...
September 24, 2010 at 7:25 am
Hugo Kornelis (9/24/2010)
The more I think about this, the more I disagree with the notion that multiple identifier columns is a design flaw.
Agreed. And the SQL standards agree too, if...
September 24, 2010 at 6:47 am
Hugo Kornelis (9/24/2010)
As to the GUI - though I'd never call the...
September 24, 2010 at 3:25 am
Viewing 15 posts - 196 through 210 (of 221 total)