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 hand lifting a bunch of grapes by its top stem, the branching stems hanging open above a red cloth

Translating Oracle CONNECT BY Queries to Recursive CTEs

February 19, 2012
Pinal Dave
SQL Tips and Tricks
CTE, Oracle, SQL Migration, SQL Server

Translate CONNECT BY into recursive CTEs with root selection, depth, paths, sibling ordering, cycle checks, and a recursion limit.

Read More
Cannot find user 'sqlauthority.

SQL SERVER – Case Sensitive Database and Database User – Fix: Error: 15151 – Cannot find the user , because it does not exist or you do not have permission.

February 18, 2012
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server Security

Jeff hit Error 15151, cannot find the user, even though the user existed. The cause was a case sensitive database, and here is the fix.

Read More
puzzle

SQL SERVER – Solution Part 2 – A Quick Puzzle on SQL JOIN and NULL – SQL Brain Teaser

February 17, 2012
Pinal Dave
SQL Puzzle
SQL Joins, SQL NULL, SQL Scripts, SQL Server

Part 2 of the solution to my puzzle on SQL Join and NULL. Readers still email me answers every day, so here are more of the good ones they sent.

Read More
A harbor seen from above with a grid of mooring buoys, small boats tied to most of them and a few buoys floating empty.

Numbers Table vs GENERATE_SERIES: Building Rows on Demand

February 16, 2012
Pinal Dave
SQL Tips and Tricks
SQL System Table, SQL Table Operation, Table Partitioning, Temp Table

Learn numbers table in SQL Server with practical examples, clear checks, common traps, and guidance for your own database.

Read More
Gouache painting of document cards following a branching wooden track, with one queue blocked by a red barrier and another reaching an output drawer.

T-SQL Errors and Reactions in SQL Server: SQL in Sixty Seconds #002

February 15, 2012
Pinal Dave
SQL Video
SQL Error Messages, SQL in Sixty Seconds, SQL Scripts, SQL Transactions

T-SQL errors and reactions are the subject of this early SQL in Sixty Seconds episode with Rick Morelan. The tests here show which errors stop one statement, which stop the whole batch, and how XACT_ABORT, TRY CATCH and THROW change the reaction.

Read More
Gouache painting of a small wooden handcart piled with grain sacks beside a long line of identical grain wagons stretching down a country track, one wagon painted vermilion, in soft morning light.

What Is Big Data? A Simple Explanation for Database People

February 14, 2012
Pinal Dave
SQL Tips and Tricks
Data Warehousing, Database, SQL Data Storage

What Is Big Data? It is the point where data outgrows one machine, and the fix is to scale out. This post explains the failures of one server and walks through 40 TB split across 8 nodes.

Read More
A pasta cutter slicing a sheet of dough into ribbons of equal width, ragged edge trimmings piled aside.

Reading Fixed-Width Text Files With OPENROWSET and a Format File

February 13, 2012
Pinal Dave
SQL Tips and Tricks
CSV, File format, SQL Datatype, SQL Server

Read fixed-width text files with OPENROWSET and an XML format file, trim fields, validate conversions, and load only acceptable rows.

Read More
A tray of sand raked into even lines, a small rake on one corner and a few finger marks disturbing the pattern.

Resetting a Test Database With Database Snapshots

February 12, 2012
Pinal Dave
SQL Tips and Tricks
Snapshot, SQL Backup and Restore, SQL Server, Testing

Resetting a test database with SQL Server snapshots gives a fast baseline for repeatable tests; create, revert, and manage sparse files safely.

Read More
SQL SERVER - Solution - A Quick Puzzle on JOIN and NULL - SQL Brain Teaser

SQL SERVER – Solution – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser

February 11, 2012
Pinal Dave
SQL Puzzle
SQL Scripts

The solution to my quick puzzle on JOIN and NULL. Many readers said the puzzle had an error; it did not, and here is the answer that works.

Read More
SQL SERVER - A Quick Puzzle on JOIN and NULL - SQL Brain Teaser

SQL SERVER – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser

February 10, 2012
Pinal Dave
SQL Puzzle
SQL Scripts, SQL Server

A relaxing SQL Brain Teaser on INNER JOIN and NULL: set up a sample table, look at the result, and fill in the missing T-SQL that produces it.

Read More
Previous 1 … 386 387 388 389 390 391 392 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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