Skip to content

SQL Padawan

"The force is strong with this one"

  • About
  • MSSQLTips
  • Repository

Category: storage

2017-10-31 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

2014-11-05 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

2014-10-25 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

2014-10-25 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

2014-10-24 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 2
  • LinkedIn
  • Twitter
  • Skype
  • Email
  • GitHub
  • YouTube
  • Facebook
My Tweets
April 2021
S M T W T F S
 123
45678910
11121314151617
18192021222324
252627282930  
« Nov    

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

 
Loading Comments...
Comment
    ×