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 - Challenge - Puzzle - Usage of FAST Hint

SQL SERVER – Challenge – Puzzle – Usage of FAST Hint

November 26, 2010
Pinal Dave
SQL Puzzle

When does the FAST hint help? It asks SQL Server to return the first rows quickly, yet my tests showed no change in time. Can you find a good example?

Read More
SQL SERVER - Concat Function in SQL Server - SQL Concatenation

SQL SERVER – Concat Function in SQL Server – SQL Concatenation

November 25, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL String

Is there a CONCAT function in SQL Server? An attendee said MySQL and Oracle have one. I show how the plus operator joins strings, numbers and column values.

Read More
Gouache painting: three positions along a tack room wall

geometry STIsEmpty: Empty Shapes Are Different From SQL NULL

November 24, 2010
Pinal Dave
SQL Tips and Tricks
Spatial Database, SQL Function, SQL Scripts, SQL Server

geometry STIsEmpty tests whether an existing spatial instance has an empty point set. I keep that condition separate from SQL NULL. A missing database value and a present empty geometry are different inputs.

Read More
SQLAuthority News - SQLPASS Nov 8-11, 2010-Seattle - An Alternative Look at Experience

SQLAuthority News – SQLPASS Nov 8-11, 2010-Seattle – An Alternative Look at Experience

November 23, 2010
Pinal Dave
Personal
SQL PASS, SQLAuthority Author Visit

SQLPASS 2010 in Seattle was the best summit ever. Instead of the usual event report, here is an alternative look at my trip, travel stats and fun moments.

Read More
LIKE cardinality illustrated by clear jars containing different stone mixtures beside bowls on a rich apothecary bench.

LIKE Cardinality: String Statistics and Row Estimates

November 22, 2010
Pinal Dave
SQL Performance
SQL Performance, SQL Scripts, SQL Statistics

LIKE row estimates depend on the pattern, string statistics and compilation context. Compare estimated and actual matching rows in a controlled distribution, while keeping cardinality estimates separate from the chosen access path.

Read More
Database Properties - Perftest.

SQL SERVER – Change Database Access to Single User Mode Using SSMS

November 21, 2010
Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio

I showed before how to set single user mode with T-SQL before a backup. You can also set single user mode using SSMS, from the database properties page.

Read More
Small wooden practice blocks in varied shapes beside an open blank notebook on an oak table.

How to Practise SQL Without a Real Database

November 20, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

You can practise SQL with small invented tables, generated rows, and repeatable exercises without access to a company's production database.

Read More
A sunflower tied to a bamboo cane with twine knots marking its height, evenly spaced until one sits far higher.

Recording Table Row Counts Every Day

November 19, 2010
Pinal Dave
SQL Tips and Tricks
DBA, SQL Data Storage, SQL DMV, SQL Server Agent

Recording table row counts each day creates a useful SQL Server trend when a scheduled job, history table, and change review support it.

Read More
A hand turning the crank of a red barrel organ with its punched roll feeding

Replaying a Production Workload After Distributed Replay

November 18, 2010
Pinal Dave
SQL Performance
SQL Extended Events, SQL Server, SQL Upgrade, Testing

Capture a production workload with Extended Events and replay it on a restored copy using WorkloadTools or ostress after Distributed Replay.

Read More
The cover of a book.

SQL SERVER – History of SQL Server Database Encryption

November 17, 2010
Pinal Dave
SQL Tips and Tricks
SQL PASS, SQL Server Encryption, SQLAuthority Book Review

Michael Coles, co-author of Expert SQL Server 2008 Encryption, let me share his history of SQL Server database encryption, starting from SQL Server 2000.

Read More
Previous 1 … 436 437 438 439 440 441 442 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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