2016-11-29
1,147 reads
2016-11-29
1,147 reads
Rename indexes according to pattern:
IX_<TableName>_<Col1>_<Col2>..
or
AK_<TableName>_<Col1>_<Col2>..
2014-10-06 (first published: 2014-09-04)
1,059 reads
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,816 reads
How to author stored procedures that use temp tables, so they work with tools such as SSIS and Crystal Reports.
2008-11-03
9,318 reads
Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...
By Steve Jones
Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...
In this post, I’ll walk you through a T-SQL script that creates application-consistent snapshots...
Every expert knows you can't make perfect software that never crashes or has bugs....
I wanted to share with you tools from my personal toolbox. If your code...
I have a tabular cube, with myself included in one of the roles. I...
What is the minimal number of parameters to add a linked server with sp_addlinkedserver?
See possible answers