Forum Replies Created

Viewing 15 posts - 31 through 45 (of 1,033 total)

  • RE: Data Compression

    Koen Verbeeck (11/13/2013)

    First of all, this question is way too easy. Enterprise has all the features, so you don't even have to think.

    Secondly, developer is the same as enterprise feature-wise,...

    November 13, 2013 at 8:23 am

    #1666101

  • RE: Analytical functions available in SQL 2005

    I sort of did it like Tom

    I knew that LAG and LEAD and PERCENT_RANK were all 2012 features (and some of the reasons we wanted 2012).

    November 11, 2013 at 9:49 am

    #1665526

  • RE: "NOT IN" Operator and Three Valued Logic

    Rune Bivrin (11/1/2013)

    Well, good question, but the correct alternative was a bit misleading. You don't get a zero back, you get an empty result set. That's a different answer.

    QFT, :)...

    November 1, 2013 at 7:30 am

    #1663411

  • RE: Orphaned users

    Dscheypie (10/31/2013)

    No, Ron, I think you are a good DBA, because this is not understandable on first look in my eyes! And if you feel confused I think you are...

    October 31, 2013 at 10:31 am

    #1663178

  • RE: Orphaned users

    ronmoses (10/31/2013)

    Thank you. So if Disney gives Mickey Mouse the ability to fly, every member of The Mickey Mouse Club gains the same ability. Interesting, and entirely confusing. I think...

    October 31, 2013 at 10:24 am

    #1663170

  • RE: Parameter sniffing

    IgorMi (10/17/2013)

    If you use exec sp_recompile 'T'

    you'll get results (compiled values) "Kelle" and "Pelle"

    If you use exec sp_recompile 'GetIt'

    you'll get results (compiled values) "Kelle" and "Urban"

    Which is what I did......

    October 17, 2013 at 1:31 pm

    #1659477

  • RE: What happens to a variable after COMMIT or ROLLBACK

    raulggonzalez (10/7/2013)

    Thanks for the question!

    It might be good also to point that table variables are not affected either by transaction rollbacks.

    As per BOL

    Because table variables have limited scope and...

    October 7, 2013 at 8:00 am

    #1656344

  • RE: CTE

    L' Eomot Inversé (9/25/2013)

    Until CTEs became available, since there was no such thing as a temporary view it was a general rule to write such things using 3 temp tables...

    September 25, 2013 at 7:06 am

    #1653130

  • RE: CTE

    paul s-306273 (9/25/2013)

    ...come on, maybe they were really impreseed, but I doubt they 'gasp in wonder'!

    Mine did... 3 years ago when I showed them how to do some of these...

    September 25, 2013 at 7:01 am

    #1653126

  • RE: CTE

    Carlo Romagnano (9/25/2013)

    Koen Verbeeck (9/25/2013)

    Very interesting question. Never used a CTE with a DELETE statement before.

    +0.5

    Never used a CTE at all.

    This I find amazing... do you not use the Window...

    September 25, 2013 at 6:59 am

    #1653122

  • RE: Variable Declaration

    paulcauchon (9/19/2013)

    Perhaps even less often-- I can't think of a single instance where a code block wrapped in if 1=0 would be a useful design element.

    I've used stuff like that...

    September 20, 2013 at 7:36 am

    #1651923

  • RE: Reserved Words - 1

    Stewart "Arturius" Campbell (9/18/2013)

    Good question, Ron, thanks

    Didn't even have to bother executing the T-SQL, which is, after all, what this is all about...

    Yes... yes it is... I too can claim...

    September 18, 2013 at 9:33 am

    #1651168

  • RE: Declare Variable

    Good... so rather than googling myself to death trying to come up with the correct term.

    I believe it's because of the IF/THEN that we see this.

    SQL Processes both branches of...

    September 16, 2013 at 9:19 am

    #1650495

  • RE: Declare Variable

    Koen Verbeeck (9/15/2013)

    The question itself is great, however the explanation is lacking.

    There's no reference, and the explanation itself is incorrect.

    There's no variable that is "reset".

    The DECLARE is not ignored, it...

    September 16, 2013 at 8:40 am

    #1650477

  • RE: Datefirst

    Koen Verbeeck (9/13/2013)

    Very nice question to close off the week.

    And kudos for mentioning the default language, so there's less whining in the discussion 😀

    Yah I thought that was a nice...

    September 13, 2013 at 10:57 am

    #1650119

Viewing 15 posts - 31 through 45 (of 1,033 total)