Forum Replies Created

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

  • RE: recovery model for System Databases

    DBA in Unit 7 (3/25/2010)

    so there is no way to restore master to a point in time? only be able to to restore to the last good backup?

    There should be...

    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

    March 25, 2010 at 10:26 am

    #1139792

  • RE: T-SQL Oddities

    John McC (3/25/2010)

    At least in 2k8 we have Intellisense otherwise it might be a tad difficult remembering which symbolic (or should that be shambolic) table is which 😉

    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

    March 25, 2010 at 10:25 am

    #1139790

  • RE: Are the posted questions getting worse?

    GilaMonster (3/25/2010)

    Lynn Pettis (3/25/2010)

    Is it me or is she always such a negative nellie?

    It's not you.

    Remember the discussions on women in IT and how she reacts in those. There's a...

    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

    March 25, 2010 at 10:24 am

    #1139787

  • RE: Statistics IO - Physical Reads in Prod vs Dev

    You're welcome.

    If you are still interested in help, please post the new execution plans. There might be something more that we can see to help out.

    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

    March 25, 2010 at 9:23 am

    #1139730

  • RE: Today's Random Word!

    Charles Barkley (round mound of rebound)

    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

    March 25, 2010 at 9:20 am

    #1139729

  • RE: Why create statistics on every column of every table in a database.

    You're welcome.

    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

    March 25, 2010 at 9:19 am

    #1139728

  • RE: Creating Indices on Temp Tables from Stored Procedures

    I agree with Bob. This is a method that can be used where appropriate. It is not appropriate in all situations and can be worse in some. ...

    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

    March 25, 2010 at 9:18 am

    #1139727

  • RE: public role for a whole DB

    There is not a single status to check. You need to perform a security audit of your system and determine what roles and users have what access.

    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

    March 25, 2010 at 9:15 am

    #1139723

  • RE: IO of backup

    Baseline your system before you do a backup. Compare the baseline to the counters taken during the backup. Backup will be most of the difference between the two.

    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

    March 25, 2010 at 9:14 am

    #1139722

  • RE: IO of backup

    Statistics IO will tell you the read information within the database. When performing a backup (particularly to disk) you would also need to capture the write information.

    If you want...

    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

    March 24, 2010 at 10:27 pm

    #1139392

  • RE: missing_index_details inequality columns

    repent_kog_is_near (3/24/2010)

    >>If code is hitting your database from the application and is not in proc form, then profiler would be the better bet.

    Can you filter in profiler by tablename (...

    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

    March 24, 2010 at 10:09 pm

    #1139386

  • RE: public role for a whole DB

    Jeffrey Williams-493691 (3/24/2010)

    Sorry, but that is just too risky a situation for me...

    Leaving the database wide open is too risky for me as well. I think you will find...

    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

    March 24, 2010 at 10:05 pm

    #1139385

  • RE: Creating Indices on Temp Tables from Stored Procedures

    The Dixie Flatline (3/24/2010)

    Instead, why don't you look into partitioning your main table (and it's indexes too!) ? That bought us some excellent performance benefits.

    I like 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

    March 24, 2010 at 9:06 pm

    #1139371

  • RE: What will be output?

    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

    March 24, 2010 at 9:03 pm

    #1139369

  • RE: missing_index_details inequality columns

    Profiler is one method. You could also search your stored procs to find any instances of that table.

    If code is hitting your database from the application and is not...

    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

    March 24, 2010 at 8:57 pm

    #1139366

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