Forum Replies Created

Viewing 15 posts - 1,006 through 1,020 (of 1,518 total)

  • RE: Suggestion on Updating Statistics

    Grant Fritchey (7/22/2008)

    Thanks. Great description of automatic statistic maintenance, although it's for SQL Server 2000. Here's the BOL entry for 2005. There are a few differences, but nothing major.

    I guess...

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

    August 1, 2008 at 12:44 pm

    #852129

  • RE: How to get sql server installation folder?

    Jonathan Kehayias (8/1/2008)

    For this particular question, here is the example code.

    DECLARE @InstanceName varchar(100),

    @InstanceLocation varchar(100),

    @InstancePath varchar(100)

    SELECT @InstanceName = convert(varchar, ServerProperty('InstanceName'))

    EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',

    @key='Software\Microsoft\Microsoft SQL Server\Instance Names\SQL',

    @value_name=@InstanceName,

    ...

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

    August 1, 2008 at 12:31 pm

    #852110

  • RE: Running an Update on a Production Table in High volume OLTP environment

    I think enabling Snapshot Isolation Read Committed would solve your problem.

    But there are other implications to enabling this isolation level, so you will have to test carefully before implementing in...

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

    August 1, 2008 at 12:24 pm

    #852096

  • RE: How to get sql server installation folder?

    Jonathan Kehayias (7/23/2008)

    There are a couple of ways to do this. Just using standard TSQL, you can use XP_REGREAD to read the registry key for the instance root key:

    HKLM\Software\Microsoft\Microsoft...

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

    August 1, 2008 at 12:02 pm

    #852078

  • RE: Disk 'layout' question

    Don't forget about your tempdb data files.

    Those need to be separated from the rest: separate disk array, device etc. (I'm not clear on this terminology).

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

    August 1, 2008 at 11:12 am

    #852052

  • RE: Regarding Table Updates

    vasaharshit (8/1/2008)

    Thanks a lot!!!

    Just one confirmation needed i will have to create this table before right UpdateDBStatsStatus?

    and i will have to run it once in a day,right?

    so...

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

    August 1, 2008 at 11:08 am

    #852051

  • RE: Regarding Table Updates

    PaulB (8/1/2008)

    You have to populate a table using the output of that query, just run the process once a day and you will end up with one row per object...

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

    August 1, 2008 at 10:47 am

    #852034

  • RE: Do concurrency enhancements for tempdb still apply in 2005?

    The datafiles piece, yes.

    But don't rely on that link for SQL 2005, it is outdated. For example, implementing trace flag -T1118 is not applicable.

    Check out these links instead:

    Configure SQL 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]

    August 1, 2008 at 10:36 am

    #852026

  • RE: Regarding Table Updates

    vasaharshit (8/1/2008)

    Thanks a lot Mr or Mrs. 500 !!!

    i got some result but the probleme is i am not able to analyze it.

    where is the difficulty?

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

    August 1, 2008 at 10:31 am

    #852020

  • RE: Regarding Table Updates

    vasaharshit (8/1/2008)

    Hi All,

    I have near about 1300 tables i just want to check which tables are updated or have new rows added ....

    ...

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

    August 1, 2008 at 10:08 am

    #852007

  • RE: Query hangs when inside a transaction, completes fine when not in a transaction

    Marios Philippopoulos (8/1/2008)

    i6004835 (8/1/2008)

    Are you running another transaction or query during the execution of the slow transaction? I mean is it the only query/transaction executed on the server without any...

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

    August 1, 2008 at 5:31 am

    #851776

  • RE: Query hangs when inside a transaction, completes fine when not in a transaction

    i6004835 (8/1/2008)

    Are you running another transaction or query during the execution of the slow transaction? I mean is it the only query/transaction executed on the server without any other query/transaction...

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

    August 1, 2008 at 5:17 am

    #851764

  • RE: Query hangs when inside a transaction, completes fine when not in a transaction

    i6004835 (8/1/2008)

    Are you running another transaction or query during the execution of the slow transaction? I mean is it the only query/transaction executed on the server without any other query/transaction...

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

    August 1, 2008 at 5:02 am

    #851756

  • RE: Query hangs when inside a transaction, completes fine when not in a transaction

    Carl Federl (7/31/2008)

    In sysprocesses I see lastwaittype: PAGELATCH_SH and waitresource: 13:1:6396860.

    A bit before the query completes execution I see lastwaittype: PAGEIOLATCH_SH and waitresource: 2:1:274.

    I know the first number is 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]

    July 31, 2008 at 8:15 pm

    #851627

  • RE: Query hangs when inside a transaction, completes fine when not in a transaction

    OK, here is the latest info. For the longest time, the lastwaittype is PAGELATCH_SH and waitresource is 13:1:6275751.

    I have been able to find the table and index this resource corresponds...

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

    July 31, 2008 at 6:30 pm

    #851609

Viewing 15 posts - 1,006 through 1,020 (of 1,518 total)