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: two lengths of smooth cream rope lie on a polished wooden floor: one forms a closed oval, the other a closed figure eight that crosses itself once in the middle, where a small vermilion bead sits

geometry STIsClosed and STIsSimple: Ask Both Questions

January 6, 2008
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server

geometry STIsClosed does not establish simplicity. These three complete line descriptions compare endpoint closure with self-intersection.

Read More
Lemons in a row beside a red citrus press, a glass of juice before each one except a dry lemon

SQL SERVER – Quick Note on CROSS APPLY

January 4, 2008
Pinal Dave
SQL Tips and Tricks
SQL Joins, SQL Scripts, SQL Server

A quick note on CROSS APPLY: think of it as an inner join to a table valued function that takes parameters, something a regular JOIN cannot do.

Read More
SQL SERVER - 2005 - Last Ran Query - Recently Ran Query

SQL SERVER – 2005 – Last Ran Query – Recently Ran Query

January 3, 2008
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL System Table

Want to see the last ran query on SQL Server 2005? This quick script uses sys.dm_exec_query_stats to list recent queries with the time each one ran.

Read More
A wooden frame with a leather triangle in one corner and a red stone inside the frame but outside the triangle.

geometry STEnvelope: A Bounding Box Includes Extra Space

January 3, 2008
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server

geometry STEnvelope can include points outside the original shape. These two triangle tests keep envelope membership beside exact containment.

Read More
Gouache painting: on three barn shelves stand jars of honey from one harvest

GROUPING SETS: Choose Nonhierarchical Subtotals Explicitly

December 30, 2007
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Reports, SQL Scripts, SQL Server

GROUPING SETS lets me choose independent subtotal combinations instead of assuming one hierarchy. I list the groups the report needs explicitly. That can exclude detail rows while retaining summaries across different dimensions.

Read More
SQL SERVER - TRUNCATE Can't be Rolled Back Using Log Files After Transaction Session Is Closed

SQL SERVER – TRUNCATE Can’t be Rolled Back Using Log Files After Transaction Session Is Closed

December 26, 2007
Pinal Dave
SQL Tips and Tricks
SQL Scripts

Can TRUNCATE be rolled back? Inside an open transaction yes, but once the session is closed TRUNCATE can’t be rolled back using log files, while DELETE can.

Read More
Gouache painting: a tall glass honey jar stands filled nearly to its original line

EXP and LOG: Read Approximate Inverse Calculations

December 24, 2007
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server

EXP and LOG can undo each other mathematically, but their SQL float calculations remain approximate. Keep a deliberate display scale and test only the permitted logarithm domain.

Read More
Previous 1 … 322 323 324 325 326 327 328 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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