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
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Permata Ujung Menteng Telpon/WA:085188120691
BCA KCP Permata Ujung Menteng Telpon/WA:085188120691 Jl. Raya Bekasi Km. 25 Blok A/17, RW.18,...
BCA KCU KALIMALANG Telpon:085188120691
BCA KCU KALIMALANG Telpon/WA:085188120691 Jl. Blk.Tarum Barat. E No.5, Wil. Kota, Kec. Duren Sawit,...
BCA KCP Buaran Raya Telpon/WA:085188120691
BCA KCP Buaran Raya Telpon/WA:085188120691 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers