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,008 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,459 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,179 reads
Blogs
Azure Platform Series “You have exceeded the maximum amount of scale changes within the past hour”
By HamishWatson
This blog post relates to where you might be doing scale operations of your...
Bash: “command not found” in IF statement
By HamishWatson
This blog post is about a situation where writing an IF THEN ELSE statement...
The First Data Saturday is Tomorrow
By Steve Jones
Data Saturday #2 – Guatemala is tomorrow. This is the first event on the...
Forums
Data Privacy Grows in California
Comments posted to this topic are about the item Data Privacy Grows in California
Grant user access to view database only
Hi I need to grant a user access to a DB on the server...
Need to strip off the beginning of a field in SELECT statement
I have this table that unfortunately has spaces in the field, which I am...
Ask SSC