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
Adjustable band inside a felt hat beside a cut band and matching insert

Metadata-Only Column Changes: Which ALTER COLUMN Is Instant

July 6, 2014
Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Data Storage, Transaction Log

Six ALTER statements look equally small, but their log cost is not. Here is how to measure each one before the change window.

Read More
Nested wooden boxes open one inside another, a red ring in the smallest

The SQL Server Permission Hierarchy

July 5, 2014
Pinal Dave
SQL Tips and Tricks
DBA, Schema, SQL Login, SQL Server Security

Understand the SQL Server permission hierarchy from server to database, schema, and object, including GRANT, DENY, and role paths.

Read More
Configuration Changes History.

SQL SERVER – SSMS: Configuration Changes History

July 4, 2014
Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio

My friend Joe’s new job needed standard server settings. The SSMS Configuration Changes History report shows when settings changed. Here is how it helps.

Read More
SQL SERVER - Automate Database Operations for Success - Notes from the Field #035

SQL SERVER – Automate Database Operations for Success – Notes from the Field #035

July 3, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Scripts, SQL Server Security

It is not about how busy you are, but how valuable you are. Brian Kelley explains how to automate database operations and get more important work done.

Read More
SQL SERVER - SSMS: Server Dashboard Report

SQL SERVER – SSMS: Server Dashboard Report

July 2, 2014
Pinal Dave
SQL Tips and Tricks
SQL Reports, SQL Server, SQL Server Management Studio

Like a car’s dashboard, the SSMS Server Dashboard Report shows the health of your SQL Server at a glance. Here is what this basic report tells you.

Read More
Gouache painting: a wooden desk with neatly bound report folders fanned out in a half circle and a brass magnifying glass resting on them; one folder is vermilion

SQL SERVER – Introduction to SQL Server Management Studio Reports

July 1, 2014
Pinal Dave
SQL Tips and Tricks
SQL Reports

Who dropped my table? Who is using my memory? SQL Server Management Studio Reports answer many such questions. Here is an introduction to them.

Read More
Blocked process report window.

SQL SERVER – Find Blocking Using Blocked Process Threshold  

June 30, 2014
Pinal Dave
SQL Tips and Tricks
SQL Activity Monitor, SQL Lock

My friend Jim came back with more blocking questions. Here is how the blocked process threshold option, a feature hidden in plain sight, helps find blocking.

Read More
Fine saw beside its matching narrow kerf and a wider saw farther away

Missing Index Query Text: Linking Suggestions to Their Queries

June 29, 2014
Pinal Dave
SQL Performance
Execution Plan, SQL DMV, SQL Index

A missing index suggestion means more when you can see its query. Here is how to link them, trim the text and test the index.

Read More
MySQL - Add a Column at Particular Ordinal Position in Table

MySQL – Add a Column at Particular Ordinal Position in Table

June 28, 2014
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Scripts

SQL Server needs the designer to add a column at a particular ordinal position, but MySQL does it with ALTER TABLE and AFTER. Here is a quick example.

Read More
Gouache painting: a narrow country lane where one stalled vermilion handcart stands across the path, and a line of other wooden carts waits patiently behind it

SQL SERVER – Activity Monitor to Identify Blocking – Find Expensive Queries

June 27, 2014
Pinal Dave
SQL Performance
SQL Activity Monitor

My friend Jim needed an easy way to find blocking on a live system. Here is how to use Activity Monitor to identify blocking and find expensive queries.

Read More
Previous 1 … 297 298 299 300 301 302 303 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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