Skip to content

SQL Padawan

"The force is strong with this one"

  • About
  • MSSQLTips
  • Repository
May 7, 2013 sql server

Search Arguments

SARG or Search Arguments are very important for a good query, even if the predicate is very selective and supported

Continue reading

May 2, 2013 sets / sql server

Temporary Tables

Sometimes we need to use temporary tables to do aggregations, joins or to simplify the job. SQL Server supports a

Continue reading

May 2, 2013 sets / sql server

The Meaning of “Set-Based”

The term set-based is used to describe an approach to handle querying tasks and is based on principles from the

Continue reading

May 1, 2013 job / sql server

Execution Plan

Why I started my blog with some posts about query optimizer, execution plans and logical processing? Well, before you learn

Continue reading

April 28, 2013 sql server

Logical Query Processing

What Happens When a Query is Submitted? The main statement used to retrieve data in T-SQL is the SELECT statement.

Continue reading

April 28, 2013 job / sets / sql server

Structured Query Language

By a “set” we mean any collection M into a whole of definite, distinct objects m (which are called the

Continue reading

April 27, 2013 sets

Thinking in Sets

Thinkins in sets is a great book by Joe Celko’s. This book tell us about concepts how we need to

Continue reading

April 27, 2013 job / sql server

Start

Nothing has change or will change, so we should make the change

Posts navigation

«Previous Posts 1 … 4 5 6
  • LinkedIn
  • Twitter
  • Skype
  • Email
  • GitHub
  • YouTube
  • Facebook
My Tweets
January 2021
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« 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