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,004 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,442 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
8,141 reads
Blogs
Daily Coping 30 Nov 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Building a Raspberry Pi cluster to run Azure SQL Edge on Kubernetes
A project I’ve been meaning to work on for a while has been to...
SQL Server login – default database and failed logins
This is one of them little options that I see which quite often gets...
Forums
How to use While Loop to Insert Book details where status is not null?
I work on SQL SERVER 2012 . I face issue I can't use While...
SQL server night cpu usage
Hi using MS SQL maintenance plan to update statistic with full scan. The plan...
Find matched records between two tables
Hi, I haven't been able to find anywhere how to do or which transformation...
Ask SSC