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
Water poured from a jug overflows a small espresso cup into its saucer.

Computed Column Data Types: Why the Result Type Surprises You

September 29, 2008
Pinal Dave
SQL Tips and Tricks
Computed Column, SQL Column, SQL Datatype, SQL Error Messages

Your table accepts every insert, then the report dies with an overflow error. Here is why the type is inherited and the cast that fixes it.

Read More
A hand measuring the sleeve of a finished jacket on a dress form with a cloth tape measure

Finding Column Definitions Without the Documentation

August 12, 2008
Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Documentation, SQL Server, SQL System Table

Find column definitions in SQL Server with sys.columns, sys.types, and sys.all_columns, including length, nullability, and system objects.

Read More
Previous 1 … 5 6 7 8
  • Books
  • Testimonials
  • Privacy Policy

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