2016-11-29
1,138 reads
2016-11-29
1,138 reads
Rename indexes according to pattern:
IX_<TableName>_<Col1>_<Col2>..
or
AK_<TableName>_<Col1>_<Col2>..
2014-10-06 (first published: 2014-09-04)
1,009 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,482 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,235 reads
By Steve Jones
With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events....
By James-Serra
An extension to the Modern Data Warehouse (MDW) that I have heard a bit...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Should we think about compressing tables like MyHugeTbl 200 million rows table which during...
Hi, One of the user databases was in Not synchronizing / In recovery mode....
No doubt this has already been answered and probably detailed many ways so I...