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
Fill Factor.

SQL SERVER – Change Default Fill Factor For Index

May 25, 2007
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server, SQL Server Configuration

The Default Fill Factor in SQL Server is 0. Change it with sp_configure to leave free space on index pages and reduce page splits. I like mine at 90.

Read More
SQL SERVER - 2005 Understanding Trigger Recursion and Nesting with examples

SQL SERVER – 2005 Understanding Trigger Recursion and Nesting with examples

May 18, 2007
Pinal Dave
SQL Performance
SQL Scripts, SQL Server Security, SQL Stored Procedure, SQL Trigger

How trigger recursion and nesting work in SQL Server 2005: triggers nest up to 32 levels, recursive triggers fire themselves, and both can be turned off.

Read More
SQL SERVER - Disable Index - Enable Index - ALTER Index

SQL SERVER – Disable Index – Enable Index – ALTER Index

May 17, 2007
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server DBCC

When DTS, BCP or BULK INSERT needs an index out of the way, I prefer to disable index with ALTER INDEX and enable it again with REBUILD. AdventureWorks example.

Read More
SQL SERVER - Fix : Error 1205 : Transaction (Process ID) was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction

SQL SERVER – Fix : Error 1205 : Transaction (Process ID) was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction

May 16, 2007
Pinal Dave
SQL Performance
SQL Error Messages, SQL Scripts, SQL Server

Fix : Error 1205 : Transaction (Process ID) was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Read More
A lamp lighting an armchair with three books at hand, inside a dim room of tall bookshelves.

Estimating How Much Memory SQL Server Needs

May 10, 2007
Pinal Dave
SQL Performance
SQL Memory, SQL Performance, SQL Server, SQL Server Configuration

How much memory SQL Server needs depends on the active working set, grants, and host headroom; learn to measure pressure and avoid fixed ratios.

Read More
A small teacup lost inside a huge box of packing straw, next to a snug little box holding a matching cup.

Data Types That Waste Space

May 10, 2007
Pinal Dave
SQL Performance
Best Practices, SQL Data Storage, SQL Datatype, SQL Index, SQL Server

Data types that waste space include oversized integers, blanket nvarchar(max), and unnecessary datetime2 precision; measure before changing.

Read More
Unmarked auger bits arranged in a wooden stand with one empty hole and a hand checking the tools.

Index Optimization Checklist: A Printable One-Page Guide

May 8, 2007
Pinal Dave
SQL Performance
Best Practices, Cheatsheet, Clustered Index, SQL Index

The twelve things I ask a junior DBA to check before I touch a slow query, with three quick proofs you can run yourself.

Read More
Previous 1 … 120 121 122 123 124 125 126 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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