PASS Update #18
Eric Wisdahl posted some questions on my last update, and I thought I’d reply here to make my answers more...
2009-10-27
1,051 reads
Eric Wisdahl posted some questions on my last update, and I thought I’d reply here to make my answers more...
2009-10-27
1,051 reads
Not very often I run across something with zero matches in a search engine, but had it happen recently. I had set up a simple demo of a sparse column set and happened to look at the execution plan, was interested to see that the Compute Scalar was backed by ConvertSVtoXML. This was on a select from a table with one row, and then, being a little more curious, updated it with an xml fragment I saw a call to ConvertXMLtoResv. I’d venture that those serve to convert back/forth from XML storage.
2009-10-15
1,219 reads
I ran across this article about networking sins a while back and have had it on my list to share....
2009-09-25
2,229 reads
In the next week or so I’ll be upgrading the SQL 2005 server that has the SQLSaturday database and I’m...
2009-09-24
1,829 reads
I’ve been on the board just about 8-1/2 months, so I’m not doing too bad on updates, but think I’ll...
2009-09-18
1,080 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-09-10
845 reads
I enjoy woodworking as a hobby and as I try new things I find that my work habits during the...
2009-08-31
2,092 reads
I’ve touched on it some in the past, but it’s a question that comes up a lot when we discuss...
2009-08-21
2,360 reads
We’ve just posted our core guidelines for technical content on sqlpass.org. The short story is there are three main ways...
2009-08-17
976 reads
The post snapshot script in replication allows you to make changes to the subscriber after you complete a snapshot. Unaware of this feature? Watch this episode of SQL School.
2009-08-11
11,743 reads
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Comments posted to this topic are about the item DML Trigger Types
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Comments posted to this topic are about the item Choose the Second One
How many types of DML triggers are there?
See possible answers