Forum Replies Created

Viewing 15 posts - 16 through 30 (of 121 total)

  • RE: INTERSECT

    Nice question, Satish, thanks. It's good to know about INTERSECT; it's like an inner join, but with all of the columns automatically put into invisible ON clauses:

    SELECT A.ID

    FROM A

    INNER JOIN...

  • RE: Filetable Insert Triggers

    Thanks for the question, Andy. I haven't worked with filetables, so I wasn't sure about this (and I got it wrong :(). I was able to deduce that the file...

  • RE: Filetable Trivia

    Nice question, Andy, even if the explanation of the subdirectory limit was incorrect. I also found the first answer easy (I knew it was new to 2012), but picking the...

  • RE: Identity Column

    I agree with Tom that the statement about multiple identity columns had nothing to do with the question. Otherwise, it's a nice, simple question when you see the TRUNCATE TABLE...

  • RE: Branching in VCS

    Easy one. Thanks, Steve.

  • RE: BimlScript Indicators

    michal.lisinski (9/16/2015)


    Nice one, but this star is a bit tricky 😎

    Thanks

    That's a gold star for getting the correct answer!

  • RE: Column aliases

    I agree with a lot of people here, the correct answer should be 3, based upon structure, not decorations:

    SELECT x AS y

    SELECT x y

    SELECT y = x

    Brackets, quotes, or double...

  • RE: Redirecting Output

    It's much better to make the combination harder by doubling the numbers. 2,4,6 is much better, don't you think? 😀

    Nice easy question, Steve, thanks.

  • RE: Why Use Version Control?

    I have used version control (SourceSafe, StarTeam, RCS, TFS, and a couple others) at several jobs now, and I think it's very important, for all of the reasons previously mentioned...

  • RE: TIME Datatype

    Nice, easy question. Thanks, Raj!

  • RE: Pounds of Formatting Fun

    Nice question, Andy, thanks. I was somewhat expecting the answer to the second query to involve lots of asterisks (e.g. "***-**-****" or "***********"), but since none of the choices included...

  • RE: DBCC InputBuffer Permissions

    I was also able to guess the correct answer (I'm not a DBA). Thanks for the question, Steve.

  • RE: Try Catch Throw

    Great question, Justin, thanks!

  • RE: Stored Procedure Creation

    Good question, Robert. I got burned, because I always use BEGIN..END in my procs for readability, but I always put GO after them to end the block. When I read...

  • RE: Using a Window Aggregate in an Aggregate Query

    Thanks for the terrific question, Kathi! The only criticism I have is that your explanation only states why number 3 is wrong and does not discuss the difference between number...

Viewing 15 posts - 16 through 30 (of 121 total)