By Itzik Ben-Gan, 04/26/2001
Use mathematics to reduce the code necessary to solve your business problems.
By Russ Whitney, 04/26/2001
Here is the May MDX puzzle.
By Brian Moran, 04/26/2001
SQL Server MVP Brian Moran answers readers' questions.
By Samuel Penn, 04/26/2001
If the process of synchronizing databases exceeds your maintenance window, try this technique for using transactional replication without the Microsoft Snapshot Agent.
By Wayne Snyder, 04/26/2001
SQL Server data types (including integer, character, numeric, datetime, and uniqueidentifier) can behave in surprising ways. Keep them in check with these tips.
By Michelle A. Poolet, 04/26/2001
Create a customizable entity relationship (ER) template for your complex database designs.
By Paul Thurrott, 04/26/2001
Datamation and eWEEK award SQL Server 2000 their highest honors for data warehousing, business intelligence (BI), and enterprise systems development.
By Itzik Ben-Gan, 04/26/2001
Enhancements in SQL Server 2000's Profiler let you thoroughly and efficiently trace server activity.
By Russ Whitney, 04/26/2001
The kinds of questions that distinct count queries can answer are useful in analyzing retail product sales. Distinct count queries can also apply in other areas. Find out how to ...
By Ken Spencer, 04/26/2001
Trim your workload, streamline your site, and wow your visitors by using ASP to develop your Web pages.
By Paul Thurrott, 04/26/2001
SQL Server 2000 mounts a challenge to the premium-priced UNIX platform with record-breaking performance results on a Windows 2000 Datacenter-based Unisys ES7000 machine.
By Kevin Christensen, 04/26/2001
DBAs need all the tricks and tools they can find to perform their duties. Using SQL-DMO objects in VBScript files should be an important part of every DBA’s toolkit.
By Rich Rollman, 04/26/2001
Rich Rollman answers questions about expanding a hierarchy by using self-referential columns and about how to store an exact decimal value in a real or float column.
By Kalen Delaney, 04/26/2001
SQL Server 2000 divides its tracing functionality into two separate but connected components: SQL Trace on the server and SQL Profiler on the client. Learn how and when to use ...
By Kalen Delaney, 04/26/2001
The SQL Server sleuth tracks down the truth about fill factor and page splitting.
By Paul Thurrott, 04/26/2001
The new MultiServer mode that lets users distribute applications across as many as three servers leads the BackOffice Server 2000 features that address the needs of midsized ...
By Itzik Ben-Gan, 04/26/2001
The Index Tuning Wizard is a tool that accepts a workload of activity against your SQL Server and makes recommendations about creating appropriate indexes for the workload.
By Russ Whitney, 04/26/2001
Here is the solution to April's MDX puzzle.
By Richard Waymire, 04/26/2001
Richard Waymire tells readers how to append extra characters to a fixed-character column, how to troubleshoot fluctuations in backup tape speed, and more.
By Kalen Delaney, 04/26/2001
C2 auditing is necessary if you are running a C2 certified system. SQL Server 2000 is a C2 certified system.
By Rick Dobson, 04/26/2001
Develop your basic SQL-DMO programming skills by creating tables in Access projects.
By Michael Otey, 04/26/2001
SQL Server lets you accept all the default installation settings and just walk away—with an installation that's less than reliable. Make sure you do your part to make SQL Server ...
By Michael Otey, 04/26/2001
Here are Michael Otey's selections for the top seven Win2K improvements from a SQL Server perspective.