Comprehensive Backup Script
These scripts were generated to standardize our SQL backup environments, and to remove backups from Maintenance Plans.
2011-12-22 (first published: 2008-01-29)
3,380 reads
Simon Facer
Why SHRINKFILE is a very bad thing, and what to do about it.
This article talks about why SHRINKFILE is a very bad thing, and what to do about it if you must shrink a database file.
2011-12-16 (first published: 2010-11-09)
52,157 reads
Proc to Rename a file
A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.
2011-10-28 (first published: 2008-05-13)
2,849 reads
2008-06-19
9,287 reads
Audit SQL Logins
We have auditors in the building, looking at our security (amongst other things). So, we needed an easy way to generate a listing of the SQL logins, and the permissions into each database on our servers (over 70 if them).This script will generate the listings the auditors wanted.
2007-04-02 (first published: 2007-03-07)
5,573 reads
Blogs
Daily Coping 8 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Don’t be afraid of No
How many times have you been afraid to hear “No”? We have all been...
Spark .NET - Spark ML TF-IDF
By Ed Elliott
Spark ML in .NET for Apache Spark Spark is awesome, .NET is awesome, machine...
Forums
DBCC CHECKDB output
I ran a DBCC on a database and it found some anomalies. Just looking...
Why is sys.master_files showing the size of RBS files as 0?
Dear Everyone I hope you are all safe in these strange times. I am...
In where condition use column value which contains column name
Hi Team, Greetings! I have below table. let table name =Emp I need to...
Ask SSC