2016-11-29
1,142 reads
2016-11-29
1,142 reads
Rename indexes according to pattern:
IX_<TableName>_<Col1>_<Col2>..
or
AK_<TableName>_<Col1>_<Col2>..
2014-10-06 (first published: 2014-09-04)
1,015 reads
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,607 reads
How to author stored procedures that use temp tables, so they work with tools such as SSIS and Crystal Reports.
2008-11-03
8,538 reads
By kleegeek
I am thrilled to have been a part of this year’s Storage Field Day...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By alevyinroc
Note: I originally wrote this a few years ago but never posted it. It...
Hello, I have a requirement to migrate the data from existing AWS RDS DB...
I'm having some trouble wrapping my head around the relationship between EC2 instances and...
Hello All, I have a table like below. I need to get daily,weekly and...