Index stats with key,included columns, size - all you can eat
Get total access,updates, rowlocks,pagelocks, stats date,rowcount for all tables or specific table by partition
2016-02-04 (first published: 2016-01-22)
887 reads
Scripts
Design : Find table with Identities with missing unique constraints
In an OLTP DB, other than an autogenerated Identity , there should be something else on the table which makes the non-identity data unique, as in, unique if you had to drop the ID column.
2016-02-03 (first published: 2016-01-22)
490 reads
Instance wide script to add user (the 4th way)
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)
781 reads
Design : Find and script out Missing Foreign Keys
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,069 reads
Generic SQL backup with Azure support
Generic SQL backup with Azure support allowing several, handy backup options.
2016-01-29 (first published: 2016-01-21)
368 reads
Avoid Transaction Logs volume from filling
Script for preventing the volumes of the transaction logs from filling.
2016-01-27 (first published: 2014-05-13)
3,503 reads
Query Performance Report
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,398 reads
Hassle free parameters in dynamic SQL
An alternative solution to passing parameters to sp_executesql.
2016-01-19 (first published: 2014-04-23)
4,082 reads
SQLPS Meets the DMV's
This is a great wrapper for your DMV's to automate a quick performance metric capture.
2016-01-12 (first published: 2016-01-06)
420 reads
Adaptative Files Autogrow
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,094 reads
Blogs
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Monday Monitor Tips: Lots of Postgres Options
By Steve Jones
Redgate Monitor is growing to include more than just Microsoft SQL Server monitoring. We...
Advice I Like: Experience and Aptitude
By Steve Jones
Experience is overrated. Most breakthrough accomplishments were done by people doing them for the...
Forums
why no suggested indexes in estimated exec plan?
hi im looking at a query for a friend that has to be lacking...
Issues with SQL Server 2022 Server
Hello, At my work place I recently migrated our test environment to SQL Server...
Question of the Day
Data API Builder APIs
What formats of API endpoints can the Data API Builder present to clients when exposing the database?
See possible answers