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: seen from above, a round cake turntable holds a plain unfrosted cake

SIN and COS: Use Radians for Trigonometric Inputs

February 29, 2008
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server

SIN and COS read angles in radians and return float. These explicit degree conversions show signs, axis angles and fractional results at a chosen decimal display scale.

Read More
Hands lifting a root-bound plant from a cracked clay pot, a larger new pot with fresh soil waiting beside it

Planning a Move Off an Old SQL Server Version

February 27, 2008
Pinal Dave
SQL Tips and Tricks
DBA, SQL Migration, SQL Server, SQL Upgrade

Plan a move off an old SQL Server version with a complete inventory, compatibility testing, a supported target, and a dated exit plan.

Read More
A leaf stencil taped to a plaster wall beside three identical painted sage leaves, a paint sponge on a saucer.

Templates and Snippets in SSMS

February 25, 2008
Pinal Dave
SQL Tips and Tricks
SQL Coding Standards, SQL Scripts, SQL Server Management Studio, SQL Shortcut

Templates and snippets in SSMS turn repeated SQL patterns into editable starting points while keeping environment assumptions visible.

Read More
ROUND or truncate illustration, two pale blocks with rounded and trimmed edges on a blue mat.

ROUND or Truncate: Keep Decimal Width in View

February 24, 2008
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server

ROUND or truncate is a choice about the result, not its display format. This complete decimal example checks positive and negative values while preserving enough width for thousands.

Read More
Licensing

SQL SERVER – Understanding Licensing Models

February 23, 2008
Pinal Dave
SQL Tips and Tricks
Database, SQL Licensing, SQL Server

The licensing structure has evolved to reflect advances in technology and diverse use cases. Below are the primary licensing models available:

Read More
SQL SERVER - Find All The User Defined Functions (UDF) - Part 2

SQL SERVER – Find All The User Defined Functions (UDF) – Part 2

February 22, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

Madhivanan shared another way to find all the user defined functions in a database, using information_schema.routines. Here is his short script.

Read More
An old enamel teapot heating on a small camping stove in a meadow at dawn, steam starting to rise.

Installing SQL Server on Linux

February 21, 2008
Pinal Dave
SQL Tips and Tricks
Linux, SQL Server, SQL Server Installation, SQL Setup

Installing SQL Server on Linux involves supported packages, mssql-conf setup, service checks, and an understanding of Windows differences.

Read More
Previous 1 … 515 516 517 518 519 520 521 … 570 Next
  • Books
  • Testimonials
  • Privacy Policy

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