Forum Replies Created

Viewing 15 posts - 1,216 through 1,230 (of 1,518 total)

  • RE: Instance won't start after moving tempdb file

    Thanks for the reply.

    In my case, the account I am using is sysadmin on the machine and instance, so I cannot fathom it not having adequate permissions locally.

    __________________________________________________________________________________
    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 9, 2008 at 8:47 am

    #813107

  • RE: Multiple threads of a single SPID visible on sysprocesses

    Roy Ernest (5/8/2008)

    When ever I have high I/O operation on queries, I get multiple threads for single SPID (Ofcourse it shows CXPacket as the wait type). One thing I also...

    __________________________________________________________________________________
    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 8, 2008 at 1:48 pm

    #812666

  • RE: Multiple threads of a single SPID visible on sysprocesses

    Thanks all for your responses.

    Steve, yes, there are triggers running.

    Matt, I hate cursors too... 🙂

    Gail, thanks for the info, I've wondering about this for quite some time...

    __________________________________________________________________________________
    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 8, 2008 at 11:30 am

    #812573

  • RE: Performance Problem

    Apologies if it has been mentioned in this thread already, but you will want your tempdb data files isolated on their own physical device (RAID 1 if possible), let them...

    __________________________________________________________________________________
    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 7, 2008 at 5:40 pm

    #812161

  • RE: Get Last Time Cache was purged in order to assess index-usage stats based on DMVs

    colin Leversuch-Roberts (5/5/2008)

    ...The dmv's are great BUT there are a few issues concerning accuracy or data and how and when it updates/maintains itself.

    Is this discussed in the link you sent...

    __________________________________________________________________________________
    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 5, 2008 at 1:11 pm

    #810873

  • RE: Get Last Time Cache was purged in order to assess index-usage stats based on DMVs

    colin Leversuch-Roberts (5/5/2008)

    I've remarked a number of times that whilst the amount of information available on the various ms blogs is fantastic it doesn't always link up team to team,...

    __________________________________________________________________________________
    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 5, 2008 at 12:27 pm

    #810840

  • RE: Get Last Time Cache was purged in order to assess index-usage stats based on DMVs

    colin Leversuch-Roberts (4/29/2008)

    you should not use the raw data in the dmv's for index analysis, always port the data to a table at regular intervals and analyse from there. I...

    __________________________________________________________________________________
    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 5, 2008 at 8:21 am

    #810713

  • RE: Get Last Time Cache was purged in order to assess index-usage stats based on DMVs

    Thank you all for your responses.

    Steve, what I am looking for is a way to tell how long the data stored in DMVs has been kept for so I...

    __________________________________________________________________________________
    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 5, 2008 at 8:08 am

    #810701

  • RE: SSIS or LinkedServer

    If your data transfer can be a strictly scheduled process, then SSIS is preferable. Performance-wise, SSIS has some built-in optimizations (I believe) that make it superior to linked servers.

    If, on...

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

    April 28, 2008 at 11:02 am

    #807947

  • RE: Database compatibility level and performance

    chileu17 (4/25/2008)

    About the upgrade advisor, it's done 😎 and all the implementations it asks for. But there are some warnings like the networks connections that aren't supported anymore by 2k5...

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

    April 25, 2008 at 8:49 pm

    #807476

  • RE: Database compatibility level and performance

    chileu17 (4/25/2008)

    Hi everyone, so there is not a known answer for this topic yet :crying:

    Do you guys think if Microsoft has an answer for this?

    I have to migrate a...

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

    April 25, 2008 at 3:19 pm

    #807422

  • RE: Query getting MAX value of each GROUP of values

    Actually, this works like a charm, thank you!

    Query returns 500,000 records in a fifth of the time of what it did before.

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

    April 25, 2008 at 2:50 pm

    #807411

  • RE: Query getting MAX value of each GROUP of values

    thank you, I should have seen that....:)

    Actually, I tried to simplify a more complex query for the original posting.

    I will try to find out what I missed when I trimmed...

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

    April 25, 2008 at 2:35 pm

    #807405

  • RE: SQL 2005 Upgrade Advisor - do I have to run it locally on server upgraded?

    thanks guys, much appreciated.

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

    April 24, 2008 at 9:43 am

    #806691

  • RE: tempdb size exploding - best profiler events/columns to run in trace?

    colin Leversuch-Roberts (4/23/2008)

    only a billion? I have a plan to post to my blog that actually overflowed an int!

    ...and I thought I had seen it all! :w00t:

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

    April 23, 2008 at 12:44 pm

    #806250

Viewing 15 posts - 1,216 through 1,230 (of 1,518 total)