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 - How to Stop Growing Log File Too Big

SQL SERVER – How to Stop Growing Log File Too Big

September 20, 2010
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts

A client kept truncating the transaction log because of a growing log file. I explain why that is risky and share two better options, starting with Simple recovery.

Read More
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
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
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
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
Previous 1 … 248 249 250 251 252 253 254 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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