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: Storage Engine
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…
Analizando sistemas de almacenamiento con Diskspd.exe
Una de las cosas más importantes cuando algo se tuerce, es tener una idea de cuál es el rendimiento normal que podemos esperar de nuestro entorno. Dejádme mostraros como fácilmente podemos testar…
In-Memory NonClustered Indexes, much cooler than disk based
The new In-Memory engine is now available on every edition of SQL Server, including Express, so there is no excuse to start exploring this amazing feature Last week Microsoft has done it. The…
Database Design Matters, Real World Scenario
Sooner or later the more you know how SQL Server works will help you come up with more and more ideas to solve your daily problems, let me show you what one…
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…
Successful Anti-Patterns, Key Lookup VS RID Lookup
This post wants to show some performance improvements we may have by doing things the way we’ve been told not to When it comes to technical subjects like databases, we must always look…
Shrinking large half-empty MDF
Shrinking your database is not a best practice (sometimes can be acceptable) but it might be trickier than you expect Once again I’ve found my inspiration browsing linkedin SQL Server groups. Love it!…