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 - Finding Frequently Running Query and Elapsed Time - Notes from the Field #005

SQL SERVER – Finding Frequently Running Query and Elapsed Time – Notes from the Field #005

December 5, 2013
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore

When the server is slow, first see what is running. Brian Kelley shows how to find a frequently running query and its elapsed time, two key facts for tuning.

Read More
SQL SERVER - Scripting Statistics for Read-Only Database and Making it Permanent

SQL SERVER – Scripting Statistics for Read-Only Database and Making it Permanent

December 4, 2013
Pinal Dave
SQL Tips and Tricks
SQL Statistics

Learn scripting statistics for read-only database use from TempDB, then make them permanent so they survive a SQL Server restart.

Read More
A workshop bench at the weekend with a single lamp on and a half-finished wooden frame clamped in place.

Weekend Project – Connect your Database and Automatically Generate a Fully Customized Back-office Interface

December 3, 2013
Pinal Dave
SQL Tips and Tricks
Office

Tired of building the same data entry UI again? I tried backand.com, which lets you connect your database and generate a customized back-office interface.

Read More
SQL SERVER - Location of Statistics Before and After Database is Marked as a Read-Only

SQL SERVER – Location of Statistics Before and After Database is Marked as a Read-Only

December 2, 2013
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Statistics

Where do old statistics go when a database becomes read-only? The location of statistics created before the change stays the same, and they remain permanent.

Read More
A narrow funnel and a wide funnel stand beside different piles of dry grains.

Why the Same Query Is Fast Then Suddenly Slow

December 1, 2013
Pinal Dave
SQL Performance
Best Practices, SQL Index, SQL Performance, SQL Server

Recognize parameter sniffing by comparing compiled values, data distribution, and reused plans, then test a remedy with its tradeoffs.

Read More
Right-click Script Statistics as.

SQL SERVER – How to Script Statistics from SSMS? – Scripting Statistics is Disabled in SSMS

November 30, 2013
Pinal Dave
SQL Tips and Tricks
SQL Statistics

Trying to script statistics in SSMS but the option is always disabled, even outside read-only databases? Here is why it happens.

Read More
SQL SERVER - Statistics for Read-Only Database are in TempDB

SQL SERVER – Statistics for Read-Only Database are in TempDB

November 29, 2013
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Statistics

Statistics usually live in the same database as the table, so where do they go for a read-only database? The answer is TempDB. Here is how it works.

Read More
SQL Server query window.

SQL SERVER – Building Three-Part Name from OBJECT-ID – Database Name, Schema Name, TableName

November 28, 2013
Pinal Dave
SQL Tips and Tricks
SQL Function

Have only an object_id? Here is a script to build the three-part name, database, schema and table, using DB_NAME, OBJECT_SCHEMA_NAME and QUOTENAME.

Read More
SQL SERVER - MySQL - Order Column by Nearest Value for Any Integer

SQL SERVER – MySQL – Order Column by Nearest Value for Any Integer

November 27, 2013
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Order By, SQL Scripts

How do you order column values by how close they are to any integer, such as -5? Here is a script that works the same way on SQL Server and MySQL.

Read More
SQL Server Configuration Checking Tool.

SQL SERVER – SQL Server Configuration Checking – A Must Do for Every DBA – Notes from the Field #004

November 26, 2013
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore

Still running on default settings? Mike Walsh explains why configuration checking is a must do for every DBA and how to fit SQL Server to your business.

Read More
Previous 1 … 319 320 321 322 323 324 325 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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