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
Physical Pages.

SQL SERVER – Server Side Paging in SQL Server 2012 Performance Comparison

December 16, 2010
Pinal Dave
SQL Performance

A quick performance comparison of server side paging in SQL Server 2012, split into two tests, with a focus on the unnecessary IO reads that make paging costly.

Read More
SQL Server query window with results for AdventureWorks2008R2.

SQL SERVER – Server Side Paging in SQL Server 2012 – A Better Alternative

December 15, 2010
Pinal Dave
SQL Performance
SQL Scripts

Server side paging in SQL Server 2012 is simpler with OFFSET and FETCH NEXT. I compare it with the older ROW_NUMBER and OVER method from SQL Server 2005/2008.

Read More
Broken washing machine with overflowing clothes and sullen boy.

SQL SERVER – What the Business Says Is Not What the Business Wants

December 14, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, Shrinking Database

Let us discuss about What the Business Says Is Not What the Business Wants. Steve raised a very interesting question.

Read More
SQL SERVER - What is Page Life Expectancy (PLE) Counter

SQL SERVER – What is Page Life Expectancy (PLE) Counter

December 13, 2010
Pinal Dave
SQL Performance
SQL Scripts

What is Page Life Expectancy (PLE)? A quick query to read it from sys.dm_os_performance_counters, the recommended minimum of 300 seconds, and what it means.

Read More
An analogue instrument panel of round gauges on a machine, one needle sitting in the red band.

SQL SERVER – Activity Monitor and Performance Issue

December 12, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Server, SQL Utility

A small story with a big moral about Activity Monitor and performance issue: a client left the tool open, and the monitor itself slowed the server down.

Read More
A fingertip touching one strand of a dewy spider web in a garden, drops trembling across the whole web

Finding Every Object That Uses a Column

December 11, 2010
Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Dependency, SQL Server, SQL System Table

Find an object that uses a column with dependency metadata and module text search, then check dynamic SQL and application code.

Read More
SQL SEVER - Finding Memory Pressure - External and Internal

SQL SERVER – Finding Memory Pressure – External and Internal

December 10, 2010
Pinal Dave
SQL Performance
SQL Scripts, SQL Server

A quick query to find external and internal memory pressure in SQL Server and see how much memory each memory type is using right now.

Read More
Two stacks of chocolate boxes, one short and full, one twice as tall with half-empty boxes

Page Density: The Fragmentation Number That Actually Slows Scans

December 9, 2010
Pinal Dave
SQL Performance
SQL Data Storage, SQL DMV, SQL Index, SQL Server

Measure page density and fragmentation, compare scan reads around a test rebuild, and choose fill factor using workload evidence.

Read More
A hand moving tiny furniture from an old dollhouse into the matching rooms of a new one

Restoring a Sample Database to New Folders With RESTORE FILELISTONLY

December 8, 2010
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Sample Database, SQL Scripts

Use RESTORE FILELISTONLY to map backup files to local folders, restore a separate sample copy, and verify its data and log paths.

Read More
Gouache painting: in a garden bed, a strawberry mother plant and its two small runner plants, still joined by their green runners, sit together in a shallow wooden crate resting on the soil

hierarchyid IsDescendantOf: A Node Includes Itself

December 7, 2010
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server

hierarchyid IsDescendantOf tests membership in a subtree, including its root. These literal paths keep both compared nodes visible and distinguish self from a strict descendant.

Read More
Previous 1 … 434 435 436 437 438 439 440 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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