How it Works: XEL Health Session and ShutdownMoved from: bobsql.com There are a variety of posts talking about the black box recorder (XEL Health […] 24 février 2022 dans Sites Microsoft par MS Tech Community
DBCC Trace Flags 2562 and 2549Moved from: bobsql.com Erin Stellato and Jonathan Kehayias from sqlskills reached out asking for clarification of trace […] 24 février 2022 dans Sites Microsoft par MS Tech Community
How It Works: Reader / Writer SynchronizationMoved from: bobsql.com This post is not about a specific SQL Server object but instead outlines a […] 24 février 2022 dans Sites Microsoft par MS Tech Community
How It Works: Session/SPID (–2) for DTC TransactionsMoved from: bobsql.com I have written on this subject before but it seems to come up from […] 24 février 2022 dans Sites Microsoft par MS Tech Community
COLD, WARM, HOT … CLEAN, DIRTY, FREE … What Does ...Moved from: bobsql.com I was asked about these terms from a blog reader. As I thought about […] 24 février 2022 dans Sites Microsoft par MS Tech Community
How It Works: Sync IOs in nonpreemptive mode longer than ...Moved from: bobsql.com Have you encountered the following in your SQL Server error log? Long […] 24 février 2022 dans Sites Microsoft par MS Tech Community
Create Table – Disk vs In-Memory OptimizedMoved from: bobsql.com I had an interesting e-mail discussion related to the performance of create table. The […] 24 février 2022 dans Sites Microsoft par MS Tech Community
How It Works: How is SQL Server Error 833, 15 ...Moved from: bobsql.com I was approached to revisit the details of how Error Message 833 is detected […] 24 février 2022 dans Sites Microsoft par MS Tech Community
How It Works: BULK INSERT (BCP) TDS TrafficMoved from: bobsql.com Yesterday I had a discussion with a customer and realized that the BCP, TDS […] 24 février 2022 dans Sites Microsoft par MS Tech Community
How It Works (It Just Runs Faster): Non-Volatile Memory SQL ...Moved from: bobsql.com Note: We received feedback that there was some confusion on us calling this functionality […] 24 février 2022 dans Sites Microsoft par MS Tech Community
SQL Server on Linux: ELF and PE Images Just WorkMoved from: bobsql.com Last March I moved from 22 years in SQL Server support to the SQL […] 24 février 2022 dans Sites Microsoft par MS Tech Community
SQL Server on Linux: Debugging ELF and PE Images (dbgbridge)Moved from: bobsql.com In my last post I highlighted the marriage of PE and ELF images within the same […] 24 février 2022 dans Sites Microsoft par MS Tech Community
SQL Server on Linux: An LLDB Debugging TaleMoved from: bobsql.com You are aware of our statements indicating “Microsoft Loves Linux.” Over the last couple […] 24 février 2022 dans Sites Microsoft par MS Tech Community
Meme Week: NOLOCK? NOSQL.When you find yourself using NOLOCK, consider NOSQL instead. NOLOCK has 4 big problems: Your query can see […] 24 février 2022 dans Sites anglophones étiqueté Locking, Blocking, and Isolation Levels par brentozar.com