Hope this is helpful to someone. This script will create a table and a stored procedure in the master database to gather and store table info for all datbases. The sp uses a temp table to hold the results returned by sp_spaceused, then transfers the information to the permanent table DatabaseTableSizes and adds the database […]
2007-07-16 (first published: 2006-10-11)
274 reads
Recently I had an interesting use case where I had to a compound calculation...
By Steve Jones
Today’s coping tip is let go of other people’s expectations of you. I think...
By gbargsley
Good morning dear blog reader. Today’s episode is fresh from a great weekend with...
As I was looking the authentication set up which come as default when we...
Hello Team, planning to do SQL in place upgrade from sql2016express to sql2016 standard...
I have two SQL 2019 servers running Master Data Services which are continually prompting...
Ask SSC