2016-11-29
1,158 reads
Ren
Index rename to standards
Rename indexes according to pattern:
IX_<TableName>_<Col1>_<Col2>..
or
AK_<TableName>_<Col1>_<Col2>..
2014-10-06 (first published: 2014-09-04)
1,083 reads
Duplicate Records using SQLCMD
We have an article here from Renato Buda that shows how to delete duplicate records from your tables. SQLCMD is used with variables that make it easy to write a general purpose script for any table.
2009-04-06
9,839 reads
How SSIS and Other Tools Obtain Metadata
How to author stored procedures that use temp tables, so they work with tools such as SSIS and Crystal Reports.
2008-11-03
9,393 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP KAS SIMPANG RIMBO TLP/WA 083800119009
Jl. Kapten Pattimura No.RT 02, Kenali Besar, Kec. Kota Baru, Kota Jambi, Jambi 36129
BCA KCU MATRAMAN Telpon/WA:085355042311
BCA KCU MATRAMAN Telpon/WA:085355042311 Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota...
Alamat kantor resmi BCA KCP Kiaracondong Telp:083178278662
Wa:083178278662Jl. Kiara Condong No.190, Kb. Gedang, Kec. Batununggal, Kota Bandung, Jawa Barat 40274
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers