Viewing 15 posts - 631 through 645 (of 656 total)
The question asks which is more efficient.
The explanation describes which uses least space, which is not the same thing as most efficient.
I suspect that the answer is correct, but would...
October 16, 2009 at 5:20 am
archie flockhart (10/14/2009)
If you don't know that AND and OR operate bitwise...
October 14, 2009 at 8:48 am
Hugo Kornelis (10/2/2009)
A very unusual pattern, as LIKE is intended to be used with wildcard characters, but syntactically valid.
We use it widely, where searches which can be either on exact...
October 2, 2009 at 4:25 am
Hugo Kornelis (10/2/2009)
October 2, 2009 at 2:41 am
bitbucket-25253 (10/1/2009)
the question was designed to bring attention to the subtle changes made between 2005 and 2008. Too many people fixated on the word (subclauses) and not enough paid...
October 2, 2009 at 2:17 am
The question was "SQL Server 2008 introduces several extensions (subclauses), to the GROUP BY clause"
GROUPING_ID is not part of the GROUP BY clause!
If CUBE and ROLLUP were indeed part of...
October 1, 2009 at 5:10 am
ChiragNS (9/23/2009)
oops!! thought the checkboxes where radio buttons.
And me. I even looked up the answer in BOL, as I'd never heard of the function, and so got the same only-partly-correct...
September 23, 2009 at 4:23 am
A pity that 11 wasn't one of the options - then we'd have had to decide whether casting 10.5 as an integer truncated or rounded (and I would probably have...
August 20, 2009 at 8:58 am
Cliff Jones (8/19/2009)
Mark Horninger (8/19/2009)
Actually, you could do an implicit or explicit conversion....I agree. That was my first thought as well.
Me too. Since there was no 'either implicit...
August 19, 2009 at 10:11 am
sknox (7/23/2009)
I haven't used SQL Server 6.5 or earlier, so I don't know if there was an alternate syntax or if you had to drop and recreate the column.
From memory,...
July 24, 2009 at 4:23 am
SanjayAttray (7/2/2009)
Very basic. But, still 16 people got it wrong as of now. Amazing. :hehe:
34 and counting...
July 3, 2009 at 5:29 am
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_1devconc/html/1e04f7d6-3d82-45ab-9318-92e0640150b2.htm
June 23, 2009 at 3:29 am
hakan.winther (6/17/2009)
June 17, 2009 at 6:36 am
If you later find out it should be unicode, you can change it.
I assume you've never been through the process of converting a large database from varchar/char/text columns to nvarchar/nchar/ntext?...
June 16, 2009 at 2:47 am
Scott Coleman (6/8/2009)
I appreciate the need for NCHAR, but in over fifteen years of database programming and administration I have yet to need to support any foreign language characters.
The application...
June 8, 2009 at 10:08 am
Viewing 15 posts - 631 through 645 (of 656 total)