2001-08-22
712 reads
2001-08-22
712 reads
Get OLE Providers info I have found this useful in tracking down application driver/connection issues. I only had to use it 2 times. But it did help
2001-08-22
416 reads
Very simple, how much space is free on the hard drives of the SQL Server you are connected to.
2001-08-22
669 reads
2001-08-22
383 reads
2001-08-22
729 reads
This script will search all logged in users and return the spid along with the number of seconds since that spids last batch was executed.
2001-08-22
954 reads
Use this script to see showcontig for all tables in the context of the database in which its called. Very handy to schedule during off peak hours prior to any re-indexing to see how bad things are and re-build certain indexes sooner than you thought for peak performance.
2001-08-20
4,141 reads
A handy dandy proc that can be used to zip up a backup file to location specified. Also called from a backup script to automate the compression of all backups using PKZip command line utility. Make sure pkzip is in the path and found by the shell prior to using this script.
2001-08-20
3,723 reads
This script(sproc)uses xp_cmdshell from sql and FINDSTR from DOS to search the current errorlog for a specific string such as kernel or failed login. Compile this in the master db and if you do not pass an input parameter a example usage will display for you. ex: sp_dba_sqlerrorlog kernel Edward J Pochinski III
2001-08-13
1,908 reads
This will show the fragmentation and stats before and after a reindex of a specified table. Run in the context for the db that holds the table the proc will get passed and re-index. Complile in master since the master is checked first for any SP that is prefixed with SP_ and you can call […]
2001-08-13
4,024 reads
By Steve Jones
I published an article today on the Data API Builder, which is a way...
By Steve Jones
dolonia – n. a state of unease prompted by people who seem to like...
You can find the slides for the session Building the €100 data warehouse with...
Hi, I am a first time writer looking to author some content here. I...
Comments posted to this topic are about the item Do As I Say, Not...
Hi Gents, Silly question, but it's been a long time since I've done this....
I have a detached database from SQL Server 2019, called TDE_Primer. This database had a 100MB data file and a 73MB log file. The log file was lost, so I need to run this code:
USE [master] GO CREATE DATABASE [TDE_Primer] ON ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\TDE_Primer.mdf' ) FOR ATTACH_REBUILD_LOG GOHow big is the new log file? See possible answers