Forum Replies Created

Viewing 15 posts - 15,091 through 15,105 (of 19,560 total)

  • RE: SQL SERVER

    default password of sa is an empty string.

    You are required to change it during installation to a password of your liking.

    When you change the password of sa in SSMS, it...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: processor/licensing

    You should check with your server guy to determine number of sockets being used.

    Personally, I prefer the per CPU licensing model.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Creating Indices on Temp Tables from Stored Procedures

    Garadin (4/7/2010)


    CirquedeSQLeil (4/7/2010)


    TheSQLGuru (4/7/2010)


    Paul White NZ (4/7/2010)


    TheSQLGuru (4/7/2010)


    BAH!! I don't need no stinkin' TESTS!! I KNOW my code will run faster than my client's did!!! :w00t: :-D...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Date Manipulation with DATEADD/DATEDIFF

    Garadin (4/7/2010)


    Thanks.

    Nothing like actually having an article published that lets you see all the things that you forgot to add to it! :hehe:

    I thought of the same thing with...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Report Server Web Service

    I think that the explanation is a bit lacking in clarity.

    There are actually two endpoints available. It depends on which endpoint you need to use as to which you...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: MCJ - The Missing Link

    FWIW, I am seeing more people comment about their support for a middle ground certification. There is a little chatter on twitter too.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Creating Indices on Temp Tables from Stored Procedures

    TheSQLGuru (4/7/2010)


    Paul White NZ (4/7/2010)


    TheSQLGuru (4/7/2010)


    BAH!! I don't need no stinkin' TESTS!! I KNOW my code will run faster than my client's did!!! :w00t: 😀 😎

    Superb.

    And before...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (4/7/2010)


    It raises like a V12 Ferrari when you press the accelerator.

    That's the kind of voice raising we like.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/7/2010)


    Okay, I have read ahead and will heed the warnings. I'll stop.

    Thanks. It is the only way to get certain people to stop.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    WayneS (4/7/2010)


    Jeffrey Williams-493691 (4/7/2010)


    Grant Fritchey (4/7/2010)


    You kids take this outside or I'm going to get my belt!

    If you don't stop right now - I'm going to turn this car around...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    Paul White NZ (4/7/2010)


    WayneS (4/7/2010)


    I see Jason'sPaul's QOD is still running 47%, w/ 1250 attempts.

    *cough*

    Whose QotD? 😛 :rolleyes:

    Awesome.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: ANSI_NULLS

    Paul White NZ (4/7/2010)


    CirquedeSQLeil (4/7/2010)


    Paul,

    I hope you don't mind. I took your great script and made a modification to it....There are some display issues with < > type symbols...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    WayneS (4/7/2010)


    CirquedeSQLeil (4/7/2010)


    I find myself amazed that there are three that carried through with that threat and it worked.

    That is awesome. If I ever need to hold true to...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    lmu92 (4/7/2010)


    I just have a headline for SSC jumping into my mind:

    Having trouble with your database or your kids?

    Have a look at SSC! We'll tune both! 😀 :hehe: 😀

    Superb

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    lmu92 (4/7/2010)


    CirquedeSQLeil (4/7/2010)


    ...

    Funny - exercising restraint to not use a 1-liner on that.

    Brave man. Do you want us to consider it some kind of self-flagellation? 😀

    That works

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 15 posts - 15,091 through 15,105 (of 19,560 total)