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…
Etiqueta: SQL Server Internals
Administar Inicios de Sesión de SQL en entornos diferentes
En este post quiero mostrar como podemos administrar inicios de sesion en SQL Server para evitar un problema bastante comun En SQL Server tenemos la posibilidad de autenticarnos de dos maneras diferentes, una…
Anti-patrones exitosos, utilizando tipos de datos obsoletos
De vez en cuando, es bueno recordarle a la gente la complejidad de un producto como SQL Server. Las partes internas son tan amplias y complejas que nos perdemos fácilmente y seguimos…
Limpieza de primavera, consideraciones con datos LOB
Para los DBA’s es importante tener la posibilidad de recuperar bases de datos de una forma rápida en case de un desastre. Pasa maximizar ese potencial necesitamos tener nuestras bases de datos…
Estadísticas y Tipos de Datos, Qué Podría Salir Mal?
One of the most interesting things in SQL Server are Statistics. Today I want to write about the creation and update. Una de las cosas más interesantes en SQL Server desde mi punto…
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…