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
Gouache painting of a workshop pegboard of tool outlines with one empty outline and a red hammer on the floor

Missing Index Script: Read the Suggestions Before You Create

January 3, 2011
Pinal Dave
SQL Performance
SQL DMV, SQL Index, SQL Scripts

This Missing Index Script ranks the indexes SQL Server wishes it had by a plain score and builds a CREATE INDEX statement for each. Read the key order, the INCLUDE list and the overlap before you create one. A garden center orders table shows the logical reads drop from 3,138 pages to 3.

Read More
SQL SERVER - Reduce the Virtual Log Files (VLFs) from LDF file

SQL SERVER – Reduce the Virtual Log Files (VLFs) from LDF file

January 2, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts, VLF

Too many virtual log files are bad for your LDF. Here is a simple script to reduce the virtual log files right away with a log backup and a shrink.

Read More
An orchard gate in early spring with a red ribbon tied to the post

Fiscal Years That Do Not Start in January

January 1, 2011
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Reports, SQL Scripts, SQL Server

Compute fiscal years and quarters from an April start, build indexed date boundaries, and store a fiscal calendar for repeatable reports.

Read More
SQL SERVER - Detect Virtual Log Files (VLF) in LDF

SQL SERVER – Detect Virtual Log Files (VLF) in LDF

December 30, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts, VLF

A large LDF file is made of many small Virtual Log Files (VLFs). Here is how to detect them with DBCC LOGINFO and see which ones are active.

Read More
SQL SERVER - Plan Cache and Data Cache in Memory

SQL SERVER – Plan Cache and Data Cache in Memory

December 28, 2010
Pinal Dave
SQL Performance
SQL Memory, SQL Scripts

Two scripts I share with clients all the time: they show the plan cache and data cache in memory, with cached plans by size and cached pages by table.

Read More
Table header.

SQL SERVER – ORDER BY ColumnName vs ORDER BY ColumnNumber

December 27, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts

I strongly favor ORDER BY ColumnName over ORDER BY ColumnNumber. The performance is the same, but here is why column numbers are risky in real code.

Read More
SQL Server query window.

SQL SERVER – Server Side Paging in SQL Server Denali – Part2

December 26, 2010
Pinal Dave
SQL Performance
SQL Paging, SQL Scripts

Part 2 of server side paging in SQL Server Denali: a reader keeps rows per page and page number in a table, and OFFSET and FETCH can read them from there.

Read More
Previous 1 … 239 240 241 242 243 244 245 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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