×

SQL Server

Default database for SQL Server login

October 24, 2023

Why do SQL Server Logins have a default database? Kenneth Fisher and Aaron Bertrand explain this here and here. Here is a sample script to identify logins whose default database no longer exists on the server. Once you identify, you can assign another database as default to avoid the issues explained in the abovementioned two […]

CPU Affinity Mask & TF8002

January 13, 2023

Setting CPU affinity in SQL Server is not a task you do every day. Rarely are there use cases when you need to do that. I had a recent requirement to do it. We plan to replace a physical server with half of its current CPU. Primarily due to faster CPU and workload moved off of […]

SQL 2022 Links

May 24, 2022

Introducing SQL Server 2022 Get SQL Server 2022 What’s new in SQL Server 2022 (16.x) Preview Bob Ward’s presentation deck about SQL Server 2022 SQL Server 2022 demo Introducing the Microsoft Intelligent Data Platform by Rohan Kumar Announcing SQL Server 2022 public preview: Azure-enabled with continued performance and security innovation by Peter Calin SQL Server […]

Replace Trace Flag with ‘USE HINT’

January 23, 2021

Introduced in SQL Server 2016 (13.x) SP1 and Azure SQL Database is the USE HINT option. At the time of writing this article, there are 23 of those. You can see an up to date list by running Dynamic Management View sys.dm_exec_valid_use_hints. With the introduction of this feature, we can replace some of the trace […]

How to Persist Information from Lightweight Query Profiling?

September 14, 2020

Accessing runtime information of a query execution plan is vital to get a precise understanding of resource usage, execution patterns to resolve performance issues. Runtime statistics is beneficial while debugging query performance issues, such as long-running queries, and queries that run indefinitely and never finishes. Historically query completion was a prerequisite for the availability of […]



profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook