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 - 2005 Row Overflow Data Explanation

SQL SERVER – 2005 Row Overflow Data Explanation

June 23, 2007
Pinal Dave
SQL Performance
SQL Scripts, SQL Server Security, SQL String

Is 8060 bytes per row still the limit in SQL Server 2005? Yes, but varchar, nvarchar, varbinary, sql_variant and CLR types are excluded. That is row overflow data.

Read More
SQL SERVER - De-fragmentation of Database at Operating System to Improve Performance

SQL SERVER – De-fragmentation of Database at Operating System to Improve Performance

June 17, 2007
Pinal Dave
SQL Performance
Computer Network, DBA, SQL Index, SQL Scripts

Why does de-fragmentation of database files at the operating system level skip MDF files? SQL Server has them open, so stop the services first.

Read More
SQL SERVER - Explanation SQL SERVER Hash Join

SQL SERVER – Explanation SQL SERVER Hash Join

June 14, 2007
Pinal Dave
SQL Performance
SQL Joins

How a Hash Join works in two phases, build and probe, why it suits large data sets without indexes, and why it needs an equijoin predicate.

Read More
SQL SERVER - Fix : Error 8629 The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or image column and a clustering key at the same time.

SQL SERVER – Fix : Error 8629 The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or image column and a clustering key at the same time.

June 13, 2007
Pinal Dave
SQL Performance
SQL Error Messages, SQL Server

Error 8629 appears when one UPDATE changes a text or image column and a clustering key together. Here is why SQL Server blocks it and a fix.

Read More
SQL SERVER - Recovery Models and Selection

SQL SERVER – Recovery Models and Selection

June 13, 2007
Pinal Dave
SQL Performance
SQL Backup and Restore, SQL Coding Standards, SQL Data Storage, SQL Scripts, SQL Server Security

SQL Server offers three recovery models: full, simple and bulk-logged. Here is when to select each one, based on how much data loss you can accept.

Read More
SQL SERVER - LEN and DATALENGTH of NULL Simple Example

SQL SERVER – LEN and DATALENGTH of NULL Simple Example

June 12, 2007
Pinal Dave
SQL Performance
SQL Function, SQL NULL, SQL Scripts

A common mistake is checking LEN(@var) = 0 for a NULL value. LEN and DATALENGTH of NULL both return NULL, not zero, as this simple example shows.

Read More
SQL SERVER - 2005 Find Table without Clustered Index - Find Table with no Primary Key

SQL SERVER – 2005 Find Table without Clustered Index – Find Table with no Primary Key

May 26, 2007
Pinal Dave
SQL Performance
SQL Index, SQL Scripts

A query on sys.indexes to find every table without clustered index in a database, why heaps can slow you down, and how to pick a clustered key.

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

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