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
Sold Out - Tuning Webinar.

We Are Sold Out – Practical Real World Performance Tuning – SQL Authority News

June 5, 2018
Pinal Dave
SQLAuthority News
Brent Ozar, SQL Performance

Both USA time zone classes of Practical Real World Performance Tuning sold out, much faster than I expected. Here is my thank-you note and a quick update.

Read More
SQLPASS Pre-Con: 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs sqlpass18-800x213

21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs – PASS Pre-Con 2018

May 2, 2018
Pinal Dave
SQLAuthority News
SQL PASS, SQL Performance, SQL Training

My PASS Summit 2018 pre-con, 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs, is a full day of demos. Here is what it covers.

Read More
Force parallel execution plan.

How to Force a Parallel Execution Plan for a Query? – Interview Question of the Week #170

April 22, 2018
Pinal Dave
SQL Interview Questions and Answers
Execution Plan, SQL Performance, SQL Scripts, SQL Server

A customer asked how to force a Parallel Execution Plan for a query. Here are two methods, including QUERYTRACEON 8649, with a simple example.

Read More
SQLPASS Pre-Con: 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs sqlpass18-800x213

SQLPASS Pre-Con: 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs

April 12, 2018
Pinal Dave
SQL Performance
SQL PASS, SQL Performance, SQL Scripts, SQL Training

Coming to SQL PASS in Seattle? Join my full-day pre-con, 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs, on November 6, 2018.

Read More
Man in glasses wearing black SQL Authority shirt.

SQL Authority News – Brent Ozar Unlimited Office Hours 2018/4/4 – Fun Experience

April 11, 2018
Pinal Dave
SQLAuthority News
Brent Ozar, Clustered Index, Database Mail, SQL Index, SQL Performance, SQL Replication, SQL Training

I joined Brent, Richie and Tara for Brent Ozar Unlimited office hours and answered live questions, from replication latency to disk space. Here is the list.

Read More
Tuning for performance.

Practical Real World Performance Tuning – Frequently Asked Questions

March 28, 2018
Pinal Dave
SQLAuthority News
Brent Ozar, SQL Index, SQL Performance, SQL Server, SQL Training

Seats for Practical Real World Performance Tuning with Brent Ozar are nearly gone. Here are answers to the questions I keep getting by email about the course.

Read More
SELECT vs SET.

Which is Better for Performance – SELECT or SET? – Interview Question of the Week #166

March 25, 2018
Pinal Dave
SQL Interview Questions and Answers
SQL Performance, SQL Server

Which is Better for Performance, SELECT or SET? In a loop, one SELECT that assigns several variables beats separate SET statements. Here is why.

Read More
Previous 1 … 19 20 21 22 23 24 25 … 27 Next
  • Books
  • Testimonials
  • Privacy Policy

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