React

Technical Article

RE: Poor Trigger Performance - Why?

  • Reply

I'm having a similar problem.  Much smaller tables, about 6 columns, 140000 rows.  Looking at the query plan, the read from the inserted table is by far the most expensive operation, even though there is only a single row in it.  Other operations that are kicked off by the trigger, which should be much more […]

You rated this post out of 5. Change rating

2005-04-12

Technical Article

RE: Inserting Image Data

  • Reply

Hello there.Actually, I was able to figure it out. The problem was not in the database, but in the code. I was using Visual C++ with ADO and some third-party classes, however, the "geniuses" decided to NOT allow you to save IMAGE binary data, they casted it to VARBINARY!Thank you .... at least I know […]

You rated this post out of 5. Change rating

2005-01-17

Blogs

Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox

By

Are you ready to take your SQL skills from theoretical to tactical? If you've...

Set a Runtime Variable in an Azure DevOps Pipeline

By

Note: I DO NOT recommend this. Any changes to a pipeline should be in...

A New Word: Symptomania

By

symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...

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