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 - Reducing CXPACKET Wait Stats for High Transactional Database

SQL SERVER – Reducing CXPACKET Wait Stats for High Transactional Database

November 13, 2010
Pinal Dave
SQL Performance
SQL Scripts, SQL White Papers

Reducing CXPACKET wait stats on a high transactional database: what CXPACKET means, and when lowering the degree of parallelism really helps.

Read More
SQL SERVER - Get All the Information of Database using sys.databases

SQL SERVER – Get All the Information of Database using sys.databases

November 12, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts

A handy script from Matteo that uses sys.databases to show plenty of database information, like status, data and log file counts and their sizes in MB.

Read More
Database name backup start date.

SQL SERVER – Get Database Backup History for a Single Database

November 10, 2010
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts

A reader script by aasim abdullah to get database backup history for a single database: backup file, size, time taken, LSNs and the type of each backup.

Read More
SQL SERVER - Recycle Error Log - Create New Log file without Server Restart

SQL SERVER – Recycle Error Log – Create New Log file without Server Restart

November 9, 2010
Pinal Dave
SQL Interview Questions and Answers
SQL Error Messages, SQL Scripts, SQL Server

A client’s DBA restarted the server just to start a fresh Error Log. There is no need: you can recycle the log and create a new file without a restart.

Read More
An old spinning wheel taken apart and laid out on a workshop floor in rows from largest part to smallest.

A Bill of Materials With a Recursive CTE

November 8, 2010
Pinal Dave
SQL Tips and Tricks
CTE, SQL Scripts, SQL Server

Expand a bill of materials with a recursive CTE, multiply quantities across levels, trace component paths, and guard against cycles.

Read More
Schema-bound views illustrated by three plain tied folios beside carefully fitted wooden puzzle pieces on a study table.

Schema-Bound Views: Protect Referenced Columns

November 6, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Scripts, SQL View

Schema-bound views protect referenced columns during table changes. Compare blocked DDL with compatible additions, and check how an ordinary view can retain stale metadata until it is refreshed.

Read More
A row of bean jars on a shelf, one jar with a single extra red bean on top

Leap Years in T-SQL: February 29 and Date Math

November 5, 2010
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server

Handle leap years in T-SQL with date functions, test February boundaries, and choose a clear anniversary rule for February 29 births.

Read More
Previous 1 … 243 244 245 246 247 248 249 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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