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 whole watermelon beside one cut red slice on a cloth, a kitchen knife in front

Percent of Total With SUM() OVER() in One Query

September 18, 2010
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Reports, SQL Scripts, SQL Server

Calculate percent of total with SUM() OVER(), group and running shares, safe numeric division, and checks for zero totals.

Read More
Gouache painting: two shallow trays of turned wooden acorns, each holding both large and small acorns

REPLACE With COLLATE: Choose Case Matching Explicitly

September 17, 2010
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Function, SQL Server

REPLACE with COLLATE controls which substrings match. Preview case-dependent results before applying a text replacement policy.

Read More
Gold trophies on a dark shelf, like the MVP award for community experts

SQLAuthority News – What is an MVP? – How to become an MVP?

September 16, 2010
Pinal Dave
SQLAuthority News
MVP

What is an MVP, and how do you become one? Leaving the official FAQ aside, here is my own answer to what an MVP really is.

Read More
SQL SERVER – SELECT * and Adding Column Issue in View – Limitation of the View 4

SQL SERVER – SELECT * and Adding Column Issue in View – Limitation of the View 4

September 15, 2010
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL View

Why does SELECT * miss a new column? The adding column issue in view stays until you refresh it with sp_refreshview. Limitation of the view number 4.

Read More
Disabled Index Window.

SQL SERVER – Disabled Index and Index Levels and B-Tree

September 14, 2010
Pinal Dave
SQL Performance
SQL Index, SQL Scripts

For T-SQL Tuesday I write about my mentor Vinod Kumar and his interesting question, which leads to a disabled index, its index levels and the B-Tree.

Read More
SQL SERVER - What are Wait Types, Wait Stats and its Importance

SQL SERVER – What are Wait Types, Wait Stats and its Importance

September 13, 2010
Pinal Dave
SQL Tips and Tricks

What are wait types and wait stats, and why do they matter? A simple explanation of the three kinds of wait types, starting with resource waits.

Read More
SQL SERVER - Soft Delete Conversation - Your Opinion Needed

SQL SERVER – Soft Delete Conversation – Your Opinion Needed

September 12, 2010
Pinal Dave
SQL Performance
Best Practices

My soft delete post got great replies on both sides. Here are short abstracts from readers like Karen Lopez and Tyler Clendenin, and your input is welcome.

Read More
A luthier's hands checking a violin's slightly leaning bridge with a small gauge on a padded workbench.

Finding Misconfigurations With One Script

September 11, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, DBA, MAXDOP, SQL Scripts, SQL Server Configuration

Finding misconfigurations With One Script checks SQL Server settings that deserve a review, with recommendations tied to workload and evidence.

Read More
SQL SERVER - Find Automatically Created Statistics - T-SQL

SQL SERVER – Find Automatically Created Statistics – T-SQL

September 10, 2010
Pinal Dave
SQL Performance
SQL Scripts, SQL Statistics

Ad-hoc queries on a production server left many useless automatically created statistics. Here is a T-SQL script to find them so you can clean them up.

Read More
A houseboat leaving its canal mooring with potted herbs, a bicycle and its red front door all aboard.

Contained Database Users: Logins That Move With the Database

September 9, 2010
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Login, SQL Password, SQL Server, SQL Server Security

Use contained database users to move authentication with a database, inspect prerequisites, test connections, and review access ownership.

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

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