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: from a wooden beam hang two brass bells with a wide gap between them

hierarchyid GetDescendant: Insert Between Siblings

March 30, 2011
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server

hierarchyid GetDescendant can generate a sibling location before, after or between existing bounds. This read-only example computes paths without inserting records or guaranteeing allocation.

Read More
Two wooden gate latches with a separate key below each latch.

Partition Stats Permissions: A SQL Server 2025 CU9 Counterpoint

March 25, 2011
Pinal Dave
SQL Tips and Tricks
SQL Monitoring, SQL Scripts, SQL Server, SQL Server Security

A controlled SQL Server 2025 CU9 test separates partition metadata visibility from access to table rows. Compare the documented permission pair with observed grant behavior, and keep the build-specific result within its measured scope.

Read More
A wooden bar latch above a separate metal valve handle and pipe flowing into a stone basin.

STARTUP_STATE: Check Whether an Extended Events Session Is Running

March 24, 2011
Pinal Dave
SQL Tips and Tricks
SQL Extended Events, SQL Monitoring, SQL Scripts, SQL Server

STARTUP_STATE controls automatic startup after SQL Server starts, while current session state tells whether an Extended Events session is running now. Compare both states and verify an event-file capture before assuming that a setting started the session.

Read More
Tempdb table negative objectid.

SQL SERVER – Denali – ObjectID in Negative – Local TempTable has Negative ObjectID

March 23, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL System Table

On Denali I saw many negative ObjectID values in sys.all_objects. Here is how I found out that each local temp table gets a negative ObjectID.

Read More
Gouache painting: on a garden path a smooth bent willow hoop arches over the ground

STCurveToLine: Convert Curves to Linear Approximations

March 21, 2011
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

STCurveToLine approximates circular curves with linear geometry. Compare curve, polygon, point, empty and NULL results by their type and state.

Read More
SQL SERVER - Log File Growing for Model Database - model Database Log File Grew Too Big

SQL SERVER – Log File Growing for Model Database – model Database Log File Grew Too Big

March 19, 2011
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts

Why did the model database log file grow every day with no activity? The reader was backing up the model database every night. Here is the proof.

Read More
SQL SERVER 2008 - 2012 - Declare and Assign Variable in Single Statement

SQL SERVER 2008 – 2012 – Declare and Assign Variable in Single Statement

March 18, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts

Since SQL Server 2008 you can declare and assign variable values in one statement. This inline assignment saves lines of code, yet I rarely see it used.

Read More
Previous 1 … 232 233 234 235 236 237 238 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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