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
187 reads
Load Backup History from Backup File
This script creates a stored proc to verify all backups in a media set and load their history into MSDB. I use this frequently when I get backup files from clients and want to use Enterprise Manager's intelligent restore selection to quickly get the database restored on a test machine.
2003-03-11
299 reads
Blogs
Speaking at SQL Saturday Boston 2023
By Steve Jones
I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...
SQL Prompt Quick Access to Helper Code
By Steve Jones
We’ve been doing some events as part of the Redgate Roadshow, and at one...
Eleven chapters of my data architecture book are available
By James Serra
As I have mentioned in prior blog posts, I have been writing a data...
Forums
I can query one by one. Need help how to become Single Query
Hi, This is my table and data, CREATE TABLE [dbo].[rpt_AR_StatementOfAcct_003]( [Id] [int] IDENTITY(1,1) NOT...
Baking up and restores VLDBs
Some of our databases are getting be close to 2 terabytes. We are backing...
Data Analysis with Python: Calculating Mean and Median
I'm working on a data analysis project in Python and need to calculate both...
Ask SSC