SQL Server Magazine November 2004
[Focus]
Transactional replication helps maintain data availability, but if data becomes unsynchronized, you might not be able to quickly synchronize by using conventional techniques. You can synchronize selected data on the fly--without disrupting business.
By Gary Zaika
[Features]
To avoid stale data in your Web applications' cache, try this trigger-based solution.
By Tim McCarthy
Learn to use XML for Analysis to build an analytic application for any device, language, or platform that supports XML.
By Rob Ericsson
[SQL Server Savvy]
Here are two examples of using foreign key constraints to improve performance.
By Brian Moran
Learn how to disable C2 auditing to stop a constant SQL Server Profiler trace.
By Brian Moran
[Editorial]
The question for SQL Server customers isn't whether to apply Windows XP SP2 but how to do so effectively.
By Michael Otey
[Inside SQL Server]
Grab your tools and get at the root of indexes' b-tree structure. The information you find can help you make your queries faster than ever.
By Kalen Delaney
[Solutions by Design]
Short timelines and limited budgets often force designers to forgo formal design testing. But you can use this question-and-view technique to integrate testing during your design creation.
By Michelle A. Poolet
[T-SQL Black Belt]
These five examples show you how to query aggregated data over time.
By Itzik Ben-Gan
[New Products]
Check out new and improved SQL Server-related products.
By Dawn Cyr
[SELECT TOP(X)]
The newest MSDE debuts as SQL Server 2005 Express--a free, powerful, relational database engine. Here are SQL Server 2005 Express's six best new features.
By Michael Otey
[Ask Microsoft]
Microsoft's Patrick Conlan shares the best way to retrieve data from an active archive database and an inactive archive database.
By Microsoft's SQL Server Development Team
Microsoft's Patrick Conlan describes how to change a column's data type from numeric to float with the least impact on data availability.
By Microsoft's SQL Server Development Team
Microsoft's Gert Drapers tells readers what the UserOrAlias column's values mean.
By Microsoft's SQL Server Development Team
Microsoft's Richard Waymire explains how to use sp_helpdb to identify files and filegroups.
By Microsoft's SQL Server Development Team
|
