Forum Replies Created

Viewing 15 posts - 4,216 through 4,230 (of 7,484 total)

  • RE: Using Sparse Columns with SELECT ... INTO

    Good question.

    I find it rather surprising that 19% of people to date think the column name doesn't carry over, and 17% think the data type doesn't carry over - I...

    September 2, 2012 at 11:00 am

    #1532752

  • RE: ISDATE

    Koen Verbeeck (8/28/2012)

    Hugo Kornelis (8/28/2012)

    I've raised a documentation bug for this issue: https://connect.microsoft.com/SQLServer/feedback/details/759944/documentation-of-isdate-function-incorrect

    Voted +1.

    (and indicated I could reproduce it)

    Very interesting question, thanks.

    +1

    September 2, 2012 at 10:39 am

    #1532748

  • RE: Working on stored procedures

    Nice straightforward question.

    More like this one needed, judging by the number who got it wrong.

    September 2, 2012 at 10:25 am

    #1532747

  • RE: Catalog Views

    Good question and answer, but I have a minor niggle about the explanation. Catalog views include sys.database_recovery_status, which includes information (last_log_backup_lsn) about backups, so the statement in the explanation...

    September 2, 2012 at 10:01 am

    #1532740

  • RE: Inserts

    SQL Kiwi (8/23/2012)

    I also knew the fact the question was looking to test, but fell foul of the start at zero like so many others.

    I personally think the question would...

    September 2, 2012 at 9:50 am

    #1532739

  • RE: Check status of SPN?

    chris.puncher (8/23/2012)

    If you are doing this on Windows Server 2003 then setspn isn't installed by default. You need to download Windows Server 2003 Support Tools.

    You mean there are people for...

    September 2, 2012 at 9:09 am

    #1532733

  • RE: concatenation

    Hugo Kornelis (8/21/2012)

    A good question. I'll admit that I am surprised at the high number of incorrect answers; I would have expected 70 to 80 percent to get this right.

    I'm...

    September 2, 2012 at 9:00 am

    #1532732

  • RE: Basic of T-SQL

    Revenant (8/21/2012)

    GPO (8/18/2012)

    Got it right because I guessed what the op was getting at but I think the question should have been proof-read and tidied up before publication.

    +1

    +1. Anything that...

    September 2, 2012 at 8:36 am

    #1532730

  • RE: Table Variable

    Hugo Kornelis (8/16/2012)

    sestell1 (8/16/2012)

    A good question. This is a drawback to using table variables for temporary storage that you need to remember to work around.

    Actually, this is not a...

    September 1, 2012 at 6:51 pm

    #1532714

  • RE: NULL

    SQL Kiwi (8/21/2012)

    It drives me nuts to see column definitions without a NULL or NOT NULL constraint.

    What drives me nuts is that SQL doesn't default to NOT NULL when...

    September 1, 2012 at 6:30 pm

    #1532713

  • RE: Avoiding the Deep model (Key, value)

    I have to agree with most of what's been said here. As a general rule, EAV is much more costly in development time (especially for enhancements), storage, and performance...

    August 30, 2012 at 2:47 pm

    #1532134

  • RE: Are the posted questions getting worse?

    Off to Sri Lanka tomorrow, to attend eldest son's wedding. The evil child has insisted I be kilted for the event, and I can no longer get into my...

    August 14, 2012 at 3:56 pm

    #1525828

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/14/2012)

    Brandie Tarvin (8/14/2012)

    I get ideas from the weirdest places. I keep threatening to write stories about you people and never do. Well, this debate has inspired me to...

    August 14, 2012 at 8:43 am

    #1525568

  • RE: BIT Conversions

    Hugo Kornelis (8/14/2012)

    WayneS (8/14/2012)

    One of the things that I'm trying to learn is to write better QotD questions. It looks like most that have responded here about missing it have...

    August 14, 2012 at 8:40 am

    #1525563

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/13/2012)

    Lynn Pettis (8/13/2012)

    Jeff Moden (8/13/2012)

    I consider CustomerID's and EmployeeID's that are generated simply by the likes of an IDENTITY column, to be a surrogate key even when exposed...

    August 14, 2012 at 7:35 am

    #1525509

Viewing 15 posts - 4,216 through 4,230 (of 7,484 total)