Delete records in all related tables
Used to generate Select/Delete scripts. It does NOT run them.
You need to copy the output of this script to a new window and run it manually.
2008-08-06
548 reads
delete
2008-07-03
10,688 reads
The Difference between Truncate and Delete in SQL Server
This article explains the differences between the Truncate and Delete commands in SQL Server.
2019-09-18 (first published: 2007-11-22)
35,517 reads
Trigger Best Practices - Long
I read previously that placing multiple triggers on a table is not a "best practice" since the order in which triggers fire cannot be controlled. Therefore, there is always the potential for conflicting triggers and more maintenance overhead. (Not to mention 1 trigger firing multiple triggers on another table - nesting triggers). My personal practice […]
2005-04-25
RE: Understanding 2nd Normal Form
hi, As I mentioned earlier I think of the surrogate key as a proxy for the real key, hence my loss of the true name "surrogate". More to your question "So, is it fair to say that Normalization rules do not apply to surrogate keys?" this is one of the old debates in database modeling. […]
2005-03-08
Are clustered index columns actually usable in non-clustered indexes?
I have read that non-clustered indexes are built using the clustered index keys. Does that mean that explicitly including columns present in a clustered index in the definition of a non-clustered index is redundant? Suppose I have a clustered index on TransactionDate, and want to query by (WorkOrder, TransactionDate) Should I declare the non-clustered index […]
2005-01-20
3 reads
RE: Using Char(13) to insert a return in a note field.
This is a shot in the dark.. but have you tried this : CHAR(13) + 'Comment 1' + ': ' + rtrim(so.comments_1) + CHAR(13) + 'Comment 2' + ': ' + rtrim(so.comments_2) + CHAR(13) + 'Comment 3' + ': ' + rtrim(so.comments_3) + CHAR(13) + 'Comment 4' +': ' + rtrim(so.comments_4) AS Record_Notes if that […]
2005-01-12
SQL Server 2005 Express Edition Overview
Comments posted to this topic are about the content posted at http://msdn.microsoft.com/library/defa
2004-10-15
1 reads
Sleeping Process - DTS Package -- nothing .. then success
I have a source (pervasive) I hit and when the customer starts backing it up to tape my DTS Process goes into a sleep mode and eventually ends with a 'success' status but no data. Can you tell me why....sleep .... success ... no data?
2004-10-07
1 reads
Where is help for T-Sql CE?
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-06-25
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers