Microsoft XML Core Services 4.0 RTM
The core components to Microsoft XML parser have been updated and released to market. The update contains many bug fixes, new features and enhancements to performance.
2002-04-05
4,122 reads
Articles
Tame Those Strings - Part 9
Steve Jones continues his series on string manipulation. This articles examines the issues of quotes when implementing dynamic SQL.
2002-04-04
7,644 reads
2002-04-03
2,237 reads
Auditing Your SQL Server Environment Part I
Ever been placed into a new environment and couldn't
find an ounce of documentation? This article is the first in a series that will help you make an audit of your new environment
and determine if any SQL Server login does not have a password, has a password the same as the login name or a password that is only one character long.
2002-04-02
10,440 reads
Improving Text and Image Column Performance
This article is a case study of a performance problem at SQLServerCentral.com with our FAQ area using text columns. This will show you how to use the TEXT IN ROW feature built into SQL Server 2000 to improve the performance of these columns.
2002-04-01
6,658 reads
SQLServerCentral.com Launches April Contest
SQLServerCentral.com launched it April contest on April 1st sponosored by Lockwood Tech and SQL Server Magazine. Win LockWood Tech's Proc-Blaster Enterprise Edition, SQL Server Magazine, or Admin911 all for helping to build the SQL Server community.
2002-04-01
22 reads
AdminLog Added to the Freeware Library
AdminLog, by Lockwood Tech, has been added to the SQLServerCentral.com freeware library. AdminLog is a utility for managing projects, tracking bugs/tasks/assignments, etc.
2002-03-29
21 reads
Interview with Author Fernando Guerrero
Learn how to make the most out of ADO.NET and SQL Server. Find out how the new .NET Data Provider can boost SQL Server performance.
2002-03-29
1,053 reads
Non-Continous Replicaton and The LogReader
Last year Andy wrote about turning off the log reader as a way to reduce the overhead on a server, primarily when you have many logreaders running. In this follow up article he talks about the downside of using this technique and how the behavior of the logreader can be "tweaked" to make using non-continuous replication a little less of a headache.
2002-03-28
5,151 reads
Object Scriptr v1.0 Released as Freeware
Object Scriptr v1.0 for SQL Server 7/2000 by Rac4sql has been released as freeware on SQLServerCentral.com. The product quickly generates creation and drop scripts and insert statements.
2002-03-28
41 reads
Blogs
Run SQL Server 2025 and SQL Server Management Studio on macOS Tahoe
Short version You want to get this running as fast as possible. Do these...
The Roundup for T-SQL Tuesday #192
By Steve Jones
Last week I asked you to write about SQL Server 2025 and what things...
Writing Better Dynamic SQL
By SQLPals
Writing Better Dynamic SQL This updated and "sort" of a style...
Forums
SQL Server 2025 has arrived!
Comments posted to this topic are about the item SQL Server 2025 has arrived!
Don't Create Workslop
Comments posted to this topic are about the item Don't Create Workslop
What is the original database name?
Comments posted to this topic are about the item What is the original database...
Question of the Day
What is the original database name?
What is returned when this code is run?
SELECT ORIGINAL_DB_NAME()See possible answers