Viewing 15 posts - 2,386 through 2,400 (of 3,348 total)
Steve Jones - SSC Editor (4/12/2011)
You do not have to post to get points...
April 12, 2011 at 7:29 am
Hmmm, weird.
In the newsletter, the question is about nvarchar(30). On the site, the data type is nchar(30). Maybe Steve changed the question after seeing all the messages? Usually, he also...
April 12, 2011 at 7:03 am
Tom.Thomson (4/11/2011)
April 12, 2011 at 6:51 am
martin catherall (4/11/2011)
April 12, 2011 at 6:40 am
SanDroid (4/7/2011)
GSquared (4/7/2011)
Diagram it out on a piece of paper. Just a simple flow-chart. You'll quickly see...
Wish Flow charts where better here.
Temp Tables are logged --> MARS...
April 7, 2011 at 12:40 pm
Good question, Wayne!
I especially liked the link to Gail's blog. I figured that the table variable option was the correct answer and answered without contemplating the version store option. I...
April 7, 2011 at 8:49 am
Nakul Vachhrajani (4/5/2011)
Gopinath Srirangan (4/5/2011)
3. Without having primary key or unique key just create unique clustered or non clustered index.
Below code still gives the same result without defining primary or...
April 6, 2011 at 3:00 am
Nice question! And I just love the punny title.
UMG Developer (4/5/2011)
Nice question, thanks!How many people actually use the ODBC date literals?
Few, I would hope 😉
Luckily I have seen them before,...
April 6, 2011 at 2:57 am
Steve Jones - SSC Editor (4/5/2011)
Hugo Kornelis (4/5/2011)
Hey Steve,I'm not sure if your assumption holds.
Not an assumption, or it wasn't for me. I had 4 items closed with no comment....
April 5, 2011 at 9:10 am
vk-kirov (4/5/2011)
Hugo Kornelis (4/5/2011)
The index created for a UNIQUE constraint will be clustered if there is no clustered index yet on the table, nonclustered otherwise.
Not true. See the 'CREATE TABLE'...
April 5, 2011 at 6:54 am
martin catherall (4/5/2011)
One thing that I'd add is that as the unique key will be created as a non-clustered index where as the default for a primary key is...
April 5, 2011 at 3:36 am
Funny - I take some things I know so for granted that I don't even consider it might not be as elementary for others.
In this case, it was the PRIMARY...
April 5, 2011 at 12:59 am
Hey Steve,
it seems that most of these items were closed and marked as "Won't Fix", which I assume means these will not be fixed for SQL 11.
I'm not sure if...
April 5, 2011 at 12:52 am
Tom.Thomson (3/29/2011)
I wonder what happens with
DECLARE @bit BITSET @bit i
Set @BIT += 2147483646
SELECT @bit
Is it NULL, or is it 1?
I assume that you meant the first SET statement...
March 30, 2011 at 12:50 pm
SanDroid (3/28/2011)
Hugo Kornelis (3/28/2011)
I was surprised at first at the "SELECT @i+=1" syntax. I knew about the compount operators and have happily used "SET @i=1", but seeing...
March 28, 2011 at 12:31 pm
Viewing 15 posts - 2,386 through 2,400 (of 3,348 total)