There are some misconceptions around FillFactor, let’s explore what the setting does or doesn’t do I love SQL Server internals, I do and I just said it. Why? because thanks to all…
Tag: SQL Server Internals
Managing SQL Logins in different environments
In this post I want to show you how we can manage SQL Server logins to avoid a very common problem Speaking of security, in SQL Server we have the possibility of authenticating…
Successful Anti-Patterns, Using Deprecated Data types
From time to time it’s good to remind people about the complexity of a product such as SQL Server. The internals are so wide and complex that we easily get lost and…
Spring cleanup, LOB considerations
For DBA’s it is important to have the ability to recover databases quickly in case of disaster. In order to maximize the potential we need to have our databases ready but sometimes…
Statistics and Data types, What can go wrong?
One of the most interesting things in SQL Server are Statistics. Today I want to write about the creation and update. One of the most interesting things in SQL Server from my point…
In-Memory logging, much cooler than disk based
This week I want to look at one of the most important parts, in my opinion, that allow In-Memory to outperform and scale better than the traditional engine, and this is the…
Successful Anti-Patterns, Storage Requirements
One of the things you realize with experience is that there is not one absolute truth when speaking about SQL Server… that comes along with the magical answer for most of the…
Database Design Matters, choosing the Clustering Key
There has been a permanent debate about which is the right clustering key for our tables since the beginning of the time, this time I’ll get a bit deeper to show you…
Database design Matters, choosing the right data type
This is not the first time I write about best practices or how a good design can help even from a performance point of view, but today I’ll go to an earlier…
TRUNCATE TABLE misconceptions
There is a number misconceptions around TRUNCATE TABLE which have been around for too long that people take them as the real truth, let’s debunk some of those TRUNCATE TABLE in SQL Server…