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 square slabs of pale clay overlap at one corner on a potter's table

geometry STUnion: Merge the Shared Area Only Once

May 31, 2010
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server

geometry STUnion merges geometry coverage. These exact-coordinate rectangles distinguish a combined area from the sum of two areas, including duplicate coverage.

Read More
Two clusters of blue and pale beads on a linen strip separated by terracotta cord knots.

REGEXP_INSTR: Locate a Match or a Capture Group

May 30, 2010
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server

REGEXP_INSTR returns the position of a selected regular-expression match or capture group. I compare its positional arguments using one short string. This example needs SQL Server 2025 and database compatibility level 170.

Read More
SQL SERVER - Disabled Index and Update Statistics

SQL SERVER – Disabled Index and Update Statistics

May 28, 2010
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server, SQL Statistics

A reader asked how disabled indexes affect statistics. With the clustered index disabled, Update Statistics throws an error; see what happens once you enable it.

Read More
SQL SERVER - DATE and TIME in SQL Server 2008

SQL SERVER – DATE and TIME in SQL Server 2008

May 27, 2010
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts, SQL Server

What happens when you convert DATE and TIME in SQL Server 2008 to DATETIME? A quick demo shows the midnight and 1900 surprise.

Read More
A small wooden house beside a larger shared wooden shelter on a warm neutral tabletop.

Azure SQL Database and SQL Server: What Changes

May 25, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Compare Azure SQL Database with SQL Server, including jobs, cross-database access, monitoring, backup control, and operational responsibilities.

Read More
SQL SERVER – Check the Isolation Level with DBCC useroptions

SQL SERVER – Check the Isolation Level with DBCC useroptions

May 24, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL System Table, Transaction Isolation

What isolation level is your session using? Run DBCC useroptions to see it, along with dateformat, datefirst, language and other SET options.

Read More
SQL SERVER - Simple Example of Snapshot Isolation - Reduce the Blocking Transactions

SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions

May 21, 2010
Pinal Dave
SQL Performance
SQL Scripts, Transaction Isolation

Snapshot Isolation has been in SQL Server since 2005, yet many shops still skip it. A simple example shows how it can reduce blocking transactions.

Read More
Previous 1 … 257 258 259 260 261 262 263 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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