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 - Interview Questions and Answers - Frequently Asked Questions - Complete Downloadable List - Day 0 of 31

SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Complete Downloadable List – Day 0 of 31

July 1, 2011
Pinal Dave
SQL Interview Questions and Answers
SQL Documentation, SQL Download

The complete downloadable list of my 31-day series of SQL Server interview questions and answers, with a free PDF for offline review at the end.

Read More
A ski boot buckle stays on the same adjustment tooth despite a small pull on its strap

The real Data Type: Seven Digits of Precision and Overflow

June 30, 2011
Pinal Dave
SQL Tips and Tricks
Mathematics, SQL Data Storage, SQL Datatype, SQL Error Messages

Four bytes look like a bargain until a total comes out wrong. Watch real round, overflow and drift, then decide when decimal is the safer pick.

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
SQL SERVER - T-SQL Scripts to Find Maximum between Two Numbers

SQL SERVER – T-SQL Scripts to Find Maximum between Two Numbers

June 26, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts

A SQL enthusiast at the airport asked for a simple way to find maximum between two numbers. Here is his clever ABS formula and my CASE version.

Read More
A brass tuning fork on a piano lid, with a violin, a cello and a guitar leaning on chairs nearby in a rehearsal room.

Tabular Models for the SQL Developer

June 25, 2011
Pinal Dave
SQL Tips and Tricks
Business Intelligence, Data Warehousing, SQL Analysis Services, SQL Server, SQL View

Tabular models for the SQL developer add relationships, measures, security, and reusable semantics above SQL tables; learn when a view is enough.

Read More
A wooden abacus on a market stall counter, a hand sliding one red bead across for the day's final sale.

Summary Tables: Keeping Pre-Aggregated Totals Current

June 24, 2011
Pinal Dave
SQL Tips and Tricks
Data Warehousing, SQL Server, SQL Server Agent, SQL Trigger, SQL View

Keep summary tables current with changed-day rebuilds, handle late arrivals and deletes, and reconcile stored totals against detail.

Read More
SQLAuthority News - Ahmedabad Tech Ed On Road June 11, 2011 - A Grand Success of Community Tech Days

SQLAuthority News – Ahmedabad Tech Ed On Road June 11, 2011 – A Grand Success of Community Tech Days

June 23, 2011
Pinal Dave
SQLAuthority News
SQL User Group, SQLAuthority Author Visit

Over 500 people packed the Ahmedabad Tech Ed On Road on June 11, 2011, so we found 150 more chairs. Here is how this Community Tech Days went.

Read More
SQL SERVER - SSAS - Multidimensional Space Terms and Explanation

SQL SERVER – SSAS – Multidimensional Space Terms and Explanation

June 22, 2011
Pinal Dave
SQL Tips and Tricks
Business Intelligence

At a Tech Ed On Road session I was asked to explain multidimensional space in simple words. Here are dimension, member, value, attribute and size.

Read More
Previous 1 … 413 414 415 416 417 418 419 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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