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
Table Scan Execution Plan.

SQL SERVER – Simple Explanation of Data Type Precedence

October 8, 2010
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Scripts

A simple explanation of data type precedence: filter an INT and a VARCHAR column with N’1′ and N’First’, then see what the execution plan shows.

Read More
Database Properties Window.

SQL SERVER – Quickest Way to Identify Blocking Query and Resolution – Dirty Solution

October 6, 2010
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts

A friend could not delete, truncate or drop a table at 11 PM because of open transactions. Here is my quick and dirty way to identify blocking query.

Read More
Two counters showing activity between day and night

SQL SERVER – Find Total Number of Transactions on Interval

October 4, 2010
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL Server, SQL System Table

How many Transactions run on your server per minute? A handy script reads sys.dm_os_performance_counters twice with a WAITFOR DELAY between the reads.

Read More
A wooden loom, a reusable shuttle, wound wool and an ordered thread comb.

NO_PERFORMANCE_SPOOL: Compare the Work Before Keeping the Hint

October 2, 2010
Pinal Dave
SQL Performance
SQL Index, SQL Performance, SQL Scripts, SQL Server 2016

NO_PERFORMANCE_SPOOL changes one query optimization decision. A guarded private fixture compares baseline work, the optional hint and a supporting inner index. The article explains how to preserve results and assess actual child work without promising a plan shape.

Read More
Results window in query analyzer.

SQL SERVER – Get Query Running in Session

October 1, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL System Table, SQL Utility

I forgot the simple syntax to get query running in session and ended up on my own old post. Here is the one method I use most during performance tuning.

Read More
SQL SERVER - View Over the View Not Possible with Index View - Limitations of the View 11

SQL SERVER – View Over the View Not Possible with Index View – Limitations of the View 11

September 29, 2010
Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Scripts, SQL View

Why can’t you create a view over the view and index it? An index view cannot reference another view. Limitation of the view 11 shows an example.

Read More
A blue glass vessel under inspection beside a magnifying lens and shelves of accumulated finished vessels.

Wait Statistics: Read the Snapshot Before Naming the Bottleneck

September 28, 2010
Pinal Dave
SQL Performance
SQL Monitoring, SQL Performance, SQL Scripts, SQL Server

Wait statistics provide a starting point for investigation. Separate cumulative completed waits, background activity, signal time and currently waiting requests before treating the largest total as the present bottleneck.

Read More
Previous 1 … 246 247 248 249 250 251 252 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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