2016-11-29
1,143 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,015 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,641 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,625 reads
Blogs
Daily Coping 23 Sep 2022
By Steve Jones
Today’s coping tip is to notice what you are feeling without any judgment. Today...
Snowflake – Where is the explain/execution plan?
By Arun Sirpal
Whatever your database background is you will have heard of an execution / explain...
Daily Coping 22 Sep 2022
By Steve Jones
Today’s coping tip is to ask a trusted friend to tell you what strengths...
Forums
When use sql graph on sql server 2019 ?
I working on sql server 2019 . i read more about sql graph but...
how to change hard coded dates to ytd please
Dear Helpers, Below query is working fine giving me what i needed but if...
Couldn't allocate new page for database alert even the Database has free space
Hi, We have a database. We received the alert Could not allocate new page...
Ask SSC