The script can be used to perform any task against all databases hosted on an instance. This is an example script that checks if a user is in a database if it is not then create the user and add it db_datareader role.
2016-02-02 (first published: 2016-01-15)
794 reads
Find missing Foreign Keys by name, only reference single column primary keys which are on top of an identity,also find where column names reference table with column name ='ID'.
2016-02-01 (first published: 2016-01-21)
1,079 reads
Generic SQL backup with Azure support allowing several, handy backup options.
2016-01-29 (first published: 2016-01-21)
377 reads
Script for preventing the volumes of the transaction logs from filling.
2016-01-27 (first published: 2014-05-13)
3,510 reads
The procedure created by this script rolls up the collected query execution statistics and groups them daily by the plan hash value.
2016-01-20 (first published: 2015-05-13)
5,421 reads
An alternative solution to passing parameters to sp_executesql.
2016-01-19 (first published: 2014-04-23)
4,107 reads
This is a great wrapper for your DMV's to automate a quick performance metric capture.
2016-01-12 (first published: 2016-01-06)
429 reads
Set minimal autogrow values for datafiles and logfiles depending on the file size, thresholds for all databases
2016-01-07 (first published: 2015-06-08)
1,103 reads
Query the mirror instance via agent job to auto kick back to primary. If db is in suspended state will resume mirroring.
2016-01-05 (first published: 2015-12-23)
452 reads
Use provided script to fix orphan users for all databases after Instance Migration. Tested on SQL 2014.
2016-01-04 (first published: 2015-12-17)
1,587 reads
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
hi, need to known weather fast farwand cursor is faster than a while loop...
Comments posted to this topic are about the item Economics of AI: What is...
Comments posted to this topic are about the item Poor Name Choice
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers