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!
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.
Index Statistics in SQL Server 7.0
A look at Index Statistics in SQL Server 7.0 and how to maintain them.
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.
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.
Professional SQL Server Programming
Steve Jones reviews Robert Viera's Professional SQL Server Programming text.
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.
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!
SQL Server 6.5 Data Page Structure
This article presents the technical details of the page layout for data in SQL Server 6.5
Blogs
A word on misogyny/sexism in cybersecurity/IT
By Brian Kelley
Recently, on a post celebrating a female professional earning a significant achievement within the...
Getting Started with Azure SQL Database – A Beginners Guide
By John
Last Updated on September 24, 2024 by John Morehouse Years ago, I saw the...
Small Data SF 2024
By Steve Jones
I have often made an effort to attend conferences in the past to grow...
Forums
+27640409447..,; ZIMBABWE SSD CHEMICAL SOLUTION FOR SALE IN BOTSWANA,ANGOLA,GAB
+27640409447..,;;' Hello Everyone!Our chemical solution, can clean deface+27813334083 currency, such as EUROS, POUNDS, DOLLARS,...
How to attach Database created in higher version to lower version of SQL Server
I have attempted to attach a database created in a higher version of SQL...
SQL Query Optimizer Supporting Parameterized Query and WHERE Clause Optimization
I am looking for a SQL query optimization tool that can enhance my query...
Question of the Day
Disable All the Indexes
How do I disable all the indexes on the dbo.Logger table?
See possible answers