2016-11-29
1,132 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)
991 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,330 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,460 reads
Blogs
Do you have rarely used indexes that are hurting performance of writes?
By SQLPals
We know that indexes are necessary for query performance but comes with overhead during...
Working with SQLSaturday SpeedPASSes – revamped!
In the Richmond, VA area, I am the organizer for our SQL Saturdays. Among...
Happy Hour at SQL in the City Austin
By Steve Jones
Tomorrow is SQL in the City 2019 – Austin. If you’ve registered, you’re going...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
sql server 2012 data column used for 7 different languages
In a sql server 2012 database, I want to store some messages in the...
Ask SSC