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
Two small wooden platforms connected by a narrow rope bridge on a neutral tabletop.

Linked Servers and What Goes Wrong With Them

December 17, 2016
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Server

Investigate linked server performance and failures by checking remote work, provider settings, security mappings, and the alternatives available.

Read More
SQL SERVER - Performance Analysis of Backup to Azure

SQL SERVER – Performance Analysis of Backup to Azure

December 14, 2016
Pinal Dave
SQL Performance
SQL Azure, SQL Backup and Restore, SQL Scripts, SQL Server

Compression saves backup space, but does it save time too? My Performance Analysis of backup to Azure compares timings with and without compression.

Read More
A long clothes rail of shirts sorted by shade, one section opened at a red hanger.

Columnstore Segment Elimination: Loading Data So Scans Skip Work

November 17, 2016
Pinal Dave
SQL Performance
ColumnStore Index, SQL Index, SQL Performance, SQL Server

See how segment elimination skips columnstore work by checking segment metadata, measuring scans, and loading rows in a useful order.

Read More
A child in red mittens rolling one huge snowball across a snowy lawn past small handfuls of snow

Network Packet Size: When a Bigger Packet Helps Large Results

November 15, 2016
Pinal Dave
SQL Performance
Computer Network, SQL Connection, SQL Server, SQL Server Configuration

Test network packet size on a specific SQL Server connection, verify the negotiated value, and compare large-result performance carefully.

Read More
SQL SERVER 2016 - Creating Clustered ColumnStore with InMemory OLTP Tables

SQL SERVER 2016 – Creating Clustered ColumnStore with InMemory OLTP Tables

October 6, 2016
Pinal Dave
SQL Performance
Clustered Index, ColumnStore Index, In-Memory OLTP, SQL PASS, SQL Scripts, SQL Server

While preparing my SQLPASS session on SQL Server 2016, I explored creating clustered ColumnStore with InMemory OLTP tables. Here is what I learned.

Read More
Illustrated cover: AUTO_CLOSE: Turn It Off

SQL SERVER – Set AUTO_CLOSE Database Option to OFF for Better Performance

September 22, 2016
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Server Configuration, SQL Server Management Studio

How I helped a customer get better performance by setting the AUTO_CLOSE Database Option to OFF, and why this setting hurts busy databases.

Read More
Gouache painting of a brass service bell with a red felt cap on a flower shop counter in front of buckets of tulips

SET NOCOUNT ON in SQL Server: How to Hide Rows Affected Messages

September 21, 2016
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Server Management Studio, SQL Stored Procedure

SET NOCOUNT ON stops SQL Server from sending a rows affected message after every statement. This post tests what it changes and what it doesn’t: @@ROWCOUNT, scope inside a procedure, timing and the text that sp_updatestats prints. It also covers client programs that depend on the count.

Read More
Previous 1 … 54 55 56 57 58 59 60 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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