Designing your application so that Stored Procedures are the only database objects that are accessed is generally the best practice. Agree? Disagree? Read this article by guest columnist Mindy Curnutt to see what she thinks!
This article presents the technical details of the page layout for data in SQL Server 6.5
The following stored procedure will demonstrate the use of cursor metadata. Using cursor metadata we can get information about an SQL statement and use that information to dynamically generate other code such as HTML or other stored procedures.
In this month's article I will cover an aspect of SQL Server that always generates a great deal of, well, shall we say "discussion"—triggers. Love them or hate them, SQL Server 2000 will change they way you think about triggers and will probably alter the way you design your applications. Specifically, this month I will dive into cascading referential integrity (RI) and the new INSTEAD OF and AFTER trigger concepts in SQL Server 2000.
The downturn in the economy has left quite a few technical people out of work. This ongoing article describes the experiences over the past two years of Steve Jones. Reader experiences are requested and the article will be updated weekly.
Are you responsible for keeping your organization's database systems up and running? Are you the one they call in the middle of the night if the database server is down? If so, the SQL Server 2000 Operations Guide is for you.
Is this a book you should read? Spend a few minutes reading the review to find out!
Our first contest will begin July 23rd! We’ll be giving away a free Wrox book titled: SQL Server 2000 Database Design
to the individual who refers the most users to SQLServerCentral.com throughout the duration of the contest. The contest will last from July 23rd until July 29th.
To insure that each referral counts, make sure that each person you refer has your SQLServerCentral.com registered email address. Good luck!
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
By alevyinroc
In the blink of an eye, summer has passed. I don’t know about you,...
By Chris Yates
In today’s digital landscape, data is both a strategic asset and a potential liability....
Comments posted to this topic are about the item Change Tracking Data Retention Options
Comments posted to this topic are about the item Requiring Technical Debt Payments
Comments posted to this topic are about the item Using the FP-Growth Algorithm to...
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=4 xxx);What are the possible choices for xxx? See possible answers