Forum Replies Created

Viewing 15 posts - 8,611 through 8,625 (of 19,560 total)

  • RE: Multiple TempDB Files (Data & Log)

    We have assigned multiple data files for tempdb to both of the following configurations:

    1. all on one disk (up to 12 files)

    2. split evenly between two disks (up...

    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 19, 2011 at 10:01 pm

    #1383613

  • RE: Table Access Order

    Thanks for another superb question Paul.

    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 19, 2011 at 9:52 pm

    #1383612

  • RE: SSRS 2008 Report freeze in a browser

    A couple of things to try. First set WorkingSetMaximum in the RSReportServer.config file. Configure SQL server Max memory.

    Here's a link on the WorkingSetMaximum.

    This has been of some help...

    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 19, 2011 at 9:44 pm

    #1383611

  • RE: SSRS: Automatically Selecting Items in one drop down based on the values selcted from another drop down

    NeddyRock (9/19/2011)

    Thanks Jason. I wish that weren't the case, but I apprecaite the confirmation 🙂

    Ned

    Yeah - it would be nice to be able to do something like that sometimes.

    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 19, 2011 at 5:54 pm

    #1383598

  • RE: SubQuery

    Kenneth Wymore (9/19/2011)

    Any idea as to why they would allow this behavior in a join? Seems to me like it would actually introduce more confusion than convenience.

    I think they have...

    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 19, 2011 at 4:50 pm

    #1383579

  • RE: SubQuery

    Trey Staker (9/19/2011)

    Thanks for the question. I got it right. I haven't used this functionality yet so I was guessing a little that this is how it works.

    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

    September 19, 2011 at 4:41 pm

    #1383568

  • RE: SubQuery

    Kenneth Wymore (9/19/2011)

    I, like some others, got the question right for the wrong reason. I focused on the date declaration in the parameters and only caught the renaming of 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

    September 19, 2011 at 4:41 pm

    #1383566

  • RE: SSRS: Automatically Selecting Items in one drop down based on the values selcted from another drop down

    No. You can alter the default values of subsequent dropdowns based on the value of a previous dropdown - but not vise versa.

    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 19, 2011 at 4:31 pm

    #1383557

  • RE: Join across databases in stored proc

    Does the user that connects your datasource in SSRS have adequate permissions to both databases?

    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 19, 2011 at 2:28 pm

    #1383493

  • RE: Capturing Stored Procedures statements with DMVs

    dsbolanos (9/19/2011)

    It was a very nice approach, it seems I'll just keep the SPs execution history withouth parameters for now.

    Thanks for all your valuable help guys.

    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

    September 19, 2011 at 11:13 am

    #1383403

  • RE: Capturing Stored Procedures statements with DMVs

    Lowell (9/19/2011)

    Based on what Jason pointed to, where you can harvest info from the execution plans, this seemed to work for me;

    i ran a proc "sp_find that takes one parameter...it's...

    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 19, 2011 at 10:36 am

    #1383392

  • RE: Capturing Stored Procedures statements with DMVs

    dsbolanos (9/19/2011)

    I'll take a look and see what I can find, and yeah, I was trying to get something like "exec sp_test 'data1',2, etc..." like what you get in traces...

    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 19, 2011 at 9:56 am

    #1383381

  • RE: Capturing Stored Procedures statements with DMVs

    dsbolanos (9/19/2011)

    I'll take a look and see what I can find, and yeah, I was trying to get something like "exec sp_test 'data1',2, etc..." like what you get in traces...

    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 19, 2011 at 9:54 am

    #1383379

  • RE: Capturing Stored Procedures statements with DMVs

    Speaking of code on the net, try Glenn Berry's Dr. DMV scripts.

    http://sqlserverperformance.wordpress.com/tag/dmv-queries/

    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 19, 2011 at 9:43 am

    #1383366

  • RE: Today's Random Word!

    Tom.Thomson (9/19/2011)

    Powercut

    ----------

    At about 9:20 this morning I discovered that the electricity supply was scheduled to be cut of for maintenance/enhancement work from 9:20 to 14:00.

    Destroyed my schedule for today....

    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 19, 2011 at 9:39 am

    #1383363

Viewing 15 posts - 8,611 through 8,625 (of 19,560 total)