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 - Simple Puzzle with UNION - Part 5

SQL SERVER – Simple Puzzle with UNION Part 5

September 11, 2013
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Union clause

In Puzzle with UNION Part 5, the final part, two almost identical queries return the same answer, yet their execution plans are very different. Why?

Read More
Sql server execution plan.

SQL SERVER – Simple Puzzle with UNION Part 4

September 10, 2013
Pinal Dave
SQL Tips and Tricks
SQL Union clause

Puzzle with UNION Part 4 is for readers who want to think: three queries using UNION, a subquery and NOT EQUAL TO return the same result. Compare their plans.

Read More
SQL SERVER - Simple Puzzle with UNION - Part 3

SQL SERVER – Simple Puzzle with UNION Part 3

September 9, 2013
Pinal Dave
SQL Tips and Tricks
SQL Union clause

Simple Puzzle with UNION Part 3 has three T-SQL scripts on the UNION clause, and only one is correct. Can you spot it without running them in Management Studio?

Read More
Plain metal counting tokens sit in separate shallow trays on a quiet wooden desk.

How to Check What SQL Server Licensing You Are Actually Using

September 8, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

Check SQL Server licensing evidence with edition and CPU queries, then reconcile visible processors with host inventory and your agreement.

Read More
A shed shelf of clay pots, several turned upside down among growing plants.

Soft Delete With an IsDeleted Column: Indexes, Views and Keys

September 7, 2013
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Index, SQL Server, SQL View

Design soft delete with an IsDeleted flag, filtered unique keys and indexes, a live-row view, and a measured archive process.

Read More
Query Execution Plan.

SQL SERVER – Simple Puzzle with UNION – Part 2

September 6, 2013
Pinal Dave
SQL Puzzle
SQL Union clause

Another back to basics puzzle with UNION: run three queries using UNION ALL, ORDER BY and DISTINCT, then compare their execution plans.

Read More
SQL SERVER - Simple Puzzle with UNION

SQL SERVER – Simple Puzzle with UNION

September 5, 2013
Pinal Dave
SQL Puzzle
SQL Scripts, SQL Union clause

Try this simple puzzle with UNION and ORDER BY. Guess what each of the three queries returns, and see why one of them fails with Msg 108 and Msg 104.

Read More
A latch hook beside overlapping yarn loops and a short final loop

Overlapping Chunks: Splitting Long Text With GENERATE_SERIES

September 4, 2013
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Server, SQL String

Split long text into overlapping pieces with one short query. Plus the quiet traps: NULL text, a step that is too big, and chopped words.

Read More
A platform luggage cart of suitcases each carrying a huge wooden tag, except one with a small vermilion tag.

Narrow Index Keys: Why the Clustered Key Width Matters Everywhere

September 3, 2013
Pinal Dave
SQL Performance
Clustered Index, Primary Key, SQL Index, SQL Server

Evaluate narrow index keys by comparing clustered GUID and integer designs, measuring index pages, and preserving natural uniqueness.

Read More
The back door of a small bakery with an oiled deadbolt, a fire blanket, a spare key on a hook and a broom.

Database Security Basics for a Small Business

September 2, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, DBA, SQL Backup and Restore, SQL Server Security

Database security basics for a small business cover patching, off-site backups, strong logins, limited access, and encryption that works.

Read More
Previous 1 … 328 329 330 331 332 333 334 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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