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.
SQL SERVER – FIX: Msg 15281 – SQL Server Blocked Access to STATEMENT ‘OpenRowset/OpenDatasource’ of Component ‘Ad Hoc Distributed Queries’
Reading Excel, a reader got Msg 15281: SQL Server blocked access to STATEMENT ‘OpenRowset/OpenDatasource’. Enabling Ad Hoc Distributed Queries fixes it.
SQL SERVER – The OLE DB Provider “Microsoft.ACE.OLEDB.12.0” for Linked Server “(null)” Reported an Error. Access Denied
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.
SQL SERVER – Small Backup for Large Database
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.
SQL SERVER – What is the Meaning of PREEMPTIVE_HTTP_EVENT_WAIT? How to Fix it?
I blocked internet access on my Azure SQL Server VM with an outbound rule and started seeing PREEMPTIVE_HTTP_EVENT_WAIT. Here is one possible cause of this wait.
Find the Oldest Query Plan in the Plan Cache
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.
SQL SERVER – SQL Server Agent Missing in SQL Server Management Studio (SSMS)
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.