Viewing 15 posts - 76 through 90 (of 268 total)
Good question but an easy one because I faced this problem when I installed my 1st SQL Server 2014 as I have had to study the differences between 2014 Express...
November 14, 2015 at 3:23 pm
Easy question.
1 ==> missing spaces inside the searched string
2 ==> not beginning by a space ( I missed it in an interview some years ago )
3 ==> OK
4 ==> missing...
November 14, 2015 at 2:37 pm
I got the points only because rugby is a national sport in my country and there was no correct proposal : the TRY_CONVERT is giving 2 more points after the...
November 10, 2015 at 4:08 pm
Thanks for this interesting but poisonous QOD which was not easy to answer as it is mixing file system ( too often overlooked by the DBAs ) and SQL Server.
But...
November 8, 2015 at 3:33 pm
I knew the good answer only because a friend of mine had to face this question in an interview 2 years ago. Like him , I gave the wrong answer...
November 7, 2015 at 5:01 am
Filetable is not my favorite topic so I had to try to find the most logical choices ( according to me ). I got 2 points in a surprising way....
November 4, 2015 at 5:46 am
Thanks for this nice question that I was able to answer thanks to a session I followed in 2014. I remembered that the speaker was not pleased about a question...
November 4, 2015 at 4:41 am
TomThomson (10/5/2015)
sknox (10/5/2015)
This question is almost more about TRUNCATE than IDENTITY. All of the inserts before the TRUNCATE are just red herrings.
To some extent I agree, but I would...
November 4, 2015 at 3:53 am
Interesting question about I never used thru T-SQL.
I discovered the WITH NORECOVERY when I tested how to backup with SMO ( there is an option which permits to visualize the...
October 7, 2015 at 9:34 am
serg-52 (9/25/2015)
RonKyle (9/24/2015)
I have reworded to ask about classes.
So... how do we get to answer the question again with the revised wording?
Just don't answer in a hurry, wait...
October 7, 2015 at 4:36 am
September 28, 2015 at 10:55 pm
tbailey 19088 (9/28/2015)
This rename can be done using sp_dropserver and sp_addserver @local='local.
I tested this on one of my development boxes that had only a single, default-named instance. First, I ran...
September 28, 2015 at 6:20 pm
TomThomson (9/27/2015)
paul s-306273 (9/23/2015)
...thought MS had made it reasonably easy to determine what LAG and LEAD do. For those using the language it's just plain English.
The rows that lead...
September 28, 2015 at 5:37 pm
Stewart "Arturius" Campbell (9/22/2015)
Interesting question, thanks SteveAnother of the functions copied from Excel.
I don't think so. These functions have been introduced only to make easier the translation Access towards SQL...
September 23, 2015 at 4:52 am
Viewing 15 posts - 76 through 90 (of 268 total)