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
An open protected archive case sits before shelves of closed cases ready for inspection.

SQL SERVER – Finding Last Backup Time for All Database

November 4, 2010
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL DMV, SQL Scripts, SQL Server

Last Backup Time comes from recorded history, which I check by backup type. Recovery still needs the files and a tested chain.

Read More
SQL SERVER - Fix: Error: MS Jet OLEDB 4.0 cannot be used for distributed queries because the provider is used to run in apartment mode.

SQL SERVER – Fix: Error: MS Jet OLEDB 4.0 cannot be used for distributed queries because the provider is used to run in apartment mode.

November 3, 2010
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts

MS Jet OLEDB 4.0 cannot be used for distributed queries because it runs in apartment mode? Turning on Ad Hoc Distributed Queries with sp_configure fixes it.

Read More
A small basket of green apples sits before larger baskets filled with apples and pears.

COUNT OVER: Show the Filtered Total Beside Page Rows

November 2, 2010
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Order By, SQL Scripts, SQL Server

COUNT OVER helps me keep a page’s row count separate from the filtered total. Compare full and partial pages. An empty page needs an explicit total-count contract.

Read More
Gouache painting of a shelf of cloth-bound books with one book tilted out of the row and a vermilion ribbon bookmark hanging below it

Find the Last Read and Write Time of Every Table in SQL Server

October 31, 2010
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Index, SQL Scripts, SQL Server

Find the last read and write time of every table in SQL Server with sys.dm_db_index_usage_stats. The tests show what counts as a read, why an insert counts as a write, what an index rebuild does to the numbers, and what wipes them.

Read More
Gouache painting of a magnifying glass examining database views

SQL SERVER – List of all the Views from Database

October 29, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL View

Hundreds of Views and no idea which are indexed? A quick query on sys.views lists every view with its schema and whether it is indexed or indexable.

Read More
SQL SERVER - SQL Challenge - SQL Puzzle - Query Creating Most TempDB IO Usage

SQL SERVER – SQL Challenge – SQL Puzzle – Query Creating Most TempDB IO Usage

October 27, 2010
Pinal Dave
SQL Puzzle
Best Practices, Database, SQL Scripts, SQL TempDB

My SQL puzzle: which queries create the most TempDB IO and grow its size? Answer with any DMV, and all valid answers get published here with credit.

Read More
Gouache painting: seen from the side, a hillside of grapevines steps down in three terraces

hierarchyid GetLevel: Count the Path Depth

October 25, 2010
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server

hierarchyid GetLevel identifies depth within a logical path. The read-only example distinguishes the root, children, grandchildren and a fractional sibling label.

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

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