Skip to content

SQL Padawan

"The force is strong with this one"

  • About
  • MSSQLTips
  • Repository
October 31, 2017 database / index / sql server / storage

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 ,

Continue reading

October 26, 2017 database / index / sql server / transaction log

How Update works?

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

Continue reading

October 23, 2017 configuration / database / sql server / tools

SQL Examiner Tool

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

Continue reading

October 12, 2017 best practices / configuration / database / sql server

10 Configurations Best Practices

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

Continue reading

October 6, 2017 database / sql server / undocumented

SQL Server Undocumented 1

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

Continue reading

November 23, 2016 database

Halloween db joke

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

November 5, 2014 b-tree / database / index / index / sql server / storage

Don’t shrink the trees

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

Continue reading

October 25, 2014 sets / sql server / storage

Data types

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

Continue reading

October 25, 2014 job / sql server / storage

Storage – Part II

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

Continue reading

October 24, 2014 sql server / storage

Storage – Part I

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

Continue reading

Posts navigation

«Previous Posts 1 … 3 4 5 6 Next Posts»
  • LinkedIn
  • Twitter
  • Skype
  • Email
  • GitHub
  • YouTube
  • Facebook
My Tweets
December 2019
M T W T F S S
« Nov    
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

Translate

azure b-tree backup best practices checkpoint configuration database DMV How to index job linux locks migration monitoring powershell replication script sets SQL Operations Studio sql server statistics storage tempdb tools transaction log tsql undocumented wait
Blog at WordPress.com.
Cancel