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
A hand sets a plate on its embroidered outline on a half-set table, a red jug in the center.

Writing Rerunnable Deployment Scripts for Database Changes

May 1, 2020
Pinal Dave
SQL Tips and Tricks
Best Practices, DevOps, SQL Scripts, SQL Server

Write rerunnable deployment scripts with guarded schema changes, version records, and a dry run on a restored database copy.

Read More
sqlcmd mode

SQL SERVER Management Studio and SQLCMD Mode

April 30, 2020
Pinal Dave
SQL Tips and Tricks
SQL Download, SQL Scripts, SQL Server, SQL Server Management Studio, sqlcmd, Testing

Honestly, there is an alternative way to quickly use SSMS SQLCMD mode as a development environment, let us learn about it today. 

Read More
Gouache painting of a wooden spoon with a vermilion handle beside a big cream stand mixer

sqlcmd vs SSMS: How to Time the Same Loop Fairly

April 29, 2020
Pinal Dave
SQL Performance
Command Line, SQL Scripts, SQL Server Management Studio, sqlcmd, Testing

A sqlcmd vs SSMS timing is fair only when both tools run the same file. The clock must sit inside the script. This post times 10,000 inserts three ways with a log table, shows what changed and what didn’t, and lists the settings to match before you compare.

Read More
Gouache painting of a grey wheelbarrow of pumpkins beside a vermilion tractor on a farm track

oStress vs SSMS: What Each Tool Is Built to Measure

April 28, 2020
Pinal Dave
SQL Performance
Command Line, SQL Scripts, SQL Server Management Studio, Testing

oStress vs SSMS is not a race, because the tools measure different things. This post times 10,000 inserts in three ways with a clock inside the script, then shows how eight sessions finish the same work faster. It explains what a one-session loop really measures.

Read More
Gouache painting of a wide channel splitting into small garden channels through one vermilion sluice gate

Query Store On or Off for Every Database: Review First

April 25, 2020
Pinal Dave
SQL Tips and Tricks
Query Store, SQL DMV, SQL Scripts, SQL Server Configuration

To turn Query Store on or off for every database, you need one statement per database, because there is no server switch. This post builds a tested script that writes the statements, lets you read them and then runs them in one batch. It also covers READ_ONLY mode and the model database.

Read More
Gouache painting of a row of white beehives in a meadow, some open and some closed, one vermilion

Query Store Status for Every Database in SQL Server

April 24, 2020
Pinal Dave
SQL Performance
Query Store, SQL DMV, SQL Scripts, SQL Server Configuration

Query Store status for every database takes two queries, and the first is not enough. This post builds four demo databases, shows why the is_query_store_on flag hides frozen and read-only states, and runs one script that reads the real state of each database. It also shows what Query Store costs in memory.

Read More
Gouache painting of an open old trunk with brass binoculars resting on a vermilion cloth

sp_helpdb in SQL Server: List Databases and Their Files

April 21, 2020
Pinal Dave
SQL Tips and Tricks
SQL Command, SQL Data Storage, SQL Scripts, SQL Stored Procedure

sp_helpdb in SQL Server lists every database on an instance, or the files of one database, with a single call. This post builds three small databases, reads the output column by column and explains why db_size is text. It also shows how to filter the result and how to find free space.

Read More
Previous 1 … 42 43 44 45 46 47 48 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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