Viewing 15 posts - 16 through 30 (of 54 total)
Continue creating QotD. It was a good start!
It is a nice question for beginners: If one with "below than average expertise" tried out his first QotD this question surely was...
________________________________________________________
If you set out to do something, something else must be done first.
September 30, 2013 at 4:01 am
Nice idea to write such a book!
I would have appreciated if you hadn't written everything in bold letters and instead had given a compressed overview about the content, as well...
________________________________________________________
If you set out to do something, something else must be done first.
September 30, 2013 at 3:14 am
Also nice piece of information regarding INTERSECT and EXCEPT: NULL values are regarded as the same. A behaviour as if SET ANSI_NULLS were OFF.
________________________________________________________
If you set out to do something, something else must be done first.
September 30, 2013 at 3:04 am
While DELETE is a pure DML statement which has no side effects on an IDENTITY, TRUNCATE resets the IDENTITY and needs ALTER TABLE permission, which appearently means that the...
________________________________________________________
If you set out to do something, something else must be done first.
September 30, 2013 at 2:45 am
In my opinion your questions were tough: You did a very good job! Better than the most questions for politicians in talk shows (that won't answer the questions anyway).
Best regards
Jens-Peter...
________________________________________________________
If you set out to do something, something else must be done first.
September 29, 2013 at 1:54 am
Hi, Tom,
can you imagine my joy when I first thought to have found another worshipper of Vogon poetry? And my disappointment when I realized that this was no Vogon, but...
________________________________________________________
If you set out to do something, something else must be done first.
September 28, 2013 at 10:12 am
L' Eomot Inversé (9/27/2013)
But England is full of ignorant pedants who will claim it is not grammatical, because they insist that the past participle of get is not...
________________________________________________________
If you set out to do something, something else must be done first.
September 27, 2013 at 3:24 pm
logitestus (9/27/2013)
________________________________________________________
If you set out to do something, something else must be done first.
September 27, 2013 at 3:00 pm
Steve, thank you for your work and for this interview: You spend a lot of time doing good things good!
When reading this interview I had the feeling to read the...
________________________________________________________
If you set out to do something, something else must be done first.
September 27, 2013 at 10:49 am
What I found even more interesting:
"The standard varbinary(max) limitation of 2-GB file sizes does not apply to BLOBs that are stored in the file system."
The file size is then, as...
________________________________________________________
If you set out to do something, something else must be done first.
September 27, 2013 at 3:19 am
Was just curious about the behaviour of CTEs with JOINed tables: I expected same behaviour as of views.
IF OBJECT_ID('temp_test_FK') IS NOT NULL
DROP TABLE temp_test_FK;
IF OBJECT_ID('temp_test') IS NOT NULL
DROP TABLE...
________________________________________________________
If you set out to do something, something else must be done first.
September 25, 2013 at 2:51 am
Carlos,
sure, you may be right.
And the topic of this QotD is CTE and the usage of DML.
With the example for identifying duplicate records I wouldn't agree to CTEs being...
________________________________________________________
If you set out to do something, something else must be done first.
September 25, 2013 at 2:46 am
KWymore (9/9/2013)
Miles Neale (9/9/2013)
Ross.M (9/9/2013)
Steve Jones - SSC Editor (9/9/2013)
I have updated the answers and awarded back points.
I was just about to say, don't know what everyone is talking about,...
________________________________________________________
If you set out to do something, something else must be done first.
September 24, 2013 at 6:30 am
Jamsheer (9/24/2013)
I LOVE TRICKY QUESTIONS ALWAYS... THANKS SAMITH..
Same for me, anyway...
________________________________________________________
If you set out to do something, something else must be done first.
September 24, 2013 at 3:13 am
Hoi, Samith,
how fits the explanation of your reference to our problem at hand?
The reference explains something about the parser of SSMS before the execution of the code and the block...
________________________________________________________
If you set out to do something, something else must be done first.
September 24, 2013 at 3:12 am
Viewing 15 posts - 16 through 30 (of 54 total)