Find the row with the most data
This script is a quick throw together that tells you which rows in a table have the most data
2008-07-25 (first published: 2008-06-10)
846 reads
Scripts
get users across all databases on the SQL Server instance
Quick way to get all users on all Databases
2008-07-24 (first published: 2008-06-06)
1,680 reads
2008-07-23
485 reads
2008-07-23 (first published: 2008-06-05)
1,233 reads
2008-07-20
2,010 reads
2008-07-20
1,634 reads
2008-07-17
360 reads
usp_ShowOrphanUsers - SQL 2k5
Check Orphaned logins ie, not associated with any database on the current instance.
2008-07-16 (first published: 2008-05-20)
1,621 reads
2008-07-11
436 reads
Monitor Any Linked Server From SQL 2000
Best way to monitor Excel, Access, SQL Linked Servers from SQL 2000
2008-07-11 (first published: 2008-06-03)
1,611 reads
Blogs
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Forums
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Another Model, More Data Loss
Comments posted to this topic are about the item Another Model, More Data Loss
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers