SQL 2016 – It Just Runs Faster: Spatial Index Builds Faster
Moved from: bobsql.com Index creation and tessellation are often intensive, spatial activities. Along with the native and TVP, spatial enhancements additional work to optimize index creation and tessellation was completed. …
SQL 2016 – It Just Runs Faster: TVPs with Spatial Column(s)
Moved from: bobsql.com Table Valued Parameters (TVPs) containing spatial columns can be used as input parameter(s) to stored procedures. SQL Server 2016 improves the scalability, using native spatial validation(s), increasing performa …
SQL 2016 – It Just Runs Faster: Native Spatial Implementation(s)
Moved from: bobsql.com Spatial data is among, if not the fastest, growing storage types for the SQL Server database. It is common place for customers to have 3,000,000 or more rows in a database. Customers are t …
SQL 2016 – It Just Runs Faster: DBCC Extended Checks
Moved from: bobsql.com Last week’s post (SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better) talked about several improvements to DBCC CHECKDB to make it run faster. In today’s post, we will talk about additional improvement …
SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better
Moved from: bobsql.com Many of you have experienced (MULTI_OBJECT_SCANNER* based) waits while running DBCC CHECKS*(checkdb, checktable, …) Internally DBCC CHECK* uses a page scanning coordinator design (MultiObjectScanner.) …
How It Works: SQL Server 2016 SSE/AVX Support
Moved from: bobsql.com My recent posts https://blogs.msdn.microsoft.com/bobsql/2016/06/03/sql-2016-it-just-runs-faster-column-store-uses-vector-instructions-sseavx/ https://blogs.msdn.microsoft.com/bobsql/2016/06/03/sql-2016-it-just-runs-faster- …
How It Works: How SQL Server Determines Logical and Physical Processors
Moved from: bobsql.com SQL Server, as outlined in the following post (https://blogs.msdn.microsoft.com/psssql/2016/03/30/sql-2016-it-just-runs-faster-automatic-soft-numa) adjusts to various processor configurations. I have received questio …
Unresolved Deadlock vs Scheduler Deadlock
Moved from: bobsql.com These are distinct errors but I have found that many people blend them together. It really takes an entire chapter to explain these conditions so I am going try to do it in a page or two? Unresolved Deadlock A …
Does SQL Server 2016 Require Trace Flag -T8048?
Moved from: bobsql.com Various changes from automatic soft NUMA to CMemThread partitioning have muddied the water around the trace flag –T8048 messaging. Prior to SQL Server 2016 the trace flag –T8048 is used to upgrade (only) …
The path forward for SQL Server analytics
Today, we are announcing changes to SQL Server analytics which includes:Customer feedbackRetirement of SQL Server 2019 Big Data ClustersRetirement of PolyBase scale-out groupsPath forwardCustomer feedbackWe continue to see increased migration to the cl …
How it Works: XEL Health Session and Shutdown
Moved from: bobsql.com There are a variety of posts talking about the black box recorder (XEL Health Session) explaining what the recorder is and does: https://blogs.msdn.microsoft.com/psssql/2012/03/08/sql-server-2012-true-black-box-record …
DBCC Trace Flags 2562 and 2549
Moved from: bobsql.com Erin Stellato and Jonathan Kehayias from sqlskills reached out asking for clarification of trace flags 2562 and 2549 behavior. Trace flags 2562 and 2549 are documented in knowledgebase article: https://support.m …
How It Works: Reader / Writer Synchronization
Moved from: bobsql.com This post is not about a specific SQL Server object but instead outlines a technique used in various locations to reduce contention while still providing thread synchronization. There are hundreds of locations throug …
How It Works: Session/SPID (–2) for DTC Transactions
Moved from: bobsql.com I have written on this subject before but it seems to come up from time to time, as it did again this week. The Session (SPID) = –2 is just a place holder used by SQL Server to indicate that the DTC t …
COLD, WARM, HOT … CLEAN, DIRTY, FREE … What Does All This Mean?
Moved from: bobsql.com I was asked about these terms from a blog reader. As I thought about these terms and how to blog about them I became concerned that I might just be as clear as mud, but I will do my best. Each of the terms mea …