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?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-09-17

98 reads

Blogs

In the technologically driven world of 2024, more individuals are finding themselves drawn towards the...

I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...

We’ve been doing some events as part of the Redgate Roadshow, and at one...

Forums

CREATE TABLE #tempdblogin ( lastcheck nvarchar(100) ) EXEC sp_MSforeachdb 'USE ? insert into #tempdblogin...

I am considering implementing an Azure Postgres DB for use in a part of...

Every time the dev team runs their dacpac, they encounter an issue. "This deployment...