2016-11-29
1,154 reads
Ren
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,080 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,827 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
9,370 reads
Blogs
What’s New at AWS re:Invent 2025 – Day 1 Highlights
Day 1 is an absolute thrill at re:Invent! I normally dedicate this dynamic day...
Running SQL Server on KubeVirt – Getting Started
With all the changes that have happened with VMware since the Broadcom acquisition I...
Why is shrinking IT budgets a good thing?
Each year around this time, companies enter the familiar ritual of budgeting. For many,...
Forums
Adding a Lot of Seconds
Comments posted to this topic are about the item Adding a Lot of Seconds
SQL Server Licensing is Simple
Comments posted to this topic are about the item SQL Server Licensing is Simple,...
Stairway to Azure SQL Hyperscale Level 5: Data Growth and Fast Auto-Grow Mechanism
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Question of the Day
Adding a Lot of Seconds
When does this code work and when does it fail?
DECLARE @BaseDate DATETIME = '1900-01-01'; SELECT DATEADD(SECOND, 2147483648, @BaseDate) AS [MaxIntSecondsAdded];See possible answers