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: on a floured board, one long strand of fresh pasta on the left is folded into a V with a doubled-back spike through its middle, overlapping itself

geometry MakeValid: Repair Can Change the Geometry Type

August 14, 2010
Pinal Dave
SQL Tips and Tricks
Spatial Database, SQL Function, SQL Scripts, SQL Server

geometry MakeValid returns a valid geometry from an invalid instance, but the result can change type. I keep the original beside the proposed repair. A validity flag alone does not describe everything that changed.

Read More
Execution plan with and without index.

SQL SERVER – Computed Column and Performance – Part 3

August 13, 2010
Pinal Dave
SQL Performance
SQL Index, SQL Scripts

Part 3 of my series on computed column and performance shows how an index improves the performance of a computed column. Read the earlier parts first.

Read More
SQL SERVER – SHRINKDATABASE For Every Database in the SQL Server

SQL SERVER – SHRINKDATABASE For Every Database in the SQL Server

August 12, 2010
Pinal Dave
SQL Performance
DBA, SQL Scripts

A query tuning visit turned into a lesson on why running SHRINKDATABASE for every database is a bad idea. Here is what happened at the client’s office.

Read More
Execution plan diagram showing parallelism and cost percentages.

SQL SERVER – Parallelism Query in Database

August 6, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts

Feodor asked how to get a parallelism query plan on a dual core computer using AdventureWorks. Here is the T-SQL I used to reproduce a parallel plan.

Read More
SQL SERVER - Computed Column - PERSISTED and Performance - Part 2

SQL SERVER – Computed Column – PERSISTED and Performance – Part 2

August 4, 2010
Pinal Dave
SQL Performance
SQL Scripts

Part 2 on PERSISTED and performance shows the other side: when non-persisted computed columns give better performance than PERSISTED ones.

Read More
SQL SERVER - Computed Column - PERSISTED and Performance

SQL SERVER – Computed Column – PERSISTED and Performance

August 3, 2010
Pinal Dave
SQL Performance
Computed Column, SQL Scripts, SQL Server

My computed column series in one list: PERSISTED versus non-persisted for storage and speed, and how an index on the column improves performance.

Read More
A muffin tin with one empty cup, while two muffins are squeezed together into the cup next to it.

Relational Division in T-SQL: Customers Who Bought Every Product

August 2, 2010
Pinal Dave
SQL Tips and Tricks
SQL Joins, SQL Scripts, SQL Server, SQL Sub Query

Solve relational division with counts and double NOT EXISTS, then handle duplicates, NULL values, empty requirements, and exact matching.

Read More
Previous 1 … 251 252 253 254 255 256 257 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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