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 - Order of Columns in Update Statement Does not Matter

SQL SERVER – Order of Columns in Update Statement Does not Matter

March 5, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts

Does the order of columns in UPDATE statements matter? No. Setting Col1 before Col2 or the other way round gives the same result in SQL Server.

Read More
Illustrated cover: TRUNCATE Can Roll Back

SQL SERVER – Rollback TRUNCATE Command in Transaction

March 4, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, Transaction Log

Many believe TRUNCATE cannot be rolled back. It can. Here is a Rollback TRUNCATE command example inside a transaction, and why TRUNCATE is logged.

Read More
SQL SERVER - Performance Comparison - INSERT TOP (N) INTO Table - Using Top with INSERT

SQL SERVER – Performance Comparison – INSERT TOP (N) INTO Table – Using Top with INSERT

March 3, 2010
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server

A Performance Comparison of INSERT TOP (N) INTO a table versus INSERT with SELECT TOP (N). The first is clearly faster, but the two can give very different results.

Read More
Test compression data and page compression.

SQL SERVER – Data and Page Compressions – Data Storage and IO Improvement

March 1, 2010
Pinal Dave
SQL Performance
SQL Data Storage, SQL Index, SQL Scripts

SQL Server 2008 data and page compressions cut disk space and I/O. I explain ROW and PAGE compression and how to set them on tables, indexes and partitions.

Read More
Insert alogn with Top (N)

SQL SERVER – INSERT TOP (N) INTO Table – Using Top with INSERT

February 27, 2010
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts

INSERT TOP (N) INTO a table is not the same as INSERT with SELECT TOP (N). My example from a client training shows how the two methods differ.

Read More
SQL SERVER - Introduction to Rollup Clause

SQL SERVER – Introduction to Rollup Clause

February 24, 2010
Pinal Dave
SQL Tips and Tricks
Business Intelligence, SQL Scripts, SQL Server

An introduction to the Rollup Clause in SQL Server, which aggregates at several levels of a hierarchy. A population table by country, state and city shows how.

Read More
Gouache painting: on a dyer's table, a slate-blue silk square partly overlaps a cream one, the shared corner showing a blended deeper tone while each square extends beyond it

geometry STOverlaps: Intersection Alone Is Not Enough

February 22, 2010
Pinal Dave
SQL Tips and Tricks
Spatial Database, SQL Function, SQL Scripts, SQL Server

geometry STOverlaps asks a narrower question than whether two shapes share any points. I test equal and contained regions alongside a partial overlap. Those intersecting cases do not all satisfy the method’s overlap definition.

Read More
Previous 1 … 263 264 265 266 267 268 269 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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