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 of a wooden boat with a bare stern panel and a pot of red paint with a brush waiting beside it

Rename a Column or Table in SQL Server Safely

November 14, 2012
Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Scripts, SQL Server Management Studio, SQL Table Operation

To rename a column in SQL Server, call sp_rename with the table and column name, the new name and the word COLUMN. This post tests the rename on a demo database and shows what it leaves behind: a broken view, an old constraint name and permissions that stay. It ends with a safe way to swap two column names.

Read More
Darning mushroom supporting a sock with a small repaired patch

Change Logs as JSON: Old and New Values in One Column

November 12, 2012
Pinal Dave
SQL Tips and Tricks
JSON, SQL Scripts, SQL Server

Skip the audit table with a column for every field. One JSON payload per changed row is lighter, if you handle NULL and multirow updates correctly.

Read More
Grafting knife and prepared scion beside an older intact graft

Checking Certificates That Expire Soon in Every Database

November 8, 2012
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Security

Nobody remembers who created that certificate. Here is a short loop that lists every certificate expiring soon, and what to ask about each one.

Read More
Brewed tea being poured into a pitcher beside three infuser capsules

Window Functions Over GROUP BY Results: SUM of SUM Explained

November 7, 2012
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server

Why does SUM(SUM(Amount)) OVER () work? Because the window runs after GROUP BY. A short demo with shares, ranks and a filter trap.

Read More
Gouache painting of a long cafe table of mismatched mugs and a red teapot by a rainy window with pine trees

Find SQL Server Agent Job Failures Before Users Do

November 4, 2012
Pinal Dave
SQL Tips and Tricks
DBA, SQL Monitoring, SQL Scripts, SQL Server Agent

Agent job failures hide in msdb until someone reads the history. This post builds three demo jobs, then finds the failed step and its message, the job that runs too long, the job that never starts, and the jobs that notify nobody.

Read More
SQL SERVER - Function to Round Up Time to Nearest Minute Interval

SQL SERVER – Function to Round Up Time to Nearest Minute Interval

November 2, 2012
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server

A small T-SQL function that rounds a datetime up or down to the nearest minute interval you pass in, with the code and how to call it.

Read More
A sharpener beside a short usable pencil, an exhausted stub, and a fresh pencil

Identity Overflow Check: How Close Is Each INT Column to 2,147,483,647

November 1, 2012
Pinal Dave
SQL Tips and Tricks
SQL Identity, SQL Scripts, SQL Server

A table with few rows can still be one insert away from error 8115. Here is a check that shows the real headroom of every INT identity column.

Read More
Previous 1 … 196 197 198 199 200 201 202 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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