Find all published tables with row counts and table size
This script will show you all the tables that are being published with sizes.
2017-03-16 (first published: 2017-03-13)
3,411 reads
Scripts
2017-03-09 (first published: 2017-02-16)
1,966 reads
2017-03-07 (first published: 2017-03-01)
1,233 reads
Corrupt Page Notification
This trigger will send mail notification once a row is written in the suspect pages table
2017-03-03 (first published: 2017-02-21)
505 reads
Missing index with change impact percentage
This script will list all missing indexes with create statements.
2017-03-01 (first published: 2017-02-24)
1,331 reads
2017-02-28 (first published: 2015-06-22)
2,112 reads
Check if xp_cmdshell is turned on and flip the bit
The code works well for an automation process that needs to have xp_cmdhsell turned on.
2017-02-22 (first published: 2017-02-13)
1,254 reads
2017-02-02 (first published: 2017-01-30)
784 reads
2017-01-30 (first published: 2017-01-26)
19,060 reads
Query details about objects allocated in TEMPDB.
TEMPDB doesn't have to be a black box. Know what objects and processes are causing it to bloat in size.
2017-01-30 (first published: 2016-12-29)
2,216 reads
Blogs
Local LLM Models at SQL Saturday Boston 2025
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
3 things you must do to start data quality management right
As a data & AI strategist who’s seen countless projects succeed and fail, I...
Set Theory vs. Batch Mode in SQL Server
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Forums
Changing the Recovery Time
Comments posted to this topic are about the item Changing the Recovery Time
Getting More Time from AI
Comments posted to this topic are about the item Getting More Time from AI
When Page Prefetching Takes a Back Seat – Exploring Trace Flag 652 in SQL Server
Comments posted to this topic are about the item When Page Prefetching Takes a...
Question of the Day
Changing the Recovery Time
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers