The OUTPUT clause in simple examples: see exactly which rows your INSERT, UPDATE or DELETE changed, using the INSERTED and DELETED tables.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Ranking Functions – Advanced NTILE in Detail – Day 13 of 35
How the NTILE ranking function splits sorted rows into groups, or tiles, explained with a class ranking example from the Joes 2 Pros series.
SQL SERVER – Ranking Functions – RANK( ), DENSE_RANK( ), and ROW_NUMBER( ) – Day 12 of 35
RANK( ), DENSE_RANK( ), and ROW_NUMBER( ) return the same results until your data has a tie. Day 12 shows how each ranking function handles tied values.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Advanced Aggregates with the Over Clause – Day 11 of 35
Advanced aggregates with the OVER clause from Joes 2 Pros: partition your data so each number is compared against its own category, not the whole set.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Aggregates with the Over Clause – Day 10 of 35
A Joes 2 Pros tip on aggregates with the OVER clause: show each grant next to the total of all grants and work out its share, just like market share.
SQL SERVER – Tips from the Development Series – Overriding Identity Fields – Day 9 of 35
Identity fields give each new customer or invoice a unique number, even with many users entering data. Here is when and how to go about Overriding Identity Fields.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Many to Many Relationships – Day 8 of 35
Many to many relationships explained with an online shopping cart: one order holds many products, and one product is bought by many customers.