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 small sailboat crossing a bay, its curved wake showing how far the wind pushed it off a straight course.

Estimated and Actual Execution Plans

May 26, 2010
Pinal Dave
SQL Performance
Execution Plan, SQL Performance, SQL Server Management Studio, SQL Statistics

Estimated and actual execution plans answer different questions; compare compiled choices with runtime rows, warnings, and resource use.

Read More
A small wooden house beside a larger shared wooden shelter on a warm neutral tabletop.

Azure SQL Database and SQL Server: What Changes

May 25, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Compare Azure SQL Database with SQL Server, including jobs, cross-database access, monitoring, backup control, and operational responsibilities.

Read More
A full glass pitcher of water on a garden table, while behind it a hand holds a tin cup under a dripping wall tap.

Getting SQL Server Data Into Power BI

May 24, 2010
Pinal Dave
SQL Tips and Tricks
Business Intelligence, Data Visualization, Query Store, SQL Server, SQL View

Power BI can read SQL Server through Import or DirectQuery; stable views, folding, and workload checks keep the database responsive.

Read More
SQL SERVER – Check the Isolation Level with DBCC useroptions

SQL SERVER – Check the Isolation Level with DBCC useroptions

May 24, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL System Table, Transaction Isolation

What isolation level is your session using? Run DBCC useroptions to see it, along with dateformat, datefirst, language and other SET options.

Read More
Three leaf-pattern cloth samples mounted together in a wooden frame on a workshop bench.

Multi-Language Text: A Table Design for Translations

May 23, 2010
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Table Operation, Unicode

Multi-language text separates product identity from translated names. This test setup checks requested, fallback, and base names, Unicode text, duplicate tags, missing rows, and a precise blank policy.

Read More
Gouache painting: on a farm table stand a short crate and a tall crate

ISNULL Versus COALESCE: Return Length Can Change

May 22, 2010
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Server

ISNULL versus COALESCE can preserve different string widths. Make the intended replacement type explicit before characters are truncated.

Read More
SQL SERVER - Simple Example of Snapshot Isolation - Reduce the Blocking Transactions

SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions

May 21, 2010
Pinal Dave
SQL Performance
SQL Scripts, Transaction Isolation

Snapshot Isolation has been in SQL Server since 2005, yet many shops still skip it. A simple example shows how it can reduce blocking transactions.

Read More
Folding chairs set out in a circle in a community hall with a coffee urn on a side table.

SQLAuthority News – Professional Development and Community

May 20, 2010
Pinal Dave
SQLAuthority News
MVP, SQL Server, SQL User Group

Hyderabad Techies asked me to open their 16-day online event, TECH THUNDERS, with a keynote. My first talk on Professional Development, in just 15 minutes.

Read More
A hand searching a tin of jumbled buttons for a matching set, an empty compartment tray beside it.

Indexing Foreign Keys

May 19, 2010
Pinal Dave
SQL Performance
SQL Constraint and Keys, SQL Index, SQL Lock, SQL Server

Indexing foreign keys can speed joins and parent deletes when child-side indexes are missing; learn how to find gaps and test write tradeoffs.

Read More
A plain toolbox beside a closed notebook and small hourglass on a neatly arranged wooden desk.

What a DBA Actually Does All Day

May 18, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Understand what a DBA does across incidents, prevention, projects, and automation, with practical checks that connect daily work to business risk.

Read More
Previous 1 … 455 456 457 458 459 460 461 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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