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 query with expected results.

SQL SERVER – Relating Unrelated Tables – A Question from Reader

December 10, 2018
Pinal Dave
SQL Puzzle
SQL Scripts, SQL Server

A reader asked how to relate two unrelated tables, Table_A and Table_B, and show them in one output. Here is my answer to this unusual question.

Read More
An intact swimring is partly deflated beside its disconnected pump

How to Shrink All the Log Files for SQL Server? – Interview Question of the Week #203

December 9, 2018
Pinal Dave
SQL Interview Questions and Answers
Shrinking Database, SQL Backup and Restore, SQL DMV, SQL Scripts, SQL Server

Question: How to Shrink All the Log Files for SQL Server? Here is the script, plus why you should shrink only log files and never data files.

Read More
Gouache painting of a closed wooden garden gate in a stone wall, held shut by one small vermilion latch, with a stone path leading up to it

Msg 15281: Ad Hoc Distributed Queries Blocked in SQL Server

December 8, 2018
Pinal Dave
SQL Tips and Tricks
Ad Hoc Query, SQL Error Messages, SQL Scripts, SQL Server

Msg 15281 appears when OPENROWSET or OPENDATASOURCE runs while Ad Hoc Distributed Queries is turned off. A reader hit it while reading an Excel file. Two sp_configure calls turned the component on, and the query worked.

Read More
SQL SERVER - The OLE DB Provider "Microsoft.ACE.OLEDB.12.0" for Linked Server "(null)" Reported an Error. Access Denied

SQL SERVER – The OLE DB Provider “Microsoft.ACE.OLEDB.12.0” for Linked Server “(null)” Reported an Error. Access Denied

December 4, 2018
Pinal Dave
SQL Tips and Tricks
Excel, SQL Scripts, SQL Server, SQL Server Security

OPENROWSET on an Excel file gave: The OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server “(null)” reported an error. Access denied. Here is the fix.

Read More
Smaller backup file than data and log file.

SQL SERVER – Small Backup for Large Database

December 3, 2018
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL Server

A client’s 900 GB database made a backup of under 300 MB, and they feared data was missing. Here is what explained the small backup for a large database.

Read More
Gouache painting of a stack of dusty suitcases with a vermilion strap on the oldest one at the bottom

Find the Oldest Query Plan in the Plan Cache

November 30, 2018
Pinal Dave
SQL Tips and Tricks
SQL Cache, SQL DMV, SQL Scripts

To find the oldest query plan in the plan cache, sort sys.dm_exec_query_stats by creation_time. This post tests the idea on a demo with three procedures, compares the oldest plan with the server start time, and lists what clears the plan cache.

Read More
SQL SERVER - SQL Server Agent Missing in SQL Server Management Studio (SSMS)

SQL SERVER – SQL Server Agent Missing in SQL Server Management Studio (SSMS)

November 29, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL Server Agent, SQL Server Management Studio

A client could not see the SQL Server Agent node, it was missing in SQL Server Management Studio. Here are the possible causes, starting with sysadmin rights.

Read More
Previous 1 … 84 85 86 87 88 89 90 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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