Forum Replies Created

Viewing 15 posts - 12,076 through 12,090 (of 19,560 total)

  • RE: List all index held on a SQL 2005 server

    I find that very interesting. Thanks for the explanation Feeg

    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

    September 29, 2010 at 9:09 am

    #1229127

  • RE: Today's Random Word!

    Chiropractor

    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

    September 29, 2010 at 9:06 am

    #1229126

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/29/2010)

    Jack Corbett (9/29/2010)

    So how do you all deal with a "maverick"/"lone ranger" coder? I think you all know what I mean. That person who goes off...

    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

    September 29, 2010 at 9:05 am

    #1229124

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (9/29/2010)

    Jack Corbett (9/29/2010)

    So how do you all deal with a "maverick"/"lone ranger" coder? I think you all know what I mean. That person who...

    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

    September 29, 2010 at 9:01 am

    #1229119

  • RE: List all index held on a SQL 2005 server

    Can you provide the actual error message?

    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

    September 29, 2010 at 4:43 am

    #1228883

  • RE: Raw Materials - Summer on the Lake

    Haha - people need to unplug from time to time.

    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

    September 29, 2010 at 4:41 am

    #1228881

  • RE: Fun with IDENTITY - Part I

    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

    September 29, 2010 at 4:40 am

    #1228878

  • RE: Today's Random Word!

    Flopsum

    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

    September 29, 2010 at 4:34 am

    #1228871

  • RE: Race to post 1,000,000

    Things seem to have slowed down a bit on the forums - or is it just perception?

    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

    September 29, 2010 at 4:27 am

    #1228863

  • RE: Are the posted questions getting worse?

    Jeff Moden (9/29/2010)

    I got to "meet" the nicest person, today. I'm setting up to give a remote presentation and I got to work with Roy Ernest over the phone....

    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

    September 29, 2010 at 4:25 am

    #1228861

  • RE: read only user

    You will need to go proc by proc and deny execute to the users.

    Another option will be to modify the app so that read type connections are the only connections...

    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

    September 28, 2010 at 7:29 pm

    #1228730

  • RE: How to free table space

    Whisper9999 (9/28/2010)

    Did you try DBCC CleanTable out of curiousity?

    He said he did - early on in the thread

    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

    September 28, 2010 at 4:45 pm

    #1228714

  • RE: How to free table space

    I presume that is after you removed the clustered index. Run that query tomorrow prior to removing any indexes.

    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

    September 28, 2010 at 3:37 pm

    #1228686

  • RE: How to free table space

    Quick and Dirty script

    SELECT DB_NAME(database_id) as DatabaseName,

    object_id,

    OBJECT_NAME(OBJECT_ID,database_id) as TableName,

    forwarded_record_count,

    index_type_desc

    FROM sys.dm_db_index_physical_stats (DB_ID(null), OBJECT_ID(null), NULL , NULL, 'DETAILED')

    GO

    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

    September 28, 2010 at 12:46 pm

    #1228612

  • RE: Can Wives Shorten Work Hours?

    WayneS (9/28/2010)

    I think that this says it all for me:

    Most professionals will stay late, pull the all-nighter, really help out when it's needed in a crisis. Just don't ask...

    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

    September 28, 2010 at 12:33 pm

    #1228601

Viewing 15 posts - 12,076 through 12,090 (of 19,560 total)