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
SQL SERVER - 2008 - Inline Variable Assignment

SQL SERVER – 2008 – Inline Variable Assignment

June 15, 2008
Pinal Dave
SQL Performance
SQL Scripts

SQL Server 2008 adds inline variable assignment, so DECLARE @MyVar INT = 5 works in one line. I compare it with the SQL Server 2005 way of DECLARE then SET.

Read More
SQL SERVER - Order Of Column In Index

SQL SERVER – Order Of Column In Index

June 2, 2008
Pinal Dave
SQL Performance
SQL Index, SQL Joins, SQL Scripts

Adding more columns does not make an index better. The order of column in index matters most, since an index is used only when its first column is in the query.

Read More
SQL SERVER - 2005 - Twelve Tips For Optimizing Sql Server 2005 Query Performance

SQL SERVER – 2005 – Twelve Tips For Optimizing Sql Server 2005 Query Performance

May 21, 2008
Pinal Dave
SQL Performance
Best Practices, Database

Twelve tips for better SQL Server 2005 query performance, from execution plans and covering indexes to avoiding cursors, using APPLY and archiving old data.

Read More
SQL SERVER - Ideal TempDB FileGrowth Value

SQL SERVER – Ideal TempDB FileGrowth Value

May 17, 2008
Pinal Dave
SQL Performance
SQL Server, SQL TempDB

What is a good TempDB FileGrowth value? Here are simple size-based guidelines, from 10 MB growth for small files to 10 percent for large ones.

Read More
SQL SERVER - Orphaned MS DTC Transaction Information

SQL SERVER – Orphaned MS DTC Transaction Information

May 14, 2008
Pinal Dave
SQL Performance
SQL Error Messages, SQL Scripts

An orphaned MS DTC transaction kept crashing our IIS application pool. A quick script on sys.syslockinfo shows if you have one, and a Microsoft hotfix solved it.

Read More
A library card catalogue drawer pulled open beside a long shelf of books

What Is an Index in SQL Server?

April 28, 2008
Pinal Dave
SQL Performance
Best Practices, SQL Index, SQL Performance, SQL Server

An index in SQL Server took one query from 33,517 reads to 66 on the same table. What clustered and nonclustered really mean, why every index is paid for on the way in, and how to find the ones nobody uses.

Read More
SQL SERVER - Optimization Rules of Thumb - Best Practices - Reader's Article

SQL SERVER – Optimization Rules of Thumb – Best Practices – Reader’s Article

April 26, 2008
Pinal Dave
SQL Performance
Best Practices, Database

Reader Praveen Barath adds his own query optimization tips to my rules of thumb: tune only working code, write repeated statements identically and more.

Read More
Previous 1 … 111 112 113 114 115 116 117 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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