Forum Replies Created

Viewing 15 posts - 11,986 through 12,000 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (10/4/2010)

    Craig Farrell (10/4/2010)

    Alvin Ramard (10/4/2010)

    GilaMonster (10/4/2010)

    I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping 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

    October 4, 2010 at 6:35 pm

    #1231391

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (10/4/2010)

    Alvin Ramard (10/4/2010)

    GilaMonster (10/4/2010)

    Craig Farrell (10/4/2010)

    Alvin Ramard (10/4/2010)

    GilaMonster (10/4/2010)

    I'm not sure I got the order of operation there correct. Do you check that it's the correct DB 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

    October 4, 2010 at 3:54 pm

    #1231349

  • RE: Are the posted questions getting worse?

    Chad Crawford (10/4/2010)

    Has anyone ever picked up the DVD from PASS Summit? Does it have all 150+ sessions recorded, or is it just one DVD with select sessions...

    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

    October 4, 2010 at 3:41 pm

    #1231337

  • RE: Are the posted questions getting worse?

    GilaMonster (10/4/2010)

    I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?

    Definitely after.

    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

    October 4, 2010 at 3:38 pm

    #1231331

  • RE: How to delete database on production server

    Why drop the database?

    You could also run

    Drop database [MydatabaseNameGoesHere]

    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

    October 4, 2010 at 3:36 pm

    #1231329

  • RE: Drive Space Monitoring Gets An Update

    Thanks for the article.

    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

    October 4, 2010 at 12:36 pm

    #1231193

  • RE: DATALENGTH

    Thanks for the 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

    October 4, 2010 at 12:34 pm

    #1231190

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (10/4/2010)

    Have saw, will travel. See you in 2 hours, Alvin.

    Is this the making of SAW CXLIV?

    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

    October 4, 2010 at 10:20 am

    #1231115

  • RE: Today's Random Word!

    Chris Morris-439714 (10/4/2010)

    John Rowan (10/4/2010)

    Org.....uh, nevermind.

    Oh John!

    Oh boy

    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

    October 4, 2010 at 10:18 am

    #1231113

  • RE: Today's Random Word!

    spasm

    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

    October 4, 2010 at 10:07 am

    #1231105

  • RE: Race to post 1,000,000

    Ray K (10/4/2010)

    Steve Jones - Editor (10/4/2010)

    I thought the question was "what is your favorite color?" 😀

    Blue! No, yellow!!! AAAAAAAAAAAHHHHHHHHHHHHHHHHhhhhhhh . . . !!!

    Thank ye, I may...

    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

    October 4, 2010 at 9:13 am

    #1231059

  • RE: Today's Random Word!

    yawn

    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

    October 4, 2010 at 9:11 am

    #1231057

  • RE: Are the posted questions getting worse?

    Jeff Moden (10/3/2010)

    CirquedeSQLeil (10/2/2010)

    Brandie Tarvin (10/2/2010)

    CirquedeSQLeil (10/2/2010)

    Grant Fritchey (10/2/2010)

    Hey guys, thanks for dumping a load of... something into my in box. What the heck were you guys smoking in here...

    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

    October 3, 2010 at 12:43 pm

    #1230789

  • RE: Large Update Not Working

    I agree with Lynn, seeing the sample data and DDL for the tables involved will help here.

    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

    October 3, 2010 at 12:42 pm

    #1230788

  • RE: Different results when query table by different columns

    Have you checked for spaces in the names?

    Have you tried to run your query with a like operator rather than an equality operator?

    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

    October 3, 2010 at 10:43 am

    #1230776

Viewing 15 posts - 11,986 through 12,000 (of 19,560 total)