Skip to content

SQL Padawan

"The force is strong with this one"

  • About
  • MSSQLTips
  • Repository

Category: database

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

Posts navigation

«Previous Posts 1 2 3 4
  • 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