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 ,
"The force is strong with this one"
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