Forum Replies Created

Viewing 15 posts - 1 through 15 (of 268 total)

  • RE: Log Shipping Information

    Thanks for this interesting question which proved me that I have not understood log shipping.

    It is true that I have never used this feature. So !i will study it...

  • RE: What does sp_setnetname do?

    Nice question. I knew the answer because it happened in an interview 3 weeks after having attended a session where this procedure was explained. Not enough to get the job...

  • RE: Hunting in Packs

    xsevensinzx (4/11/2016)


    Could just be the fact they lacked any real coordination or vision, not that they are all working on the same problem. You didn't, that's why you solved your...

  • RE: ORDER BY ASC and NULLs last

    Nice and interesting question for which I have chosen the bad proposal. I need to study this topic. I will do it during this afternoon. Anyway , an useful question...

  • RE: Forcing Plans in the Query Store

    An interesting question about a topic I have not used for the moment ( I can use Azure but I had no time to study it ). Despite this fact...

  • RE: Hunting in Packs

    Excellent post about a problem which was appearing when I had to stop to work ( around 2000 ). More time to define the structure of an application than to...

  • RE: Which properties exist?

    Thanks for this interesting question.

    I knew the answer only because I had to search for explanations about a case sensitive collation. I discovered that only the fn_helpcollations is giving this...

  • RE: Temporary Table Limitations

    Thanks for this interesting question. I have studied temporary tables after a previous QOD and I found the 2 correct choices ( 4 and 2 ).

    For the other possible...

  • RE: The Email Mask

    Thanks for this interesting question related to SQL Server 2016. As I am curious , I have looked at the SQL Server 2016 CTP2 documentation and I discovered a nice...

  • RE: Select vs Set Local Variable

    Hugo Kornelis (4/3/2016)


    As others have already said, there is no way to guarantee execution order, so there are three answers that are "sort of" correct (0,0 / 1,1 / 2,2...

  • RE: Querying linked servers

    I have used rarely OPENQUERY and linked servers since the release of SQL Server 2008 but it is maybe the only thing I remember ( OPENQUERY ) , so the...

  • RE: Unique Constraints

    Interesting question about which I had to think during 10 minutes , searching where the trick was.

    Amusing the link given towards an article from the old time of SQL...

  • RE: The Endpoint IP

    Thanks for this question.

    I recognized that I tried the ALL IP proposal only because it was the most logical one.

  • RE: The SIGN

    Thanks for this really interesting question :

    1) the comments of everybody were useful as I don't remember the last time where I used SIGN ( maybe 2 or 3 years...

  • RE: Select vs Set Local Variable

    Interesting question which remembered me a discussion in an old question in a MSDN/Technet forum.

Viewing 15 posts - 1 through 15 (of 268 total)