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: a short wooden rack holds eight cream balls in one row

Bit Shifts: Move Bits Without Rotating Them

May 16, 2008
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

Bit shifts fill vacant positions with zero and discard bits past the type width. Compare tinyint with int and a negative shift direction.

Read More
SQL SERVER - Orphaned MS DTC Transaction Information

SQL SERVER – Orphaned MS DTC Transaction Information

May 14, 2008
Pinal Dave
SQL Performance
SQL Error Messages, SQL Scripts

An orphaned MS DTC transaction kept crashing our IIS application pool. A quick script on sys.syslockinfo shows if you have one, and a Microsoft hotfix solved it.

Read More
SQL SERVER - Function Property - Deterministic or Non-Deterministic

SQL SERVER – Function Property – Deterministic or Non-Deterministic

May 10, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

How do you tell if a user defined function is deterministic or non-deterministic? One OBJECTPROPERTY call with IsDeterministic gives you the answer.

Read More
Colored ceramic beads in a pale shallow tray beside an empty tray and a separate blue bead.

XQuery distinct-values: Deduplicate Atomic Values, Not Nodes

May 9, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server, SQL XML

XQuery distinct-values removes repeated atomic values rather than selecting representative source nodes. I rebuild a small sorted XML result from repeated text. The example also keeps an empty document in view.

Read More
SQL SERVER - 2005 - Find Tables With Foreign Key Constraint in Database - Part 2

SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database – Part 2

May 8, 2008
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts, SQL System Table

Joffery improved my script to find tables with foreign key constraint in a database, adding the ON UPDATE and ON DELETE rules and a little ordering.

Read More
SQL SERVER - Find Table in Every Database of SQL Server - Part 2 Extension

SQL SERVER – Find Table in Every Database of SQL Server – Part 2 Extension

May 5, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, Undocumented SQL

Two more ways from Simon Worth to find table in every database of SQL Server, both built on sp_msforeachdb, one saving results to a temp table.

Read More
A damaged cream pottery bowl and its detached rim fragment sit beside an intact empty bowl on a worktable.

NOT and NULL: Unknown Does Not Become True

May 2, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Scripts, SQL Server

NOT and NULL do not create a complete two-way classification. State whether missing values belong in a filter or a separate reporting category.

Read More
Previous 1 … 312 313 314 315 316 317 318 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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