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 basket of mixed shells beside one-of-each shells and grouped shells

Interview Question of the Week #020 – What is the Difference Between DISTINCT and GROUP BY?

May 17, 2015
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts

Explain the difference between DISTINCT and GROUP BY with a self-contained demo, HAVING filters, and a correlated-subquery plan comparison.

Read More
Registry Editor displaying SQL Server configuration settings.

SQL SERVER – Service Pack Error – The User Data directory in the registry is not valid. Verify DefaultData key under the instance hive points to a valid directory

May 16, 2015
Pinal Dave
SQL Tips and Tricks
SQL Error Messages

Service pack 2 on SQL Server 2012 failed with: The User Data directory in the registry is not valid. Here is how the DefaultData registry key caused it.

Read More
SQL SERVER - WARNING - SQL Server Has Encountered N Occurrence(s) of I/O Requests Taking Longer Than 15 Seconds

SQL SERVER – WARNING – SQL Server Has Encountered N Occurrence(s) of I/O Requests Taking Longer Than 15 Seconds

May 15, 2015
Pinal Dave
SQL Tips and Tricks
SQL Counter, SQL DMV, SQL Error Messages, SQL Log, SQL Server

Seeing ‘I/O requests taking longer than 15 seconds’ in the ERRORLOG? Here is what this common warning means and where to look for the slow disk behind it.

Read More
SQL SERVER - SSIS and How to Load Binary Large Objects, or Blobs - Notes from the Field #080

SQL SERVER – SSIS and How to Load Binary Large Objects, or Blobs – Notes from the Field #080

May 14, 2015
Pinal Dave
SQL Tips and Tricks
DotNet, Notes from the Field, SQL Server, SSIS

In Notes from the Field #080, Andy recalls his first project loading product images with SSIS and explains how to load binary large objects, or Blobs.

Read More
SQL SERVER - PowerShell Script - When Was SQL Server Last Restarted?

SQL SERVER – PowerShell Script – When Was SQL Server Last Restarted?

May 13, 2015
Pinal Dave
SQL Tips and Tricks
PowerShell

A simple PowerShell script that reads the ErrorLog to answer a common question: when was SQL Server last restarted? Tips to improve it are welcome.

Read More
Field new_page_page_id Value.

SQL SERVER – Identify Page Splits Using Extended Events in SQL Server

May 12, 2015
Pinal Dave
SQL Tips and Tricks
SQL Extended Events

How can you track page splits inside SQL Server? PerfMon gives you a count, but here is how to see each of the page splits using Extended Events.

Read More
SQL Server DTA tuning options.

SQL SERVER – Introduction to Database Engine Tuning Advisor (a.k.a. DTA)

May 11, 2015
Pinal Dave
SQL Performance

An introduction to Database Engine Tuning Advisor, or DTA, the tool that ships with SQL Server client tools and suggests indexes and statistics.

Read More
An empty wooden counting rail is reset with one new bead at its starting end

Interview Question of the Week #019 – How to Reset Identity of Table

May 10, 2015
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts

Reset identity values with DBCC CHECKIDENT, distinguish DELETE from TRUNCATE, and prove that identity alone does not prevent duplicates.

Read More
SQL SERVER - Script: Current IO Related Waits on SQL Server

SQL SERVER – Script: Current IO Related Waits on SQL Server

May 9, 2015
Pinal Dave
SQL Tips and Tricks
SQL Wait Stats

A friend’s SQL Server in an Azure VM slowed down suddenly. Here is my handy script using sys.dm_io_pending_io_requests to see current IO related waits.

Read More
Error dialog for a failed 'helpmsg' command in Windows command prompt.

SQL SERVER – Backup Failure – Error: 3203, Severity: 16, State: 1

May 8, 2015
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Error Messages

A transaction log backup failed with Error: 3203, saying the read on the LDF file failed with Incorrect function. Here is what I found.

Read More
Previous 1 … 263 264 265 266 267 268 269 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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