Opinions, tips, and news orbiting Microsoft
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.) SQL… Continue reading SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better
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… Continue reading How It Works: SQL Server 2016 SSE/AVX Support
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… Continue reading How It Works: How SQL Server Determines Logical and Physical Processors
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… Continue reading Unresolved Deadlock vs Scheduler Deadlock
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) NUMA partit… Continue reading Does SQL Server 2016 Require Trace Flag -T8048?
This blog post was co-authored by Eric Hudson, Senior Product Marketing Manager, Data & AI. This is the second blog of a series focused on SQL Managed Instance, where we will dive into technical topics that will help you successfully mod… Continue reading SQL Managed Instance closing the gap on SQL Server application compatibility – Part 2
Welcome to the February edition of “What’s New in Microsoft Teams”. This month we are bringing more exciting announcements. Read below to learn how you can make your meetings run a little more smoothly and how to make your chats more efficient! But don… Continue reading What’s New in Microsoft Teams | February 2022
We’ve just published a new major version of the CLI for Microsoft 365 with new commands for working with and managing Microsoft 365 and SharePoint Framework projects on any platform.
Manage Microsoft 365 and SharePoint Framework projects… Continue reading CLI for Microsoft 365 v5.0