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)
903 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)
503 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)
803 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,096 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)
386 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,519 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,444 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,117 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)
439 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,108 reads
Blogs
T-SQL Tuesday #199 Invitation: Back to on-prem?
It’s time for T-SQL Tuesday again! And we’re almost to number 200! T-SQL Tuesday...
Data Skew in Data Engineering: What It Is and How to Fix It
You kick off a distributed job expecting it to finish in minutes — but...
Error Deploying GraphQL in Fabric: dm_exec_describe_first_result_set
A while ago we suddenly had an error while trying to deploy one Fabric...
Forums
BCA KCP Sudirman Call Center/Telpon 0818-740-011
WhatsApp:0818-740-011 Jl. Panglima Sudirman No.27, Kesatrian, Kec. Blimbing, Kota Malang, Jawa Timur 65111
BCA KCU BOROBUDUR Call Center/Telpon 0818-740-011
WhatsApp:0818-740-011 Jl. Borobudur No.I, RT.03/RW.07, Mojolangu, Kec. Lowokwaru, Kota Malang, Jawa Timur 65125
BCA KCU MALANG Call Center/Telpon 0818-740-011
WhatsApp:0818-740-011 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa Timur 65111
Question of the Day
Secure Cached Plans
The DMV, sys.dm_exec_cached_plans, contains rows for each cached plan on an instance. In Azure SQL Database, not every used has rights to every database, as there does exist an instance behind each database. How is security handled for this DMV in Azure?
See possible answers