Forum Replies Created

Viewing 15 posts - 736 through 750 (of 3,221 total)

  • RE: New and looking to advance my career

    Hopefully you have an adequate computer at home. If so I would suggest purchasing a DEVELOPER EDITION of SQL Server 2008 and become familiar with it. Practice, for...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    January 17, 2012 at 10:29 am

    #1434734

  • RE: Datetime data type

    Amy.G (1/13/2012)

    When running isdate the only records with a '0' are NULL columns. I wouldn't think that's what's messing it up. Well, aparently that was the problem, since when I...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    January 13, 2012 at 4:29 pm

    #1433599

  • RE: Tail Log Backups

    Revenant (1/13/2012)

    SQLRNNR (1/13/2012)

    Cliff Jones (1/13/2012)

    The word 'Always' should have made me think twice, but alas I only thought once.

    That is the key word that made me rethink.

    +1

    +1

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    January 13, 2012 at 10:56 am

    #1433425

  • RE: Tail Log Backups

    Nice question... now as we approach the end of the week will Friday's

    QOD be another tough one ?

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    January 12, 2012 at 8:36 pm

    #1432986

  • RE: Question for the "experts"

    DeanORenO

    you people on this forum are always complaining about the questions that are asked on the forums, either you complain that they are too simple, and that the poster should...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    January 11, 2012 at 4:31 pm

    #1432206

  • RE: Checking database access

    Still a suprisingly low correct

    Correct answers: 35% (100)

    Incorrect answers: 65% (183)

    Total attempts: 283

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    January 11, 2012 at 6:20 am

    #1431737

  • RE: Checking database access

    Another nice easy question ......... Thanks

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    January 10, 2012 at 8:50 pm

    #1431547

  • RE: use merge

    Try this:

    CREATE TABLE #domCategory(CategoryId INT,CD VARCHAR(40))

    INSERT INTO #domCategory

    SELECT 1, NULL UNION ALL

    SELECT 2, 'something'

    CREATE TABLE #Category(CategoryId INT, CD VARCHAR(40))

    INSERT INTO #Category

    SELECT 1,'Yes' UNION ALL

    SELECT 2,'no'

    MERGE #domCategory AS target

    USING #Category AS...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    January 10, 2012 at 3:09 pm

    #1431454

  • RE: Time Zone

    Easy QODs at the beginning of the week ... now what confusing, complex, obscure QOD will Steve post for Friday ?

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    January 9, 2012 at 10:09 pm

    #1430892

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (1/9/2012)

    Here is a connect item that I've raised as a result of the discussion about one of Paul's QotDs. I hope it will gather some votes...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    January 9, 2012 at 11:31 am

    #1430706

  • RE: Classifier Functions

    Steve Jones - SSC Editor (1/8/2012)

    Doh, copied the wrong item.

    corrected.

    Too much snow boarding without sun glasses ?

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    January 8, 2012 at 9:32 pm

    #1430267

  • RE: Classifier Functions

    L' Eomot Inversé (1/8/2012)

    SQL Kiwi (1/7/2012)

    Ok so this is getting silly: that's four QotDs in a row that I have wrong, and I *knew* the answer to this one! ...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    January 8, 2012 at 1:40 pm

    #1430214

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (1/7/2012)

    Dev (1/7/2012)

    @Remi: It’s pretty much insulting and I am ignoring you for a long time. I don’t think I have said anything insulting to anyone, especially you...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    January 7, 2012 at 5:29 pm

    #1430090

  • RE: SSIS Compare 2 Tables for Archiving

    Here is an example from BOL for SQL Server 2008 ... Note that the first portion of the code shows how to perform what I believe what you want to...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    January 6, 2012 at 10:01 am

    #1429734

  • RE: Checkpoint Pages\Sec counter question

    To learn more about CHECKPOINTS I suggest reading Paul Randal's:

    http://sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-(1530)-checkpoint-only-writes-pages-from-committed-transactions.aspx

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    January 6, 2012 at 7:19 am

    #1429615

Viewing 15 posts - 736 through 750 (of 3,221 total)