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)
992 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,342 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,543 reads
Blogs
Life Support 2008 – Audit Logons
Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep...
All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT
This is the first in a series of posts about gatekeeping in Information Technology...
None of the IP addresses configured for the availability group listener can be hosted by the server Either configure a public cluster network 19456
By MUTHUKKUMARAN KALIYAMOORTHY
Requirement: Remove a node from one of... [[ This is a content summary only. Visit...
Forums
SQL Query Assistance Required
Hi. I am wanting to know if there is a way to make this...
Microsoft Exam 98-364 (Database Fundamentals)
Has anybody here taken the 98-364 exam?
Stairway to Database Containers Level 3: Building Custom Container Images by Hand
Comments posted to this topic are about the item Stairway to Database Containers Level...
Ask SSC