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
Gouache painting of records coming together at a join

SQL SERVER – INNER JOIN Returning More Records than Exists in Table

February 9, 2012
Pinal Dave
SQL Puzzle
SQL Joins, SQL Scripts

Can an INNER JOIN returning more records than exist in a table be right? Jeff thought it was a bug. Our chat shows why it is possible and natural.

Read More
Gouache painting of a database character beside a stopwatch

Convert Subquery to CTE: SQL in Sixty Seconds #001

February 8, 2012
Pinal Dave
SQL Video
CTE, SQL in Sixty Seconds, SQL Scripts, SQL Sub Query

You can convert subquery to CTE syntax by naming the inner query and using that name in the outer query. The first SQL in Sixty Seconds episode shows the change. My tests on SQL Server 2025 show the result stays the same, and that a CTE used twice reads the table twice.

Read More
SQL SERVER - Installation Log Summary File Location - 2012 - 2008 R2

SQL SERVER – Installation Log Summary File Location – 2012 – 2008 R2

February 7, 2012
Pinal Dave
SQL Tips and Tricks
SQL Error Messages

A new DBA on his first day could not find the SQL Server installation log summary. Here is the file location for SQL Server 2012 and 2008 R2.

Read More
SQL SERVER - ERROR: FIX - Database diagram support objects cannot be installed

SQL SERVER – ERROR: FIX – Database diagram support objects cannot be installed

February 6, 2012
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server

Database diagram support objects cannot be installed because this database does not have a valid owner. Here is the quick fix I used on a friend’s database.

Read More
A lifeboat sliding down its slipway into a calm harbor during a practice launch, crew seen from behind.

Testing a Failover Before You Need One

February 5, 2012
Pinal Dave
SQL Tips and Tricks
AlwaysOn, DBA, SQL High Availability, SQL Server Cluster, Testing

Testing a failover reveals connection, data, job, and recovery gaps before an outage; learn to plan a SQL Server drill and record the result.

Read More
SQL SERVER - Finding Count of Logical CPU using T-SQL Script - Identify Virtual Processors

SQL SERVER – Finding Count of Logical CPU using T-SQL Script – Identify Virtual Processors

February 4, 2012
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL Server

A friend needed to count Virtual Processors available to SQL Server 2000. Scripts for 2000 with xp_msver, and for 2005 to 2012 with sys.dm_os_sys_info.

Read More
Gouache painting: a hall so full that spare chairs line the back wall, every chair holding a notebook and a cloth bag, one bag vermilion

SQL Saturday #116: The First SQL Saturday in India

February 3, 2012
Pinal Dave
SQLAuthority News
Conferences, SQL PASS, SQL Saturday

SQL Saturday #116 was the first SQL Saturday in India, and it was a huge success. We filled every seat, hosted two technical tracks with six speakers and ended with a book signing. Here is my recap of the day, with photographs.

Read More
Gouache painting of a rocking chair with a vermilion shawl and a book on its seat, beside a small film projector casting warm light on a wall.

SQL Server Questions and Answers: The Movie My Grandma Asked For

February 2, 2012
Pinal Dave
SQL Interview Questions and Answers
Life Lessons, Pluralsight, SQL Book, SQL Training

SQL Server Questions and Answers began as a book I carried to my grandma for blessings. Grandma’s question about a movie inspired a video course.

Read More
A winding garden path with two small houses along it, the nearer older house with a red front door.

Slowly Changing Dimension Quiz: Type 1 or Type 2?

February 1, 2012
Pinal Dave
SQL Puzzle
Business Intelligence, Data Warehousing, ETL

This Slowly Changing Dimension Quiz asks which type to use when a customer moves from Denver to Austin and sales before the move must stay under Denver. The answer is Type 2. A tested script runs Type 1 and Type 2 side by side, checks the move date and shows both reports.

Read More
A long glass greenhouse divided into sections, with only its red-framed middle door lit from inside.

Table Partitioning Quiz: When Does It Make a Query Faster?

January 31, 2012
Pinal Dave
SQL Puzzle
Execution Plan, SQL Index, SQL Performance, Table Partitioning

This Table Partitioning Quiz asks whether a query for last month runs faster once a sales table is partitioned by month. The answer is only when the filter lets SQL Server skip partitions. A tested script shows the partition count, the reads, and a partition SWITCH.

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

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