One of our favorite authors is back with a great how-to on log shipping. This isn't the baked in log shipping, this is a code your own solution that gives you a starting point for your situation. Even if you don't need it now, it's worth looking at to gain a better understanding of how shipping works.
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!
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Assignments aren’t just tasks to submit—they’re opportunities to build understanding, discipline, and problem-solving skills....
Comments posted to this topic are about the item What's new in R 4.6
Comments posted to this topic are about the item Interesting Changes in R, which...
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers