The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Read all about the new Reporting Services tool for managing the complete reporting life cycle. Then, learn how to use SQL Server's Transactional Replication with Queued Updates feature and a technique for implementing server-side paging with SQL Server.
By
SQL Server Magazine Innovator Award grand-prize winner Altan Arslan shares his winning solution, which creates significant performance improvements for an international investment bank.
By Brian Moran
Named instances didn't exist when Microsoft released SQL Server 7.0, the company added them in SQL Server 2000. You can work around this problem by adding an alias for the SQL Server 2000 named instance using the Client Network Utility.
Readers write about the blurring of lines between DBA and OS administrator duties and some features they'd like to see Microsoft add to SQL Server.
Cross-database chaining is a new configuration option in SP3 that you can enable for individual databases by using the sp_dboption command. Cross-database ownership chaining opens up several serious security holes and should be avoided.
The timeout is hard-coded to 30 seconds for queries running from the Graphical Query Designer, and you can't override the default timeout value, but you can copy the query into Query Analyzer and control the timeout setting in the Options menu.
Microsoft released SP3a shortly after SP3, and the company lists three differences between the two service packs.
Enterprise Edition won't run faster than Standard Edition unles your hardware supports more than 2GB of memory and four processors, but there are three minor exceptions.
By Itzik Ben-Gan
T-SQL doesn't support certain ANSI SQL set options. But that doesn't mean you can't achieve the same effect with T-SQL. Find out how.
By Carolyn Mader
Check out the latest SQL Server-related new and improved products.
By Michael Otey
The Internet and the emergence of new protocols have driven computing to new levels. The threat from viruses and network intruders has never been higher. Here are seven steps to setting up better security for your SQL Server systems.
Ironically, although Microsoft and SQL Server got their start at the low end of the market, that’s exactly where they’re now the most vulnerable.
By Sameer Dandage
If you need to maintain multiple database servers at multiple sites and synchronize all the data, SQL Server has a solution to make your job easier--SQL Server’s Transactional Replication with Queued Updates can help.
By Andrew Rosca
Paging is necessary in most Web applications, but accessing a large number of records can create a bottleneck that cripples your system. This server-side paging technique that lets you access millions of records and still avoid performance problems.
By Martin Voegele
Read all about the new SQL Server 2000 tool that has customers singing Microsoft's praises. Reporting Services, slated for release to manufacturing by the end of the year, handles the complete reporting life cycle.
By Kalen Delaney
Joins can be a big part of query optimization, but which join type is right for each query? Find out how the optimizer chooses.
By Rich Rollman
Roll out the red carpet! Yukon's on its way, bringing great news for XML users: an xml data type that brings better functionality than any earlier SQL Server release.
Query cost estimates are just what the name says--estimates. The estimated cost information is a great way to get a feel for how expensive a query is, but you can't map the estimated cost to a useful prediction for exact response time.
advertisement