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
Replica Server Name Table.

SQL SERVER – Scripts to Overview HADR / AlwaysOn Local Replica Server

September 11, 2018
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Replication, SQL Scripts, SQL Server

SQL Server expert Dominic Wirth shares a script that gives a utilization overview of the local AlwaysOn replica server: database count and size, by role and group.

Read More
Two empty bowls receive nothing from a closed wooden gate and a plugged pottery jug

Which is Optimal – TOP 0 OR WHERE 1 = 2? – Interview Question of the Week #190

September 9, 2018
Pinal Dave
SQL Interview Questions and Answers
SQL Function, SQL Scripts, SQL Server

Which is optimal, TOP 0 or WHERE 1 = 2? Many interview answers get this wrong, but they are both the same, and STATISTICS IO shows why.

Read More
A to Z alphabet smiley faces.

Alphabets – SQL SERVER – Retrieving Rows With All Alphabets From Alphanumeric Data

September 4, 2018
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server, SQL String

I got an email from one of my blog readers asking for an easy way to identify if a given string contains only alphabets. There can be methods.

Read More
An unsettled mosaic in its assembly jig is inspected beside a stable finished sample.

SQL SERVER – Applying NOLOCK to Every Single Table in Select Statement – SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

September 3, 2018
Pinal Dave
SQL Performance
Query Hint, SQL Scripts, SQL Server, Transaction Isolation

READ UNCOMMITTED changes session read isolation without adding NOLOCK to every table. A workshop procedure made the distinction useful.

Read More
Two different sealed jars travel together in a wooden crate between stone shelves

How to Move SQL Server MDF and LDF Files? – Interview Question of the Week #189

September 2, 2018
Pinal Dave
SQL Interview Questions and Answers
File format, SQL Scripts, SQL Server

How do you move SQL Server MDF and LDF files? Detach and attach is the old way, so here is the step-by-step method I use for my clients today.

Read More
Gouache painting of a row of wooden crates with one repainted in vermilion and a brush on its rim

Rename Physical File Name of a SQL Server Database

September 1, 2018
Pinal Dave
SQL Tips and Tricks
SQL Data Storage, SQL Scripts, SQL Server Configuration

To rename physical file name entries for a SQL Server database, take it offline, change the catalog with MODIFY FILE, rename the files in Windows and bring the database online. This post builds a demo, shows the error a missing file causes, and gives a way to undo the change.

Read More
Gouache painting of a row of teacups with cream ribbons and one cup with a vermilion ribbon

Rename Logical File Name of a SQL Server Database

August 31, 2018
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Data Storage, SQL Scripts

To rename logical file name entries in SQL Server, use ALTER DATABASE with MODIFY FILE and NEWNAME. This post builds a demo database, renames both files and checks the result. It also covers names with dots and the two errors that stop a rename.

Read More
Previous 1 … 91 92 93 94 95 96 97 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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