Forum Replies Created

Viewing 15 posts - 10,336 through 10,350 (of 19,560 total)

  • RE: Online indexing

    Michael Valentine Jones (4/26/2011)


    Brandie Tarvin (4/26/2011)


    Ninja's_RGR'us (4/26/2011)


    Michael Valentine Jones (4/26/2011)


    Brandie Tarvin (4/26/2011)


    Michael,

    You're right. Totally my bad. I was working of a SQL 2000 assumption and by the time I figured...

    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: Please help with this script

    Ninja's_RGR'us (4/26/2011)


    hydbadrose (4/26/2011)


    Can some one please help me. I need to have this script ready by end of this month.

    Dude, COPY, PASTE, RUN my script. That should get 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: Online indexing

    Michael Valentine Jones (4/26/2011)


    Brandie Tarvin (4/26/2011)


    Michael,

    You're right. Totally my bad. I was working of a SQL 2000 assumption and by the time I figured out I was wrong, I was...

    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?

    Ninja's_RGR'us (4/26/2011)


    Way out of my league... 100 GB single index reindex sql 2005 compat level 80.

    http://www.sqlservercentral.com/Forums/Topic1098551-146-1.aspx

    Looks like I am late to that game.

    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: Who's afraid of Gila Monsters?

    Chris Houghton (4/26/2011)


    The Gila Monster seems to be provoked most readily by infractions of intellectual property, Non Disclosure Agreements and the use / proliferation of braindumps.

    Those are solid methods 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?

    LutzM (4/25/2011)


    GilaMonster (4/25/2011)


    SQLRNNR (4/25/2011)


    Any word on when the Email delay will be fixed?

    According to a recent tweet, 'before tomorrow'. They have 37 minutes and counting before tomorrow. Better get...

    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: Save pdf documents in database or on file server?

    LutzM (4/25/2011)


    SQLRNNR (4/25/2011)


    LutzM (4/25/2011)


    I'd vote not to store it in the DB if the following statements are true:

    a) it is possible to re-generate the pdf drawing files based on 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

  • RE: How to monitory memory usage of SQL Server 2000

    [Jim].[dba].[Murphy] (4/25/2011)


    Run perfmon (performance monitor/server monitor) and then feast your eyes on this: http://www.quest.com/backstage/promotion.aspx.

    This poster/PDF by Kevin Kline @KEKline shows the relevant counters and what values they should be at.

    Jim

    Good...

    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: Today's Random Word!

    sing4you (4/25/2011)


    SQLRNNR (4/25/2011)


    Peter Trast (4/25/2011)


    Bacchus

    You missed a few letters between BA and cchus.

    Barrachus (sp)

    borracho

    Huevos Ranchero at El Rancho

    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 (4/25/2011)


    SQLRNNR (4/25/2011)


    GilaMonster (4/25/2011)


    SQLRNNR (4/25/2011)


    Any word on when the Email delay will be fixed?

    According to a recent tweet, 'before tomorrow'. They have 37 minutes and counting before tomorrow. 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

  • RE: Today's Random Word!

    Peter Trast (4/25/2011)


    Bacchus

    You missed a few letters between BA and cchus.

    Barrachus (sp)

    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 (4/25/2011)


    SQLRNNR (4/25/2011)


    Any word on when the Email delay will be fixed?

    According to a recent tweet, 'before tomorrow'. They have 37 minutes and counting before tomorrow. Better get working....

    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?

    Any word on when the Email delay will be fixed? Is the delay related to the EC2 outage?

    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: Save pdf documents in database or on file server?

    LutzM (4/25/2011)


    I'd vote not to store it in the DB if the following statements are true:

    a) it is possible to re-generate the pdf drawing files based on the original data...

    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: Please help with this script

    I would think about removing this

    and DATEPART(yyyy, B.[ExecuteTime]) = DATEPART(yyyy, DATEADD(mm, -3, a.[ExecuteTime]))

    and DATEPART(MM, B.[ExecuteTime]) = DATEPART(MM, DATEADD(mm, -3, a.[ExecuteTime]))),0)/3.0 AS Data_Usage_Growth

    And look to integrate something like this in 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

Viewing 15 posts - 10,336 through 10,350 (of 19,560 total)