Forum Replies Created

Viewing 15 posts - 1,171 through 1,185 (of 1,518 total)

  • RE: Getting error when updating stats of a system table

    GilaMonster (5/20/2008)

    Be aware that sysindexes is a compatibility view, is deprecated and will be dropped in future versions. Also,

    Books Online

    In SQL Server 2005, rowmodctr is not fully compatible with...

    __________________________________________________________________________________
    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]

    May 22, 2008 at 10:28 am

    #819242

  • RE: Function of Login Created from Asymmetric Key in External Access Assemblies?

    rbarryyoung (5/21/2008)

    I believe that you have to make the login the Owner (or executor?) of the Assembly

    I did not have to make it owner of the assembly. But perhaps, as...

    __________________________________________________________________________________
    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]

    May 22, 2008 at 7:42 am

    #819129

  • RE: Using SQL CLR to execute web services

    Thomas SNyder (5/20/2008)I have used the following check, not feature rich but better than nothing. also it describes how the -g switch is used depending on you RAM, (very...

    __________________________________________________________________________________
    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]

    May 20, 2008 at 2:30 pm

    #818224

  • RE: Stored Procedure executes much slower than individual query

    GilaMonster (5/20/2008)

    Can you post the execution plans please. You can right-click on the exec plan, save it as a .sqlplan file, zip and attach to the post. (assuming SQL 2005)

    Somewhere...

    __________________________________________________________________________________
    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]

    May 20, 2008 at 1:22 pm

    #818182

  • RE: Stored Procedure executes much slower than individual query

    GilaMonster (5/20/2008)

    That's a big proc... Hmmm...

    Run it in the proc and as a query, and have a look at the execution plan of each, and the results of statistics IO....

    __________________________________________________________________________________
    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]

    May 20, 2008 at 12:29 pm

    #818155

  • RE: Stored Procedure executes much slower than individual query

    We changed the sproc like this at the top (everything else left the same) and the problem disappeared! So it does look like parameter sniffing!

    Why is the performance difference...

    __________________________________________________________________________________
    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]

    May 20, 2008 at 12:10 pm

    #818141

  • RE: Getting error when updating stats of a system table

    Sounds good, I will use the "OBJECTPROPERTY(id,'IsUserTable') = 1" filter in my query.

    Thanks for the recommendations!

    __________________________________________________________________________________
    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]

    May 20, 2008 at 12:07 pm

    #818138

  • RE: Stored Procedure executes much slower than individual query

    Here you go: 🙂

    CREATE PROC [dbo].[ssp_elect_NewImportSummary]

    @ImportIDint

    AS

    SET NOCOUNT ON

    SELECT

    DISTINCT ( CI.ImportID )

    ,CI.NumRecordsInFile AS TotalNumberOfRecordsInADJFile

    ,CI.ImportFile

    , CI.ImportDate

    , CI.PayrollDate

    ,COALESCE ( StatusCount.TotalContractsInBatStatus, 0 ) AS TotalContractsInBatStatus

    ,COALESCE ( StatusCount.TotalContractsInVerStatus, 0 ) AS...

    __________________________________________________________________________________
    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]

    May 20, 2008 at 12:05 pm

    #818136

  • RE: Getting error when updating stats of a system table

    jeff.williams3188 (5/20/2008)

    From BOL on UPDATE STATISTICS:

    UPDATE STATISTICS WITH RESAMPLE updates all the statistics on a table at the current sampling rate. This means that statistics tied to indexes, which are...

    __________________________________________________________________________________
    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]

    May 20, 2008 at 10:38 am

    #818081

  • RE: Linked Server

    Has a fix to this been found?

    I'm having the same issue.

    __________________________________________________________________________________
    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]

    May 20, 2008 at 8:32 am

    #817955

  • RE: Getting error when updating stats of a system table

    GilaMonster (5/19/2008)

    In SQL 2005 the system tables are 'hidden'. You cannot query them or affect them in any way. The SQL parser acts as though they aren't there.

    Thank you for...

    __________________________________________________________________________________
    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]

    May 20, 2008 at 8:02 am

    #817906

  • RE: Using SQL CLR to execute web services

    Jeff Moden (5/19/2008)

    Heh... that's a lot of stuff to remember... especially about how to use heap memory so garbage collection will automatically clear it (failure to do so will make...

    __________________________________________________________________________________
    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]

    May 20, 2008 at 7:54 am

    #817899

  • RE: Getting error when updating stats of a system table

    Wilfred van Dijk (5/17/2008)

    That's a good one! Is seems Microsoft onnly implemented the @resample option :hehe:

    However, it's possible to create a modified sp_updatestats (with the fullscan option). The sourcecode for...

    __________________________________________________________________________________
    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]

    May 17, 2008 at 7:39 am

    #816858

  • RE: Getting error when updating stats of a system table

    Wilfred van Dijk (5/17/2008)

    I would suggest to select only tables from sysobjects where type = 'U' if you want to update statistics by table (why not using sp_updatestats? This operation...

    __________________________________________________________________________________
    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]

    May 17, 2008 at 6:42 am

    #816853

  • RE: Getting error when updating stats of a system table

    I didn't have this problem in SQL 2000.

    __________________________________________________________________________________
    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]

    May 17, 2008 at 5:14 am

    #816849

Viewing 15 posts - 1,171 through 1,185 (of 1,518 total)