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 pile of unsorted paper on a desk beside a neatly filed drawer with tabs

What Is a Heap in SQL Server?

May 4, 2007
Pinal Dave
SQL Performance
Best Practices, SQL Index, SQL Performance, SQL Server

A heap in SQL Server is a table with no clustered index. Forwarded records pushed one count from 11,113 reads to 199,844, and a single REBUILD put it back. When a heap is fine and when it is not.

Read More
SQL SERVER - 2005 TOP Improvements/Enhancements

SQL SERVER – 2005 TOP Improvements/Enhancements

May 2, 2007
Pinal Dave
SQL Performance
SQL Scripts

SQL Server 2005 brings two enhancements to the TOP clause: pass a variable or sub-query as the TOP value, and use TOP in INSERT, UPDATE and DELETE.

Read More
SQL SERVER - FIX : ERROR : Msg 3159, Level 16, State 1, Line 1 - Msg 3013, Level 16, State 1, Line 1

SQL SERVER – FIX : ERROR : Msg 3159, Level 16, State 1, Line 1 – Msg 3013, Level 16, State 1, Line 1

April 30, 2007
Pinal Dave
SQL Performance
SQL Backup and Restore, SQL Error Messages, SQL Scripts, SQL Server Security

Msg 3159 says the tail of the log was not backed up, then Msg 3013 ends RESTORE DATABASE. A script that worked in SQL Server 2000 failed in 2005, and here is why.

Read More
SQL SERVER - Explanation SQL SERVER Merge Join

SQL SERVER – Explanation SQL SERVER Merge Join

April 28, 2007
Pinal Dave
SQL Performance
SQL Joins, SQL Scripts

What a Merge Join needs and when it is fast: two sorted inputs with matching column types. Presorted B-tree indexes make it quick, extra sorts make it costly.

Read More
SQL SERVER - SELECT vs. SET Performance Comparison

SQL SERVER – SELECT vs. SET Performance Comparison

April 27, 2007
Pinal Dave
SQL Performance
SQL Download, SQL Scripts, SQL Server Security

SELECT vs. SET for local variables: SELECT can assign several at once and runs faster in a loop, while SET is the ANSI standard and assigns one at a time.

Read More
SQL SERVER - 2005 Take Off Line or Detach Database

SQL SERVER – 2005 Take Off Line or Detach Database

April 25, 2007
Pinal Dave
SQL Performance
SQL Scripts

To take off line a database in SQL Server 2005, use ALTER DATABASE SET OFFLINE with ROLLBACK AFTER 30 SECONDS or ROLLBACK IMMEDIATE instead of sp_dboption.

Read More
SQL SERVER - TRIM() Function - UDF TRIM()

SQL SERVER – TRIM() Function – UDF TRIM()

April 24, 2007
Pinal Dave
SQL Performance
SQL Function, SQL Scripts

SQL Server 2005 has LTRIM() and RTRIM() but no TRIM() function, so I wrote a simple UDF for SQL Server 2000 and 2005 that trims both sides. Video included.

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

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