2016-11-29
1,138 reads
Renato Buda
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,001 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,408 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
7,947 reads
Blogs
New Pluralsight Course – Configuring and Managing Kubernetes Networking, Services, and Ingress
My new course “Configuring and Managing Kubernetes Networking, Services, and Ingress” is now available on Pluralsight here!...
Step By Step Installation of SQL Server 2019 with all features
By Rohit Garg
[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please...
Step By Step Installation of SQL Server 2019 with all features
By Rohit Garg
[MSSQLFUN & Decote ITeS becomes a family of 1500 individuals across the globe. Please...
Forums
Career Advice: Data Warehouse Architect/Modeler
Maybe some of you would share your thoughts about my situation. I´m working in...
Avamar Backup--Is it good?
Dear Experts, is it good to use Avamar backup for SQL Server, currently we...
Read-only
I read MSFT documentation few times but couldn't find a clear answer. I...
Ask SSC