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 two groups connecting puzzle pieces over a bridge

SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 16 of 31 – CTE- Joins

July 16, 2011
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server

CTE and joins begin Day 16 of the original interview series. The ten questions remain with corrected examples and clearer answers about XML, CLR, synonyms, and locking.

Read More
Interview

Interview Questions and Answers – FAQ Day 14 of 31

July 14, 2011
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server

FAQ Day 14 of my interview series starts with the basic functions of the master, msdb, model, tempdb and resource databases in SQL Server 2008.

Read More
SQL SERVER - Query to Find Duplicate Indexes - Script to Find Redundant Indexes

SQL SERVER – Query to Find Duplicate Indexes – Script to Find Redundant Indexes

July 13, 2011
Pinal Dave
SQL Performance
SQL Index, SQL Scripts

Duplicate indexes are pure overhead on every insert, update and delete. Here is my script to find duplicate and overlapping indexes so you can review them.

Read More
SQL SERVER - Interview Questions and Answers - Frequently Asked Questions - Day 11 of 31

SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 11 of 31

July 11, 2011
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts

Frequently Asked Questions Day 11: do table and column aliases affect performance, and what is the difference between CHAR and VARCHAR?

Read More
Statistics

SQL SERVER – Find Details for Statistics of Whole Database

June 29, 2011
Pinal Dave
SQL Performance
SQL DMV, SQL Scripts, SQL Server, SQL Statistics

Need statistics of whole database in one view? My script uses DMVs instead of the deprecated sp_helpstats and shows each stat, column and last update.

Read More
Two loose blue ceramic beads beside six woven pads holding differently colored beads and pebbles.

CROSS JOIN: Duplicate Inputs Multiply the Result

June 28, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Scripts, SQL Server

CROSS JOIN multiplies row counts, including repeated labels. Keep source identifiers and grouped pair counts visible while checking result grain.

Read More
Error dialog explaining why a query does not throw an error.

SQL SERVER – Puzzle Involving NULL – Resolve – Error – Operand data type void type is invalid for sum operator

June 27, 2011
Pinal Dave
SQL Puzzle
SQL NULL, SQL Operator, SQL Scripts, SQL Server

SELECT SUM over a lone NULL throws Msg 8117: Operand data type void type is invalid for sum operator. Here is why it happens and how ISNULL fixes it.

Read More
Previous 1 … 226 227 228 229 230 231 232 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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