By Michael Otey, 06/17/2003
SQL Server reached significant milestones in performance and overall market share this past year. But Microsoft faces the challenge of keeping SQL Server affordable and easy to ...
By Russ Whitney, 06/17/2003
Challenge yourself to create an MDX query that finds the most recent nonzero sales amount for each Los Angeles customer for each quarter of 1997.
By Brian Moran, 06/17/2003
Many DBAs forget the performance impact of auto-growing files when managing space for tempdb.
By Michael Otey, 06/17/2003
Microsoft provides several tools for working with BLOB objects. Here are seven of the most important BLOB access technologies.
By Various Authors, 06/17/2003
Here's a quick review of common replication concepts and terms.
By Itzik Ben-Gan, 06/17/2003
When your query needs to find items with certain relationships, you can use relational division, or you can try these new tricks.
By Russ Whitney, 06/17/2003
This VBA macro steps through Excel and reformats the data in a way that makes it easy to import into Access so that you can use it to build a cube.
By Various Authors, 06/17/2003
Readers write in about DTS portability tips, selling OLAP's benefits, a query for analyzing set relationships, and more.
By Kalen Delaney, 06/17/2003
This system (pseudo) table can help in your troubleshooting, but use it carefully.
By Brian Moran, 06/17/2003
By the end of the year, Microsoft will roll out a new SQL Server product called Reporting Services that will let you manage the entire reporting life cycle, from authoring, to ...
By Michelle A. Poolet, 06/17/2003
Catalog inventory management can be one of the most complex challenges for database designers and developers because inventory is constantly growing and changing. Here's a basic ...
By Carolyn Mader, 06/17/2003
Check out the latest SQL Server-related new and improved products.
By William Vaughn, 06/17/2003
ADO.NET connection pooling improves the performance of .NET applications, but a busy application can sometimes accumulate connections, overflowing the pool and sinking ...
By Brian Moran, 06/17/2003
Learn how to find the size of the files in tempdb when SQL Server was last started.
By Russ Whitney, 06/17/2003
Working with any OLAP solution can help you better understand the technology, but using data that has personal meaning can help you learn even more about OLAP. Here's a practice ...
By Jeannine Hall Gailey, 06/17/2003
When you use ActiveX controls along with the administration functionality that SQL-DMO provides, you can programmatically administer, customize, and control an entire replication ...
By Shane Dovers, 06/17/2003
DTS package logs can provide valuable troubleshooting information--if you can keep them under control. By using this article's VBScript code with a scheduled SQL Server Agent ...
By Brian Moran, 06/17/2003
Do you need to call a Visual Basic .NET object from the INSERT trigger? Explore your options...