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
Database Browser.

SQL SERVER – Find Row Count in Table – Find Largest Table in Database – Part 2

September 8, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts

An improved script to find row count in table for every table and spot the largest table in the database, now with the schema name, thanks to Ameena.

Read More
Operation Delete and Delete Operation.

SQL SERVER – Index Levels and Delete Operations – Page Level Observation

September 7, 2010
Pinal Dave
SQL Interview Questions and Answers
SQL Index, SQL Scripts

When you delete data from a table, does SQL Server reduce its size? A page level look at index levels and delete operations, corrected with Hrvoje’s help.

Read More
SQL SERVER - Index Created on View not Used Often - Limitation of the View 3

SQL SERVER – Index Created on View not Used Often – Limitation of the View 3

September 6, 2010
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL View

An Index Created on a view does not always stop queries from reading the base table. Limitation 3 of views, shown with a simple example.

Read More
Gouache painting: three young apple trees stand in a row in a grassy orchard

FOR JSON PATH: Choose Whether NULL Properties Appear

September 5, 2010
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

FOR JSON PATH omits NULL properties by default. Compare INCLUDE_NULL_VALUES with missing properties and empty strings in a complete output example.

Read More
Three small bouquets sharing the same flowers in different mixes, a red poppy in two of them

Tagging With a Many-to-Many Table: Storing and Querying Hashtags

September 4, 2010
Pinal Dave
SQL Tips and Tricks
Database, Normalization, SQL Constraint and Keys, SQL Joins

Store hashtags in a tag and bridge table, normalize input, query any or all requested tags, and count weekly trends without scans.

Read More
SQL SERVER - Soft Delete - IsDelete Column - Your Opinion

SQL SERVER – Soft Delete – IsDelete Column – Your Opinion

September 3, 2010
Pinal Dave
SQL Tips and Tricks

Soft delete with an IsDelete column marks rows as deleted but keeps them. Michael J Swart dislikes it, and I agree. I share a similar story and ask your opinion.

Read More
A kitchen pot rack tilting because every heavy pan hangs from one end, the other end's hooks empty.

Data, Log and tempdb File Placement: Checking Where Everything Lives

September 2, 2010
Pinal Dave
SQL Tips and Tricks
DBA, Disk, SQL Data Storage, SQL TempDB, Transaction Log

Check file placement for data, logs, and tempdb, inspect volume free space, and plan a Windows file move with a verified recovery path.

Read More
SQLAuthority News - Fathers and Daughters

SQLAuthority News – Fathers and Daughters

September 1, 2010
Pinal Dave
SQLAuthority News

My daughter turns one today and I feel so lucky to be a father of daughter. A few words on the special bond between fathers and daughters, with her photos.

Read More
A harbor post notched with flood marks, a hand adding a fresh red notch

Keeping a Change Log for Every Database

August 31, 2010
Pinal Dave
SQL Tips and Tricks
DBA, Schema, SQL Audit, SQL Documentation

A change log for every database records what changed, when, why, and by whom, with a simple table and a habit of updating it.

Read More
A crate of blue ceramic bowls, a separate sample bowl and a clay inspection token.

Return Codes: Keep Procedure Status Separate From Data

August 30, 2010
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Stored Procedure

Return codes carry procedure status separately from application values. This private demonstration compares result sets, captured output and omitted OUTPUT. It also separates an optional no-work request from a genuine raised error.

Read More
Previous 1 … 444 445 446 447 448 449 450 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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