In most tables it is enough to have a stored procedure that performs Update Else Insert logic for data managment. However, in some cases we do not want to destroy the old data with an update statement. Instead we want to maintain history up to a certain number of versions. This article presents a method for doing so.
2001-08-27
3,289 reads
Robert Vallee has announced that he will release the source code to SQL Insider early to September 15th. On that date, members will be able to download the source code and make modifications to the program.
2001-08-27
37 reads
Give this test to your boss...only if he has a sense of humor!
2001-08-27
2,825 reads
Ever wonder what a DBA does? Ever had someone ask you what your job entails? Here's an overview of what a DBA does. Reader feedback will be used to update this article over time.
2001-08-24
9,094 reads
Are you thinking of becoming a master DBA? If so, find out how you can in this article.
2001-08-24
4,429 reads
Want to learn more about some of your favorite authors. Check out this interview with Louis Davidson, author of Professional SQL Server 2000 Database Design.
2001-08-23
2,948 reads
This article examines some of the common issues that may occur when installing SQL Server 7.0
2001-08-23
3,342 reads
A great deal of data in any RDBMS is hierarchial. This article presents a technique for aggregating this data.
2001-08-22
3,040 reads
Lumigent has updated their transaction log analysis tool to include a number of features that every DBA will find handy. Read this review of a great new product.
2001-08-22
6,323 reads
Microsoft® SQL Server™ 2000 allows you to restore transactional replication databases without reinitializing subscriptions or disabling and reconfiguring publishing and distribution. You can set up replication to work with log shipping, enabling you to use a warm standby server without reconfiguring replication.
2001-08-21
2,176 reads
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
Recently I received a cry for help over Teams. The issue was that an...
You can't handle the truth!! (about data integrity) A few good database administrators https://www.helpmasterpro.com/blog/a-few-good-database-administrators/...
I have installed Machine Learning with SQL 2022 Enterprise Edition and installed and configured...
Comments posted to this topic are about the item A Guide to SQL Security...
I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)I then run this in the Sales database:
USE Sales GO CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers