2001-08-06
3,793 reads
Articles
Creating Folders Using VB and Recursion
Read this article to learn how to use recursion to simply the task of creating multiple levels of folders on disk. Perfect for creating a folder hierarchy for holding backup files!
2001-08-03
13,020 reads
SQL Server 2000: New Features Provide Unmatched Ea
SQL Server 2000 includes many new features that extend its capabilities as a high performance relational database system with a rich development environment. This article presents an overview of new product features including AWE support, new data types, new user-defined and built-in functions as well as enhancements in trigger functionality, indexing, collation, and property definition.
2001-08-03
3,578 reads
Index Statistics in SQL Server 7.0
A look at Index Statistics in SQL Server 7.0 and how to maintain them.
2001-08-02
3,277 reads
Optimizing DTS Data Loads
In this article, Brian Knight shows you the different ways to load data in DTS and how to optimize the Data Pump task for data loads. He also examines performance numbers on other data loading tasks in DTS.
2001-08-02
7,499 reads
Microsoft SQL Server 2000 Security
This document introduces SQL Server administrators and developers to the new security features of SQL Server 2000. In addition to outlining the new features, there is a detailed discussion about how to best implement security in a Microsoft Windows® 2000 domain environment as well as source code examples.
2001-08-02
1,383 reads
Professional SQL Server Programming
Steve Jones reviews Robert Viera's Professional SQL Server Programming text.
2001-08-01
3,545 reads
SqlServerCentral Announces New Guest Columnist
We've got a new guest columnist! Click here to find out a little bit about Mindy Curnutt, then read her first article for SqlServerCentral.com.
2001-08-01
2,308 reads
Using Stored Procedures for SQL Server DML
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!
2001-08-01
12,819 reads
2001-07-30
3,309 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers