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
Cumulative IO of database files.

SQL SERVER – Script: Finding Cumulative IO Per Database File

January 2, 2016
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Scripts

A simple script to find cumulative IO per database file in SQL Server, and the real scenarios where this number helps you.

Read More
SQL Server 2016 - Enhancements with TempDB

SQL Server 2016 – Enhancements with TempDB

December 30, 2015
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Server 2016, SQL TempDB

SQL Server 2016 makes TempDB more scalable out of the box. Here are the enhancements with TempDB, from setup options to less contention under load.

Read More
SQL SERVER - Script: Remove Spaces in Column Name in All Tables

SQL SERVER – Script: Remove Spaces in Column Name in All Tables

December 26, 2015
Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Scripts, SQL Server

A reader wanted a script to remove spaces from every column name in all tables. Here it is, with a warning first: renaming columns can break your application.

Read More
Diagram of an AlwaysOn primary replica that keeps the OLTP work while backups and reports move to the secondary replica, with the Secondary only backup preference and ApplicationIntent=Read-only

Offloading Backups to a Secondary Replica: Notes from the Field #108

December 24, 2015
Pinal Dave
SQL Tips and Tricks
AlwaysOn, Notes from the Field, SQL Backup and Restore, SQL Scripts, SQL Server

Offloading backups to a secondary replica takes work off the primary server. In Notes from the Field #108, Eduardo Castro explains backup priority and read-only routing for AlwaysOn availability groups.

Read More
SQL SERVER - Unable to drop login - Msg 15170, Level 16, State 1

SQL SERVER – Unable to drop login – Msg 15170, Level 16, State 1

December 23, 2015
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Login, SQL Scripts, SQL Server

Cleaning up my demo server, I could not drop login danny because of Msg 15170: the login owns a job. Here is how to find what a login owns and remove it.

Read More
SQL SERVER 2016 - New T-SQL Functions - COMPRESS - DECOMPRESS

SQL SERVER 2016 – New T-SQL Functions – COMPRESS – DECOMPRESS

December 21, 2015
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server, SQL Server Security

SQL Server 2016 adds two new string functions, COMPRESS – DECOMPRESS. Here is how they work, with examples, and the error you get on older versions.

Read More
Diagram of transactional replication: the Publisher with the source database sends changes to the Distributor with the distribution database, which delivers them to the Subscriber with the destination database

Readable Secondary in Standard Edition: Transactional Replication Setup

December 17, 2015
Pinal Dave
SQL Tips and Tricks
AlwaysOn, Notes from the Field, SQL Replication, SQL Scripts, SQL Server

A secondary server sitting idle as a backup feels like a waste. In Notes from the Field #107, Kenneth Urena shows how to build a readable secondary in Standard Edition with transactional replication.

Read More
Previous 1 … 156 157 158 159 160 161 162 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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