Forum Replies Created

Viewing 15 posts - 691 through 705 (of 1,518 total)

  • RE: SQL Server Profiler: Help needed monitoring one specific store procedure

    t berry (2/26/2009)

    Yes, in the filter you can more than one item. Matches are made using LIKE so multiple sprocs can be used.

    Interesting, I haven't tried that.

    What would be...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 26, 2009 at 12:10 pm

    #950758

  • RE: SQL Server Profiler: Help needed monitoring one specific store procedure

    Or filter by ObjectID:

    use db_name;

    select object_id('sprocName');

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 18, 2009 at 2:25 pm

    #946338

  • RE: SSRS 2008 cumulative line chart shows January results as one line across the whole year, can the line stop at February?

    One clue that might help:

    I just opened my report in BIDS 2008 and the chart looks different in the layout tab. Moreover, I have been able to reproduce the report-server...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 11, 2009 at 2:16 pm

    #942489

  • RE: SSRS 2008 cumulative line chart shows January results as one line across the whole year, can the line stop at February?

    lisa.hamblin (1/28/2009)

    I would like to know if a cumulative line chart can stop the line for the series part way across the chart if there are no later results. ...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 11, 2009 at 2:04 pm

    #942484

  • RE: Performance Problem

    peace2007 (2/8/2009)

    I was going to move tempdb when IT manager questioned me about the large size of tempdb!

    our tempdb file is 12GB, and he says it's so strange...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 8, 2009 at 5:20 pm

    #940233

  • RE: Performance Problem

    peace2007 (2/7/2009)

    Thanks a lot Marios 🙂

    IS there any risk in configuring tempdb while there are so many concurrent transactions on databases? Or, I shall do that when no one is...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 7, 2009 at 8:06 am

    #939969

  • RE: Performance Problem

    Here are a couple of samples for configuring tempdb files:

    To modify a file - move it, change its size etc.:

    ALTER DATABASE tempdb

    MODIFY FILE (NAME = tempdev

    ,FILENAME = 'd:\someFolder\tempdb.mdf'

    ,SIZE = 11000...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 7, 2009 at 4:04 am

    #939938

  • RE: "DBCC CHECKDB ... WITH DATA_PURITY" - Is it needed in SQL-2005-to-SQL-2008 upgrades?

    Thanks both for the input.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 6, 2009 at 1:48 pm

    #939778

  • RE: "Scale-out deployment" error while migrating Reporting Services from SQL 2005 to SQL 2008

    Gift Peddie (2/6/2009)

    I am glad I could help but I cannot understand how bugs are converted to depreciated features. I find it troubling that Microsoft is converting known issues...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 6, 2009 at 12:19 pm

    #939727

  • RE: "Scale-out deployment" error while migrating Reporting Services from SQL 2005 to SQL 2008

    Gift Peddie (2/6/2009)

    Goodluck with posting bugs because you may find your answer in the link below and most of what Microsoft says are depreciated are bugs I gave to the...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 6, 2009 at 12:10 pm

    #939724

  • RE: "Scale-out deployment" error while migrating Reporting Services from SQL 2005 to SQL 2008

    Gift Peddie (2/6/2009)

    SQL Server Reporting Services dropping the DataSource permission is also a known issue you could open your RDL files in the designer and check the connection property it...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 6, 2009 at 11:56 am

    #939717

  • RE: "Scale-out deployment" error while migrating Reporting Services from SQL 2005 to SQL 2008

    Gift Peddie (2/6/2009)

    It is not related to that the answer is in the support article I posted some of the reasons I submitted many bugs to Microsoft.

    Here is what is...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 6, 2009 at 11:32 am

    #939697

  • RE: "Scale-out deployment" error while migrating Reporting Services from SQL 2005 to SQL 2008

    Marios Philippopoulos (2/6/2009)

    I should point out that I am migrating from SQL-2005 Enterprise Edition to SQL-2008 Standard Edition.

    In the Reporting Services Configuration Manager for SQL 2008 I have removed the...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 6, 2009 at 11:05 am

    #939686

  • RE: "Scale-out deployment" error while migrating Reporting Services from SQL 2005 to SQL 2008

    Gift Peddie (2/6/2009)

    Your error is specific to 2008 migration which gives the scale out error based on how the migration was performed. There is an edit in the page...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 6, 2009 at 9:59 am

    #939653

  • RE: "Scale-out deployment" error while migrating Reporting Services from SQL 2005 to SQL 2008

    Dan English (2/6/2009)

    From the documentation on Configuring a Report Server Scale-Out Deployment:

    "The Reporting Services edition must be Enterprise, Developer, or Evaluation. Standard edition does not support a scale-out deployment. You...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 6, 2009 at 9:56 am

    #939651

Viewing 15 posts - 691 through 705 (of 1,518 total)