2012-04-13 (first published: 2007-10-19)
3,399 reads
Scripts
Restore Server/Database users/roles
Restore server/database users and roles from another server when we are restoring databases to another server.
2012-04-12 (first published: 2007-10-23)
3,115 reads
Auto compression all indexs on all online db
Auto compression of index, if index includes > 1 million rows.
2012-04-11 (first published: 2012-03-19)
927 reads
Remove Logins Script
Generates a script to remove logins from a SQL Instance. Handles cases where logins own schemas.
2012-04-05 (first published: 2012-03-26)
1,357 reads
2012-03-30 (first published: 2008-04-21)
3,221 reads
Generate index on foreign key columns
Script find all foreign key without index in database and create new one for them.
2012-03-29 (first published: 2008-01-25)
3,400 reads
Select, Update, Delete, Insert etc.. in many servers using 1 query
Query Servers using 1 sql statement. Will make your job easy!!!
2012-03-28 (first published: 2008-01-16)
3,361 reads
DBCC Reindex with Statistics Information and table name optional
Reindex all tables, showing statistics before and after reindexing, table name optional.
2012-03-27 (first published: 2008-01-30)
3,116 reads
2012-03-26 (first published: 2008-01-23)
3,245 reads
Different Date Formats
You Can Find Some Date Functions and extracting the different Date Formats using the Convert and Cast
2012-03-23 (first published: 2007-10-26)
3,687 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 KCU PLUIT | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Landmark Pluit, Jl. Pluit Selatan Raya Blok A8, RT.8/RW.10, Pluit, Penjaringan, North Jakarta...
BCA KCU PANAKKUKANG | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Boulevard No.5 Blok F5, Masale, Kec. Panakkukang, Kota Makassar, Sulawesi Selatan 90231...
Fuzzy String Matching in SQL Server 2025
Comments posted to this topic are about the item Fuzzy String Matching in SQL...
Question of the Day
Representing Money
Which types of currency does the money data type represent?
See possible answers