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
Gouache painting of a coiled measuring ribbon beside two growing stacks of blocks on a craft table.

Compound Assignment Operators in SQL Server: SQL in Sixty Seconds #009

March 28, 2012
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Operator, SQL Scripts, SQL Variable

Compound assignment operators such as += and *= combine an operation with an assignment in T-SQL. The tests here run all eight operators on SQL Server 2025, and show how NULL, integer division, overflow, truncation and precedence change the result.

Read More
An open blank book with a plain fabric bookmark beside a natural wooden pencil on a quiet desk.

Getting Through a Technical Book You Actually Finish

March 25, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Read a technical book with a practical question, small SQL experiments, and reusable notes that turn each useful chapter into working knowledge.

Read More
A graph plotting data points on a coordinate grid.

Shortest Distance Between Two Shapes in SQL Server: Ramsetu or Adam’s Bridge

March 18, 2012
Pinal Dave
SQL Tips and Tricks
Spatial Database, SQL Function, SQL Scripts, SQL Server

The shortest distance between two shapes in SQL Server comes from ShortestLineTo and STDistance. The tests here show the numbers behind the three original pictures, what happens when shapes overlap or use different SRIDs, and the same method on the globe near Ramsetu.

Read More
A grain flail beside aligned stalks with varied individual seed heads

A Separate Clustered Index for a Nonclustered GUID Primary Key

March 12, 2012
Pinal Dave
SQL Performance
Database, SQL Scripts, SQL Server

The primary key and the clustered index are two different jobs. This demo keeps the GUID as the public ID and clusters on an identity column instead.

Read More
A shop window with a clean rectangular section wiped in the condensation, showing part of the display behind

What Is a View in SQL Server?

March 11, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

A view in SQL Server is a saved query, not a saved copy. Nothing is stored, the text is run every time, and that single fact explains what a view is good for and why it never makes anything faster.

Read More
A tile suction lifter moves a ceramic tile between two padded supports

Cleaning Up Ownership Before Dropping a Departed User

March 10, 2012
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server

DROP USER fails when the user still owns a schema, a role or a table. Here is how to find those owners and hand them over safely.

Read More
An old metal key rests beside a newer unmarked key on folded plain linen.

Finding Deprecated Features Before They Bite

March 9, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Find deprecated features with SQL Server counters, event metadata, and code searches, then separate future risk from features already removed.

Read More
Previous 1 … 206 207 208 209 210 211 212 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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