This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQL SERVER - How do I Learn and How do I Teach

SQL SERVER – How do I Learn and How do I Teach

July 13, 2010
Pinal Dave
Personal

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.

Read More
Three wooden gauges with finite end stops and fitted measuring bars in a sunlit workshop.

Unsigned Integers: Safe Type and Range Mapping

July 12, 2010
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Datatype, SQL Migration, SQL Server

Map unsigned integers to SQL Server types without narrowing their range. Keep strict source-text validation separate from destination CHECK constraints.

Read More
SQL SERVER - Parallelism - Row per Processor - Row per Thread - Thread 0

SQL SERVER – Parallelism – Row per Processor – Row per Thread – Thread 0

July 11, 2010
Pinal Dave
SQL Tips and Tricks

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.

Read More
SQLAuthority News - Milestone - 1400th Post and Why do I blog

SQLAuthority News – Milestone – 1400th Post and Why do I blog

July 10, 2010
Pinal Dave
Personal

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?

Read More
Gouache painting of an open parcel with a loose red ribbon and blank receipt, illustrating INSERT OUTPUT before commit.

SQL Server: Why INSERT OUTPUT Does Not Prove a Commit

July 9, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Transactions

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.

Read More
SQL SERVER - The Self Join - Inner Join and Outer Join

SQL SERVER – The Self Join – Inner Join and Outer Join

July 8, 2010
Pinal Dave
SQL Tips and Tricks
SQL Joins, SQL Scripts

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.

Read More
SQL SERVER - Upper Case Shortcut SQL Server Management Studio

SQL SERVER – Upper Case Shortcut SQL Server Management Studio

July 7, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts, 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.

Read More
SQLAuthority News - I am Microsoft Certified Trainer (MCT)

SQLAuthority News – I am Microsoft Certified Trainer (MCT)

July 6, 2010
Pinal Dave
SQLAuthority News
SQL Training

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.

Read More
PowerShell Version Info.

SQL SERVER – PowerShell Version Info

July 5, 2010
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Scripts

Two commands show your PowerShell version: $PSVersionTable and $host. Only one worked on Version 1, so I ask PowerShell experts to explain why.

Read More
Clustered Index B-Tree

SQL SERVER – Index Levels, Page Count, Record Count and DMV – sys.dm_db_index_physical_stats

July 4, 2010
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Index, SQL Scripts

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.

Read More
Previous 1 … 450 451 452 453 454 455 456 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com