Forum Replies Created

Viewing 15 posts - 9,946 through 9,960 (of 19,560 total)

  • RE: Whats the benefits to clustering

    Syed Jahanzaib Bin hassan (5/28/2011)


    Active/Active means in term of microsoft multiple instances on mutiple nodes and it follow round robin algorithm for fail over,there is no any Load Balancing 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: The Backup Passwords

    I was thinking that Keepass would be good for this. Even without expiration, one could create subfolders to help organize the passwords along with timeframes that the password is...

    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?

    GilaMonster (5/27/2011)


    Grant Fritchey (5/27/2011)


    Roy Ernest (5/27/2011)


    WayneS (5/27/2011)


    GilaMonster (5/27/2011)


    Precon and spotlight! Could this PASS Summit get any better?

    So, you're aiming for a keynote address now?

    Along with Dr DeWitte

    She'll probably start correcting...

    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?

    Jack Corbett (5/27/2011)


    GilaMonster (5/27/2011)


    Precon and spotlight! Could this PASS Summit get any better?

    Sure, I could go, and attend the precon and the spotlight!

    Side note for those not on Twitter, I...

    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: Write query results in tab delimited file and push the file to ftp

    Dup post - please respond here.

    http://www.sqlservercentral.com/Forums/Topic1116441-338-1.aspx

    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: What is the difference between for and after trigger?

    After trigger runs after an action has occurred on the table in question.

    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: Whats the benefits to clustering

    GSquared (5/27/2011)


    Active/Passive, all you can legally do is use the passive as a failover if the active goes down (intentionally or by failing). That's why you don't have 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: Whats the benefits to clustering

    bopeavy (5/27/2011)


    Elliott

    With that said if node one is active and node two is active and node 2 is the fail over can I use the node 2 for log...

    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: didn't work on my SQL 2008 instance

    dennisparks (5/27/2011)


    yes, sorry I screwed up.

    No biggy

    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: Install and Choosing Root level as Data or Log directory

    I would advise against installing the database files to the root of a disk.

    The service account of SQL server, that is added to local admin?

    As for moving master - that...

    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: didn't work on my SQL 2008 instance

    Are you referring to the QOTD concerning timestamp of failed login?

    You may want to post the question in that thread...

    http://www.sqlservercentral.com/Forums/Topic1115174-32-1.aspx

    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: Error from an SQL job once we migrated to sql 2008 R2

    It sounds like a data set was read into memory to pull across the linked server but during the job run a record was deleted from the table. Have...

    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?

    jcrawf02 (5/27/2011)


    Brandie Tarvin (5/27/2011)


    Jim Murphy (5/27/2011)


    Brandie Tarvin (5/27/2011)


    Back to blogging. I was thinking of using Blosxom on my website. What I'd like to do, though, is integrate LiveJournal with whatever...

    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: random select

    Lowell (5/27/2011)


    there's a trick that you can get randomly ordered records by using the NEWID() function...is that what you are after?

    select top 10

    ColumnList

    From SomeTable

    order By NEWID()

    and this?

    in...

    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?

    Brandie Tarvin (5/27/2011)


    bitbucket-25253 (5/27/2011)


    Wondering why Steve has stopped blogging about his car .. ? ? ?

    Because it's still snowing up at the ranch and the only thing he's able 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

Viewing 15 posts - 9,946 through 9,960 (of 19,560 total)