2013-02-22 (first published: 2013-02-05)
1,791 reads
Scripts
Script to Rebuild/Reorganise Indexes
A script to get the fragmentation of indexes in a database and then rebuild or reorganise accordingly
2013-02-19 (first published: 2013-01-29)
2,131 reads
2013-02-18 (first published: 2013-01-25)
2,772 reads
Get Detach or Attach all user databases script
Script to generate script to detach or attach user databases
2013-02-15 (first published: 2013-01-29)
5,970 reads
Reorganize indexes for all tables in all user databases
Script to reorganize all indexes on all tables in user databases
2013-02-14 (first published: 2013-01-31)
3,263 reads
2013-02-13 (first published: 2013-01-25)
2,002 reads
Generate Column Metadata
This utility will generate column and parameter metadata in various useful formats for tables, views, and procedures.
2013-02-12 (first published: 2013-01-18)
756 reads
Tables and rows listing
Simple script which create a list of all the tables and rows of the selected DB.
2013-02-11 (first published: 2012-12-21)
1,174 reads
2013-02-08 (first published: 2012-12-27)
1,533 reads
T-SQL Bulk Insert
T-SQL that allows you to import tab delimited text file into correct table based on file name.
2013-02-07 (first published: 2012-12-27)
2,320 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 Industri | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Industri II No.14, Muktiharjo Lor, Kec. Genuk, Kota Semarang, Jawa Tengah 50197...
BCA KCP Sidareja | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Jenderal Ahmad Yani No.40, Cikalong, Sidareja, Kec. Sidareja, Kabupaten Cilacap, Jawa Tengah...
BCA KCP Siliwangi | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Jenderal Sudirman No.39, Krobokan, Kec. Semarang Barat, Kota Semarang, Jawa Tengah 50141...
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