2001-06-13
3,505 reads
Articles
Service Pack 1 for SQL Server 2000 Released
In this article by Brian Knight, he explores how to install Service Pack 1 for SQL Server 2000 and some of the catches. This service pack is one of the largest in SQL Server history. Learn what was fixed here.
2001-06-13
8,242 reads
Clonation and the Case of Table Dolly, Part 1
In software, clonation can sometimes turn out to be an extremely helpful technique. More often than not, in fact, you catch yourself duplicating instances of running objects to produce nearly identical objects to be managed codewise in a fairly independent way.
2001-06-13
1,123 reads
Using Index Intersections
First introduced in SQL Server version 7, Index Intersection gives you new options for creating indexes on tables to maximize performance.
2001-06-12
5,397 reads
Using SET to Tune Your Queries
On the surface, the goal of performance tuning a query seems simple enough. Essentially, we want our queries to run faster. This article looks at how the STATISTICS IO and STATISTICS TIME options can help us tune queries.
2001-06-12
2,431 reads
2001-06-11
2,480 reads
Product Review: Log Explorer 2.0
Anyone that has ever forgotten a WHERE clause in an UPDATE or DELETE syntax still has the bruises. Log Explorer 2.0 has a way of reversing your mistakes by peering into the transaction log and rolling back transactions. This, week Brian Knight reviews this product.
2001-06-11
7,743 reads
How to Use the Windows Synchronize Manager with Pull Subscribers
If you have Microsoft Windows 2000 or Microsoft Internet Explorer 5.0, Pull subscribers can use the Windows Synchronization Manager (WSM) to synchronize with the publisher.
2001-06-11
1,664 reads
Using XP_FILEEXIST
XP_FILEEXIST gives you the ability to find files and directories. Find out how else you can use it in this article.
2001-06-08
20,416 reads
Creating SQL Objects on the fly with VB and XML
A method for creating databases and other objects on the fly and distribute these objects to multiple servers.
2001-06-08
1,944 reads
Blogs
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Forums
Merry Christmas 2025
Comments posted to this topic are about the item Merry Christmas 2025
The Reindeer Count
Comments posted to this topic are about the item The Reindeer Count
Events of System_health extended event serious or not
I have listed the event names present in my system_health extended event report. Based...
Question of the Day
The Reindeer Count
How many reindeer does Santa have pulling his sleigh? (according to the famous song) Hint, the answers are not base 10.
See possible answers