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
SQL SERVER - Concurrency Basics - Guest Post by Vinod Kumar

SQL SERVER – Concurrency Basics – Guest Post by Vinod Kumar

November 15, 2012
Pinal Dave
SQL Performance

Vinod Kumar explains concurrency basics with a simple queue analogy: the shorter the line, the higher the concurrency, and how databases manage it with locks.

Read More
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
Two identical cottages side by side, one in midday sun and one at night

Storing UTC and Local Time Side by Side

November 13, 2012
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL DateTime, SQL Function, SQL Server

Store UTC and local time consistently, preserve offsets, handle daylight saving changes, and filter timestamps with clear boundaries.

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
Database Location Change Tool.

SQL SERVER – Changing Default Installation Path for SQL Server

November 11, 2012
Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio

Tired of moving MDF and LDF files after you create a database? Change the default installation path in server properties so new databases go where you want.

Read More
A loom with new cloth beside a shelf of finished rolls, the newest tied with red.

Recycling the Error Log on a Schedule and Keeping Enough History

November 10, 2012
Pinal Dave
SQL Tips and Tricks
DBA, SQL Log, SQL Server Agent, SQL Server Configuration

Keep SQL Server logs readable by recycling the error log weekly, retaining enough archives, setting a size cap, and checking history.

Read More
SQLAuthority News - #SQLPASS 2012 Book Signing Photos

SQLAuthority News – #SQLPASS 2012 Book Signing Photos

November 9, 2012
Pinal Dave
SQLAuthority News
SQL PASS, SQLAuthority Author Visit

Book signing photos from SQLPASS 2012: launches of SQL 2012 Functions, SQL Queries 2012 Joes 2 Pros Volume 1 and Tim Radney’s SQL Backup and Recovery.

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
Four dishes waiting in line for one oven, a red casserole first

Ordering a Maintenance Window: Backups, CHECKDB and Index Work

November 6, 2012
Pinal Dave
SQL Tips and Tricks
DBA, Maintenance Plan, SQL Backup and Restore, SQL Index, SQL Server DBCC

Order a maintenance window by listing Agent schedules, separating CHECKDB, backups, index work, and statistics, then tracking growth.

Read More
Previous 1 … 359 360 361 362 363 364 365 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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