Forum Replies Created

Viewing 15 posts - 12,841 through 12,855 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/17/2010)

    Alvin Ramard (8/17/2010)

    I would appreciate if any of you who are going to use remote speakers, or are going to broadcast your user group meetings, could post the...

    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

    August 17, 2010 at 2:36 pm

    #1208140

  • RE: Number of TempDb Files

    How big is this database?

    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

    August 17, 2010 at 1:24 pm

    #1208102

  • RE: Number of TempDb Files

    PaulB-TheOneAndOnly (8/17/2010)

    DBAgal (8/17/2010)

    I've done some research and it seems like every person has a different recommendation as to the number of data files the tempdb should have.

    Here's my scenaro -...

    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

    August 17, 2010 at 1:11 pm

    #1208093

  • RE: Number of TempDb Files

    Paul Randal did some benchmarking for this in his blog.

    Though his tests were not specifically for Tempdb, they support what I have read elsewhere. Performance gains tail off 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

    August 17, 2010 at 1:04 pm

    #1208089

  • RE: Are the posted questions getting worse?

    Roy Ernest (8/17/2010)

    CirquedeSQLeil (8/17/2010)

    I think a trip to the Bahamas would be nice. I wonder if I could work it into the budget...

    A trip to curacao is much better....

    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

    August 17, 2010 at 9:58 am

    #1208000

  • RE: Are the posted questions getting worse?

    I think a trip to the Bahamas would be nice. I wonder if I could work it into the budget...

    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

    August 17, 2010 at 9:45 am

    #1207985

  • RE: Round up or down III

    Thanks for the question Hugo. Nice continuation in the series.

    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

    August 17, 2010 at 8:53 am

    #1207936

  • RE: Today's Random Word!

    flatulent

    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

    August 17, 2010 at 8:45 am

    #1207926

  • RE: SQL Server 2000 Database Restore

    Do you know what kind of replication you have setup on the database? You can script the replication from database on the source and then run that script on...

    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

    August 16, 2010 at 11:02 pm

    #1207654

  • RE: is non clustered index can store NULL value?

    Yes a non-clustered index can be on columns that contain null values. An NC Index is not for referential integrity. Sometimes, depending on queries and data usage, an...

    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

    August 16, 2010 at 10:57 pm

    #1207653

  • RE: SSIS export to Excel

    Ok - very odd. It just started working again. I added a data viewer in the flow and all data could be seen in the viewer and now...

    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

    August 16, 2010 at 2:59 pm

    #1207583

  • RE: Turn a Bad Job into a Good Experience

    Andy Warren (8/16/2010)

    Good thoughts, and I've thought the same about bad/weak managers, you get chances to do things that you might not with a stronger and more capable manager. Still,...

    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

    August 16, 2010 at 12:41 pm

    #1207517

  • RE: Calendar Tables II - The Anchor

    Thanks for sharing this with us.

    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

    August 16, 2010 at 10:07 am

    #1207472

  • RE: Today's Random Word!

    deniably plausible

    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

    August 16, 2010 at 9:47 am

    #1207460

  • RE: Duplicate value in Identity column

    Nice 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

    August 16, 2010 at 8:50 am

    #1207412

Viewing 15 posts - 12,841 through 12,855 (of 19,560 total)