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: four wooden window shutters stand in a row on a cream plaster farmhouse wall, the first and fourth closed, the second open

Bitwise Flags: Test, Add and Toggle Individual Bits

April 26, 2007
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

Bitwise flags use AND to test, OR to add and XOR to toggle a mask. Keep flag meanings explicit and preserve missing values in read-only examples.

Read More
SQL SERVER - ERROR Messages - sysmessages error severity level

SQL SERVER – ERROR Messages – sysmessages error severity level

April 25, 2007
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server Security

SQL Server ERROR Messages explained: each has a number, a severity level and a state from 1 to 127, and all of them are stored in the sysmessages system table.

Read More
SQL SERVER - 2005 Take Off Line or Detach Database

SQL SERVER – 2005 Take Off Line or Detach Database

April 25, 2007
Pinal Dave
SQL Performance
SQL Scripts

To take off line a database in SQL Server 2005, use ALTER DATABASE SET OFFLINE with ROLLBACK AFTER 30 SECONDS or ROLLBACK IMMEDIATE instead of sp_dboption.

Read More
SQL SERVER - TRIM() Function - UDF TRIM()

SQL SERVER – TRIM() Function – UDF TRIM()

April 24, 2007
Pinal Dave
SQL Performance
SQL Function, SQL Scripts

SQL Server 2005 has LTRIM() and RTRIM() but no TRIM() function, so I wrote a simple UDF for SQL Server 2000 and 2005 that trims both sides. Video included.

Read More
Two brass funnels resting in slate and ivory ceramic vessels.

IIF and CASE: Control Return Types and Use Typed NULL Values

April 23, 2007
Pinal Dave
SQL Tips and Tricks
SQL Coding Standards, SQL Function, SQL Scripts, SQL Server

IIF and CASE choose result values, but their branches also define a shared return type. I make that type explicit when mixed inputs could surprise the reader. Typed NULL values help describe the same output contract.

Read More
SQL SERVER - Query to Find Seed Values, Increment Values and Current Identity Column value of the table

SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column value of the table

April 23, 2007
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Identity, SQL Index, SQL Scripts, SQL Server, SQL System Table

A query to list every identity column with its seed, increment and current value, plus what those numbers mean and how to reseed a table safely.

Read More
An open card index drawer with one card lifted, a second smaller card paper-clipped behind it.

SQL SERVER – Understanding new Index Type of SQL Server 2005 Included Column Index along with Clustered Index and Non-clustered Index

April 23, 2007
Pinal Dave
SQL Performance
SQL Constraint and Keys, SQL Index, SQL Scripts, SQL Server

Clustered index and non-clustered index compared: how many you can have, how each stores data, and where the SQL Server 2005 included column index fits.

Read More
Previous 1 … 352 353 354 355 356 357 358 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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