SQL Padawan

Script to get the tables size in SQL Server

A simple script to know how much space the tables are taking from the disk. SELECT t.name AS TableName ,

Update data in SQL Server is a simple task. Using the command update table set column = value where column

I like tools and I’ve used a couple of them. I had the opportunity to try SQL Examiner to compare

The first checklist before start using any application using SQL Server should be the default configurations. What configurations I used

SQL Server has many undocumented functions and commands. I will write series of posts with functions to have a library online.

OH: A: “What’s the scariest datatype?” B: “What?” A: “a BOOlean” … C: “It’s funny, because it’s TRUE” Lol

The most common and widely used index that we know are nonclustered index. These indexes are created using the famous

Data types and Precedence of convert types SQL Server associates columns, expressions, variables, and parameters with data types. Data types

Logical Structures How, where, when you need to think in data storage? Well, this is the first step after you modeling

Pages and Extends Architecture The page is the fundamental unit of data storage in SQL Server. An extent is a