Identify Tables With Dropped Columns
How easily can we find tables with dropped columns that need cleanup?
2024-06-07
2,075 reads
Drop Column
2023-03-01
509 reads
2019-09-24
982 reads
2009-03-23 (first published: 2009-02-17)
945 reads
Blogs
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
Removing the REST Endpoint in the Data API Builder
By Steve Jones
The more I work with the Data API Builder (DAB), the more I lean...
T-SQL Tuesday #182: Personal Integrity
By Steve Jones
It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...
Forums
orphaned users in sys.sysusers
Hi everybody, we got 2 entries in this table [myDatabase].[sys].[sysusers] Is there a possibility...
TDE for multiple databases and severs
We are self hosting sql servers, we are not using Azure for sql servers....
Help with parent/child query please
Hi everyone, Trying to get this data to the following format but I can't...
Question of the Day
Sparse Column Storage
When does a column declared as SPARSE use no storage?
See possible answers