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
193 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
198 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
212 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
783 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
133 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
477 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
172 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
169 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
149 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
957 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Forums
Layanan wa cs Qlola bri
Segera hubungi WhatsApp 08136035412 untuk bantuan QLola BRI. Dapatkan solusi cepat tanpa harus menunggu...
Nomor qlola bri
QLola BRI Anda bermasalah? Hubungi WhatsApp 08136035412 untuk mendapatkan bantuan profesional dengan proses yang...
Nomor cs qlola bri berapa
Untuk bantuan QLola BRI, silakan hubungi WhatsApp 08136035412. Melayani kendala akun, transaksi, dan informasi...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers