Comment on Usp_FindAllDBSizes
This is a comment on/modification of the Usp_FindAllDBSizes script on Sept 17th.Why use an inner loop when you can use a select stmt?
2003-09-17
102 reads
Blogs
Speaking at the NYC Lunch and Learn DevOps Devour Hour
By Steve Jones
This Friday is the NYC DevOps Devour hour, which is actually 3 hours. Plus...
What’s new in SQL Server 2025 CTP 2.0
Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...
Monday Monitor Tips: Beyond SQL Server
By Steve Jones
Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...
Forums
Unlimited Text
Comments posted to this topic are about the item Unlimited Text
Remove ISNULL FROM left join to make SARGAble
Hi, I'm trying to make the below query SARGable by removing the ISNULL function...
SQL 2022 upgrade issues
We're about to upgrade our SQL 2017 Standard to 2022 standard. We have 1...
Question of the Day
Unlimited Text
If I want to get unlimited amounts of data back from a varchar(max)/nvarchar(max) column, what do I run?
See possible answers