SQL Server Blocking from INDEX REORGANIZE and UPDATE STATISTICS (MSSQLTips 01/17/2019)

[tag] [View MSSQLTips newsletter online]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [Easily find & fix performance issues with SQL Diagnostic Manager]( [Why is INDEX REORGANIZE and UPDATE STATISTICS causing SQL Server blocking?]( In this tip we will look at a situation where an index reorg and an update statistics process were blocking other processes and why this occurred. ... [SQL Server Database Mirroring Status Check and Manual Failover T-SQL Scripts]( In this tip we have a script that can be used to check the status of database mirroring as well as generate the code need for a failover of the databases.... [Data Modeling Scenarios and Best Practices]( In this educational webcast, we will dive into scripts, tips and tricks to assist you with performance tuning your SQL Server databases. Knowing how to find and resolve problems is key to improving performance, so join us to learn how to optimize you... [Windows Server Cluster Quorum - Know Your Options]( Understand the options for configuring the cluster Quorum to meet your specific needs. Learn the benefits and key takeaways for providing high availability for SQL Server in a public cloud (AWS, Azure, Google) environment.... [SQL Server 2017 Reporting Services Tutorial]( SQL Server Reporting Services or SSRS has been the go to reporting solution for SQL Server for almost a decade now. In many organizations, the ease of development, the web front end, and the security integration with Active Directory allowed SSRS to ... [Steps to Rename a SQL Server Database]( In this tip we look at what steps should be taken to rename both the database as well as logical and physical files names for a SQL Server database.... [Avoid ORDER BY in SQL Server views]( For as long as I have been working with SQL Server, I have watched people add ORDER BY to views for various reasons - most commonly, they are referencing the view in multiple queries, and want to avoid having to repeat an ORDER BY clause in each of those ... [Getting Started with the DAX queries for SQL Server Analysis Services]( I would like to learn the DAX query language for SQL Server Analysis Services Tabular Data, is there a simple tutorial to get started?... [Twitter]( [Facebook]( [LinkedIn]( [Google+]( You are receiving this as a subscriber of MSSQLTips.com. If you wish to discontinue receiving email, please send us an email to [unsubscribe](mailto:unsubscribe@mssqltips.com?subject=UNSUBSCRIBE). Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}