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
MMOExp EAFC25 to the Major New Features
FC 25: A Comprehensive Guide to the Major New Features "Same game with different...
MMOExp NBA2kMT to controlling the rock
NBA 2K25: The Top 5 Players with the Best Ball-Handling Skills In the world...
MMOExp Dark And Darker for evaluating the power
Dark and Darker: How Does Gear Score Work? In Dark and Darker, gear is...
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