Backup all Filegroups
A short script to backup all filegroups, for those who utilise filegroups within a database.
2011-06-29 (first published: 2010-07-20)
1,350 reads
A short script to backup all filegroups, for those who utilise filegroups within a database.
2011-06-29 (first published: 2010-07-20)
1,350 reads
2010-12-30 (first published: 2010-03-18)
2,469 reads
A short procedure for your tools database. Use it to test connectivity to linked servers.
2010-12-28 (first published: 2010-03-19)
6,743 reads
A Stored Procedure for your tools database. It lists uncompressed tables and indexes and also generates the SQL to compress them.
2010-12-22 (first published: 2009-08-27)
934 reads
A generic character padding function. Useful for situations where you need fixed width formatting e.g. email reports.
2010-12-20 (first published: 2010-03-31)
2,295 reads
This script reveals the state of your indexes. It breaks down the indexes where they are partitioned, matching the index to it’s partition and filegroup.
2010-12-16 (first published: 2010-04-22)
7,540 reads
A script to reveal which logins have access to your sql server via windows groups.
2010-12-09 (first published: 2010-08-26)
2,416 reads
In my previous post, I showed you how to build a snapshot backup catalog...
By Steve Jones
Train employees well enough that they could get another job but treat them well...
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Why Data Modelling Still Matters...
Hi when i think of server hops , i think of how kerberos assists...
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers