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 presentation in Bangalore.

SQLAuthority News – Presented at Bangalore DevCon August 4, 2012

August 18, 2012
Pinal Dave
SQLAuthority News
SQLAuthority Author Visit

Notes from Bangalore DevCon 2012: two tracks, 12 sessions and more than 140 attendees, plus my own session on SQL tips and tricks for web developers.

Read More
SQL Server Relationships.

SQL SERVER – Curious Case of Disappearing Rows – ON UPDATE CASCADE and ON DELETE CASCADE – T-SQL Example – Part 2 of 2

August 17, 2012
Pinal Dave
SQL Tips and Tricks

Part 2 of the disappearing rows story: a T-SQL example showing how ON UPDATE CASCADE and ON DELETE CASCADE made my friend’s rows vanish, no virus involved.

Read More
Magnifying glass silhouette.

SQL SERVER – Curious Case of Disappearing Rows – ON UPDATE CASCADE and ON DELETE CASCADE – Part 1 of 2

August 16, 2012
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Server

Rows kept vanishing from a product table with no DELETE anywhere in the code. Part 1 of a puzzle that leads to ON UPDATE CASCADE and ON DELETE CASCADE.

Read More
A strip of stitched buttonholes shows distinct gaps between successive openings in cream cloth

Measuring Time Between Workflow Steps With LEAD

August 15, 2012
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Order By, SQL Reports

Status rows hold timestamps, not durations. I use LEAD to measure each step, keep unfinished steps NULL, and show why zero ruins your averages.

Read More
A cloakroom rail of identical dark coats, each hanger carrying a small tag in a different colour.

What Is a Primary Key, and What Happens Without One?

August 14, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Index, SQL Server

A primary key is the promise that every row can be told apart. Why NULL is refused, what a table without one actually costs you, how it differs from a unique constraint, and when to choose a natural key over a made up one.

Read More
Open poultry shears sit around an empty gap beside a cut piece of chicken on a clean board

CHECK Constraints and NULL: Why Unknown Passes the Test

August 13, 2012
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Error Messages, SQL NULL, SQL Table Operation

Why does a CHECK (Quantity > 0) happily store a row with no quantity? Three-valued logic, a small demo, and the NOT NULL fix.

Read More
SQL SERVER - ERROR: FIX using Compatibility Level - Database diagram support objects cannot be installed because this database does not have a valid owner - Part 2

SQL SERVER – ERROR: FIX using Compatibility Level – Database diagram support objects cannot be installed because this database does not have a valid owner – Part 2

August 12, 2012
Pinal Dave
SQL Tips and Tricks
SQL Error Messages

Database diagram support objects cannot be installed on a database upgraded from SQL Server 2005? This time the fix was the compatibility level.

Read More
A pasta roller holds fixed rollers while dough must pass through successive connected stages

INNER HASH JOIN: Why a Table Join Hint Also Fixes Join Order

August 11, 2012
Pinal Dave
SQL Performance
Execution Plan, Query Hint, SQL Joins, SQL Performance

A join hint in the FROM clause quietly fixes the join order. I show the warning, three plans side by side, and the softer query-level alternative.

Read More
A nutcracker rests beside one walnut kernel and a much larger collection of its cracked shell pieces

Checking XML Index Size Against the Table It Belongs To

August 10, 2012
Pinal Dave
SQL Tips and Tricks
SQL Data Storage, SQL DMV, SQL Index, SQL XML

An XML index can outweigh the table it serves. Here is how I measure each XML structure next to the base table, and what to test before dropping one.

Read More
A garlic press handles one clove through its single chamber while whole garlic bulbs stay outside

Updatable Views: When INSERT and UPDATE Work Through a View

August 9, 2012
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Error Messages, SQL Table Operation, SQL View

A view is only a doorway to the table behind it. I show which writes get through, which get rejected, and why CHECK OPTION earns its place.

Read More
Previous 1 … 368 369 370 371 372 373 374 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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