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,003 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,435 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,108 reads
Blogs
Power BI Monthly Digest – October 2020
By Devin-Knight
In this month’s Power BI Digest Matt and I will again guide you through...
Daily Coping 26 Oct 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Welcome to 3Cloud …
By DataOnWheels
A little over a month ago, Pragmatic Works Consulting was a part of a...
Forums
what does it mean for the following SQL Scripts
in a stored procedure, I found two line sql scripts " if @@microsoftversion > 0x07320000 exec sp_MSreplraiserror 20598...
Recovering Databases From a Master Backup
Comments posted to this topic are about the item Recovering Databases From a Master...
Ask SSC