This articles covers a variety of techniques to let you bypass or conditionally execute code in a trigger based on criteria outside of the inserted/deleted tables. It also includes a contest that gives you a chance to win a copy of our book The Best of SQLServerCentral.com 2002!
New Author! The author tries to port a solution from Oracle and runs into a problem. Agree with the solution?
New product designed to help you move from one database platform to another. (Not Reviewed)
New Author! Jeff had some questions about fill factors - but no answers! He did some work and came up with a set of recommendations for how and when to set your fill factors to something other than the default.
Joseph has written a couple articles for us and forwarded this link to an article he wrote recently on text type columns. You can see more of his work at http://www.sqlservercentral.com/columnists/jgama/.
New Author! The first of two articles this week on fill factors, this article looks at the impact fill factor can have on performance and shows you the key tools and counters you use to assess the impact of changes to fill factor.
Database Workbench, a cross database engine development tool, version 2.4 has been released today, 11/10/2003. It now includes support for MySQL and has an extensive list of bugfixes and small enhancements with regard to InterBase, Firebird and MS SQL Server support.
This article shows how to do conditional multiple table inserts. While it is more script than we typically display, it's interesting and might get you thinking about other uses for the idea.
New book! This new book by Ken Henderson (author of other 'GURU' books abou SQL) promises an all inclusive approach to the internals. Sample chapters and other info available by following the link. We'll try to get a review up soon!
One of the most handy extended stored procedures in SQL Server is xp_cmdshell. This article will show you how to use it.
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Comments posted to this topic are about the item Increase Deadlock Detection
Comments posted to this topic are about the item A Tool is Better than...
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers