Forum Replies Created

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

  • Reply To: Query Store: Long-running queries recorded in [sys].[query_store_runtime_stats]

    Thanks, I actually was able to test this, and indeed the times reflect the completion of the query. Mystery solved!

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

    January 17, 2023 at 4:38 pm

    #4138668

  • RE: Column Store vs Row Store Indexes

    In SQL 2016 both clustered and non-clustered columnstore indexes are updateable, so there is no need to disable them prior to updates to the underlying table:

    Columnstore Indexes Versioned Feature Summary

    Thanks...

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

    December 30, 2016 at 4:54 am

    #1920068

  • RE: Stairway to Server Management Objects (SMO) Level 2: Connections and Creating Server Inventories

    Enjoyed the scripts and explanations.

    Nice article, thank 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]

    July 13, 2016 at 1:53 pm

    #1889955

  • RE: Culture Clashes and Arrogance

    Great post. It brings to mind many such situations that I have experienced in the past.

    I think what exacerbates these situations is the "urgency" of the project - a looming...

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

    June 17, 2015 at 4:20 am

    #1805999

  • RE: Turbocharge Your Database Maintenance With Service Broker: Part 2

    A better way of terminating all Service-Broker activity in a given database:

    ALTER DATABASE [dbName] SET NEW_BROKER WITH ROLLBACK IMMEDIATE;

    See:

    http://stackoverflow.com/questions/22392341/alter-database-db-name-set-enable-broker-with-rollback-immediate

    http://stackoverflow.com/questions/6931001/how-to-quickly-shut-down-all-elements-of-microsoft-sql-server-service-broker

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

    January 30, 2015 at 9:22 am

    #1774383

  • RE: Unable to connect to SSRS through Management Studio: "Invalid Class (System.Management)"

    Thank you, I should've thought of that - I'll check.

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

    October 2, 2014 at 3:32 am

    #1749634

  • RE: Turbocharge Your Database Maintenance With Service Broker: Part 2

    Here is a query that will give output to help kill broker-activated tasks:

    SELECT

    'KILL ' + cast (at.spid as varchar)

    , ...

    __________________________________________________________________________________
    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 13, 2014 at 3:10 pm

    #1737831

  • RE: Combining AlwaysOn Groups With Failover Cluster Instances

    david.puckett 38841 (7/25/2014)

    3 node windows 2012 failover cluster

    sql2012 installed on node 1 and node 2

    node 1 and node 2 -> instance 1 using V: on san as clustered storage

    from node...

    __________________________________________________________________________________
    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 29, 2014 at 5:38 am

    #1733148

  • RE: Identifying specific blocker SQL stmt when it is part of an explicit tran

    Thanks, I'll schedule a live session with SQL Sentry to get set up to better be able to capture these.

    __________________________________________________________________________________
    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 3, 2014 at 10:06 am

    #1726888

  • RE: Identifying specific blocker SQL stmt when it is part of an explicit tran

    Perhaps this link has the answer:

    https://www.simple-talk.com/sql/database-administration/investigating-transactions-using-dynamic-management-objects/

    __________________________________________________________________________________
    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 3, 2014 at 5:20 am

    #1726746

  • RE: Identifying specific blocker SQL stmt when it is part of an explicit tran

    Thank you, I know about sp_whoisactive, and I have used it in the past.

    To be honest, I think this is more of a limitation of what info current DMVs (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]

    July 3, 2014 at 3:55 am

    #1726721

  • RE: SQL Server 2014 side-by-side with earlier versions of SQL Server

    Thank you all!

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

    June 3, 2014 at 3:38 am

    #1718463

  • RE: Turbocharge Your Database Maintenance With Service Broker: Part 1

    D-SQL (5/20/2014)

    This is great, I am new to service broker and wanted to get some questions answered. I set this up and was trying to configure it to run 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]

    May 22, 2014 at 5:21 am

    #1715644

  • RE: Negative run_duration values in msdb..sysjobhistory

    No, we saw some of these on April 14, last weekend.

    They coincide with a sql-agent service shutdown and restart.

    Perhaps some jobs were not stopped cleanly during the shutdown and that...

    __________________________________________________________________________________
    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 17, 2014 at 2:44 pm

    #1706930

  • RE: Negative run_duration values in msdb..sysjobhistory

    Eirikur Eiriksson (4/16/2014)

    Quick question, why the (nolock) hints?

    😎

    Hmm, mostly habit I guess... 🙂

    I've removed them, so they do not detract from the "real" 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]

    April 16, 2014 at 3:12 am

    #1706361

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