Forum Replies Created

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

  • RE: Are You a Ten?

    Probably stating the obvious here but not even Google is a 10.

  • RE: More, More, More

    Whatever you do, don't get rid of the QOD! And at the very least please ensure that a good proportion of those questions are ambiguous or ill thought through, as...

  • RE: String length?

    Surely the only sensible output from running this is: "Query was cancelled by user.";-)

  • RE: Answers to Your QOD

    george sibbald (3/19/2010)


    I don't think I am giving away the farm if I say that if the answer boxes are square there is more than one correct answer, a radio...

  • RE: The DBA Boat

    Hey... If I'd just disclosed the names of my kids on a blog, my wife would have to change all her passwords! Dangerous things, names.

  • RE: Just SQL Auth

    BackupGuy (11/20/2009)


    The responses so far are, typically, M$-centric...as if nothing exists outside of the AD domain where the SQL server resides that would ever require access to data in the...

  • RE: Just SQL Auth

    majorbloodnock (11/20/2009)


    Japie Botma (11/20/2009)


    Recommended or not. This is what the auditors want in a corporate world. To prevent network administrator access.

    I agree, and I must admit there are...

  • RE: Just SQL Auth

    Ok I'm confusing myself here between authentication and authorisation... which I always do... What I mean is that I'd like to see sql server require both windows and sql authorisation....

  • RE: Just SQL Auth

    Don't think I'd like just sql Authentication... If I were to have a third option I'd go with requiring both sql and windows authentication (not sql or windows)...

  • RE: Cast as datetime question

    chrisn-585491 (11/18/2009)


    This doesn't work in SQL Server 2005 TSQL , end up with an a Msg 1305...

    :unsure:

    worked for me in 2005

  • RE: Cast as datetime question

    Nice question... demonstrates how the subtraction operation implicitly casts the result as an integer data type thus avoiding the error message that '435365' on its own would have caused.

  • RE: one character of data

    surely nchar(1)?

  • RE: The T-SQL Paradigm

    QUOTATION: I speak Spanish to God, Italian to women, French to men and German to my horse.

    ATTRIBUTION: King Charles V (1500–1558), King of Spain and Holy Roman Emperor.

    Looks like...

  • RE: TSQL

    Why? That's the puzzle. It looks as though the optimizer is not really building an intermediate resultset of numeric values, but rather is applying the various conditions...

  • RE: TSQL

    In 2005 if I'm comparing those instances where it works and those where it doesn't... I'd be interested to see how/whether the execution plans differ.

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