Improve Row Count Estimates for Table Variables without Changing Code
You probably have heard that table variables work fine when the table variable only contains a small number of records, but when the table variable contains a large number of records it doesn’t perform all that well. A solution for this problem h …
Microsoft SQL Server Utilities and Tools
Useful free and paid Microsoft SQL Server utilities and tools – a complete list of 275 SQL Server Utilities updated on Jan 24, 2019. Utility types (main purpose), in braces {} current counts: : Backup solutions {6} [BI]: Business Intelligence Solutions …
SQL ConstantCare® Now Tells You Which Indexes to Drop.
Indexes slow down data changes. SQL Server doesn’t have the concept of asynchronous indexes – copies of the data that it could update later when it’s bored. It has to keep every nonclustered index up to date, every single time you cha …
Adding a Database with Polybase External Tables to Always On Availability Group
Introduction I was asked to add a database with PolyBase External Tables to Always On Availability Group. I thought it would be a straightforward approach, but it got tricky when I learned that one of the prerequisites of PolyBase is that a master key …
[Video] Watch Brent Write T-SQL
This morning I worked on a new check for sp_BlitzFirst to find statistics that were updated in the last 15 minutes, possibly causing plan caching issues and parameter sniffing. I streamed it live, and you can watch. In part 1, the first hour, I write t …
How to Move System Databases to a New Physical Directory
I was recently on a very challenging project where we had to do some SQL tasks that were both new to me as a DBA and proved to be challenging. I found myself doing certain tasks over and over. When this happens, I usually find myself automating, creati …
Learning New Skills
The post Learning New Skills appeared first on SQLServerCentral.
New release: SQL Clone 4.4 supports your Database DevOps process
The post New release: SQL Clone 4.4 supports your Database DevOps process appeared first on SQLServerCentral.
Azure Database Migration Guide
The post Azure Database Migration Guide appeared first on SQLServerCentral.
Heaps in SQL Server: Part 1 The Basics
The series so far: Heaps in SQL Server: Part 1 The Basics This article is the beginning of a series of articles about Heaps in Microsoft SQL Server. Heaps are rejected by many database developers using Microsoft SQL Server. The concerns about Heaps are …
[Video] How to Think Like the SQL Server Engine: All-Demo Edition
You’ve heard of my free How to Think Like the Engine class, and maybe you even started watching it, but…it has slides, and you hate slides. Wanna see me do the whole thing in Management Studio, starting with an empty query window and …
Hands-On with Columnstore Indexes: Part 1 Architecture
Indexes are the key to efficient performance in any relational database. Few index enhancements have been introduced that can improve query speed and efficiency as dramatically as columnstore indexes. Improvements to this feature have been introduced i …
SQL Server 2019 in Containers
The post SQL Server 2019 in Containers appeared first on SQLServerCentral.
The IDENTITY Column Property
Introduction There are a number of ways to generate key values in SQL Server tables, including the IDENTITY column property, the NEWID() function and more recently, SEQUENCES. The IDENTITY column property is the earliest of these methods. It was introd …
Install SQL Server from Configuration File with Installation Center
The post Install SQL Server from Configuration File with Installation Center appeared first on SQLServerCentral.