GetSizeOfAllTables
Gives you a list with name of all the tables, number of rows, row length of each table, total reserved space, space used by data, space used by index and unused space.
2003-04-02
182 reads
Maintenance and Management
sp_whoindb
Modified the sp_who2 proc provided by Microsoft. This proc takes a dbname or dbid for input, and lists current processes in that database. If no database is provided, the current database is used.
2003-03-28
188 reads
Shrink Multi-File Databases
This stored procedure shrinks all database files within the current database, including the unused portion of transaction log. This procedure is especially useful for multi-file databases.
2003-03-24
198 reads
Script to validate user input for password change
For SQL Server in Mixed Authentication mode thisstored procedure helps to validate users password. Currently this procedure checks for the next requrements: password must have length at least 8 characters plus among them at least one digit and at least one of the characters must be in upper case.
2003-03-11
746 reads
Add files to filegroups and log for many dbs
Purpose: This SP is used to add a logfile and a datafile to each file group in a database or all databases. This is handy when you have a lot of databases and you want to add a new big SAN-disk and stop db expansion on the old disks.Consider: Avoid running any large updates when […]
2003-03-06
120 reads
Intervention system for runaway jobs
Some of my developers had created jobs that executed VB applications that never ended. Aparently they could not figure out when, why and what was going wrong. They could not repro the situation.Now I've created this litle system so the users can assign max elaps times for their jobs. These jobs will then be intercepted […]
2003-03-04
467 reads
LOG OVERSIZE Report for all DB
When log_file bigger then data_file you will getReport by E-Mail.For ALL DB.
2003-02-20
161 reads
NEW and DELETED Database REPORT
A Procedure build Report about NEW and Deleted DB.First time you must to run p_build_check_db.This procedure build table master..t_databases same asmaster..sysdatabases .Procedure p_check_db compare t_databases and sysdatabases and send a report to your@E-MailAddress.Best regards. Vadim.
2003-02-20
159 reads
Granting permissions to multiple objects
I came across a situation where I needed to fix a vendors permissions issue. It required changing permissions on 338 views and tables, and leaving only 5 intact. Below is the Script I used to perform this task.
2003-02-10
131 reads
Database Size sp_MSforeachdb
This script find the size of the data and log file for every database on your server and add it to a table. But it could do with some added sparkle! Still it is simple to run, you might want to change the database from utils mind.
2003-02-07
949 reads
Blogs
Query deadlock info in Azure SQL DB
A couple of weeks ago, a developer came to me and wanted to know...
MSSQL Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database
By SQLPals
Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database As one...
Dynamic Warehouse & Lakehouse Connections in Microsoft Fabric Data Pipelines
When you develop data pipelines in Microsoft Fabric (the Azure Data Factory equivalent in...
Forums
Baseball Everywhere
Comments posted to this topic are about the item Baseball Everywhere
How to run custom python module on SQL Server?
I am working on a small test script on SQL server 2022 using python...
Upgrade to SQL2019 from 2012 Query is taking time, Need Query Optimization steps
Upgrade to SQL2019 from 2012 Query is taking time, Need Query Optimization steps and...
Question of the Day
Sensitivity Ranks
I want to use the ADD SENSITIVITY CLASSIFICATION DDL to mark some columns in my SQL Server 2022 database as PII. Can I use this code?
ADD SENSITIVITY CLASSIFICATION TO dbo.sales.price,
dbo.sales.discount
WITH (
LABEL = 'Highly Confidential',
INFORMATION_TYPE = 'Financial',
RANK = 'INTERNAL ONLY'
); See possible answers