How do I learn and how do I teach? My T-SQL Tuesday answer looks back at my teachers and books as a kid and at what I am learning and teaching today.
Unsigned Integers: Safe Type and Range Mapping
Map unsigned integers to SQL Server types without narrowing their range. Keep strict source-text validation separate from destination CHECK constraints.
SQL SERVER – Parallelism – Row per Processor – Row per Thread – Thread 0
What does Thread 0 in a parallel execution plan mean? Reader Marko Parkkola gave the best answer: it synchronizes the other threads. Here it is in detail.
SQLAuthority News – Milestone – 1400th Post and Why do I blog
My 1400th post looks back at the journey I started on Nov 1, 2006, and gives an honest answer to a question I hear a lot: why do I blog?
SQL Server: Why INSERT OUTPUT Does Not Prove a Commit
INSERT OUTPUT can return an identifier before a transaction commits. These tested examples show a rollback after a returned row and a pattern that returns results after commit.
SQL SERVER – The Self Join – Inner Join and Outer Join
Is a Self Join an inner join or an outer join? It can be either. I build a small new example that shows Self Join as inner join and outer join.
SQL SERVER – Upper Case Shortcut SQL Server Management Studio
Want an upper case shortcut in SSMS? Select a keyword and press CTRL+SHIFT+U to make it upper case, or CTRL+SHIFT+L to make it lower case.
SQLAuthority News – I am Microsoft Certified Trainer (MCT)
I am a Microsoft Certified Trainer and proud of it. This post shows how strict bureaucratic rules can make a well confirmed training project crash.
SQL SERVER – PowerShell Version Info
Two commands show your PowerShell version: $PSVersionTable and $host. Only one worked on Version 1, so I ask PowerShell experts to explain why.
SQL SERVER – Index Levels, Page Count, Record Count and DMV – sys.dm_db_index_physical_stats
How many pages does an index use, and how many B-Tree levels does it have? sys.dm_db_index_physical_stats shows index levels, page count and record count.










