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 identical wooden pizza peels lean against a flour-dusted shelf edge, each steeper than the last

TAN: Keep the Angle Away From Its Undefined Point

April 15, 2008
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server

TAN reads radians and returns float. These safe angles demonstrate sign and magnitude while explaining why a large finite float near ninety degrees is not a meaningful infinity.

Read More
A perforated brass insert in a rectangular wooden tray beside a vermilion wooden piece on a round tray and a sage bowl.

PATINDEX and CHARINDEX: Pattern or Literal Search

April 13, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL String

PATINDEX and CHARINDEX answer different questions. Compare wildcard patterns with literal searches, preserve NULL, and pin collation for digit ranges.

Read More
SQL SERVER - 2005 - Find Database Collation Using T-SQL and SSMS - Part 2

SQL SERVER – 2005 – Find Database Collation Using T-SQL and SSMS – Part 2

April 11, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL System Table

Reader jwwishart shared another way to find database collation in SQL Server 2005: a one line SELECT of collation_name from sys.databases.

Read More
SQL SERVER - 2005 - Restore Database Using Corrupt Datafiles (.mdf and .ldf) - Part 2

SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf) – Part 2

April 10, 2008
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Data Storage, SQL Function, SQL Scripts

A last resort for corrupt datafiles with no backup: emergency mode, single user, then DBCC CHECKDB with repair_allow_data_loss. Back up the files first.

Read More
SQL SERVER - 2005 - Transferring Ownership of a Schema to a User

SQL SERVER – 2005 – Transferring Ownership of a Schema to a User

April 5, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

Transferring ownership of a schema to another user in SQL Server 2005 takes one ALTER AUTHORIZATION ON SCHEMA statement. A reader asked, so here it is.

Read More
A stepped podium of coin stacks, with three people sharing the top step.

SQL SERVER – Find Nth Highest Salary of Employee – Query to Retrieve the Nth Maximum value

April 2, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

How do you find the Nth Highest Salary of an employee? I link my earlier answers and share reader Pravin Phatangare’s simple TOP query for the 6th highest salary.

Read More
A small brass bell beside a plain closed envelope and a soft folded cloth on a wooden desk.

What to Alert On, and What to Let Sleep

April 1, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Make SQL Server alerting actionable by tying thresholds to impact, checking missing work, reducing duplicates, and reviewing every overnight call.

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

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