ignore identity column

Technical Article

RE: More Efficient Storage Method of a LARGE cross-reference table

  • Reply

CHARINDEX(field, ‘~’ + UserID + ‘~’) > 0That technique is sssssssssslllllllllllooooow. you can't use indexes with it. I works on small sets but you are going to get table scans. Also the length of it will constraint the design unnecessarilyI will stick to the Normalized Association table (UserID,NoteID) and create two indexes so that you […]

You rated this post out of 5. Change rating

2005-03-07

Blogs

Our Contributions Towards a Stronger Open Source Future

By

Whether you’re a developer at an agency or an aspiring creator, you can trust...

Rebuilding a SQL Server Database Transaction Log

By

“Could you help me, we deleted the database’s transaction log file and now that...

Copying Content from One Databricks Unity Catalog Catalog to Another

By

I had a couple of clients who were moving content from development catalogs to...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers