The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
With SQL Server Yukon in private beta, Microsoft's Eric Brown explores the release's long-awaited development and administration features. And don't miss a closer look at Yukon's Common Language Runtime (CLR) integration and T-SQL enhancements.
By Russ Whitney
Learn how to narrow a list to show only the items that are relevant in a given situation.
Learn a way to put a number into context to determine its relevance.
Microsoft provides an example of how to create drillthrough support for Excel’s PivotTable components, but the example can be hard to follow. Here’s an explanation to help you use the example better.
By Rich Rollman
Bulk loading data into tables that use identity columns as primary keys used to require some sticky programming to properly set the value of foreign keys. See how XML Bulk Load has been enhanced in SQLXML 3.0 SP2 to automatically set foreign key values.
By Andrej Kyselica
As a major new release of SQL Server, Yukon presents an opportunity for developers and DBAs to use their existing skills while taking advantage of powerful new .NET capabilities such as CLR-based code, rich UDF data types, and security enhancements.
By Michelle A. Poolet
A database designer has a problem with her supertype-subtype database design, and the simple answers she finds don’t work for her. Find out how she learns that even less-than-ideal solutions can work in the right circumstances.
By Brian Moran
Using the DROP_EXISTING clause can be a huge time-saver when you need to change the clustered index on a table that also has nonclustered indexes.
By Itzik Ben-Gan
You've heard a lot about the CLR, which lets you use .NET languages to write database code. But take a peek at what's new in T-SQL! Improved trigger functionality, better error handling, and separate date and time data types are only the beginning.
By
With the Yukon release of SQL Server now in private beta, SQL Server Magazine talked with Microsoft’s Eric Brown about the release’s long-awaited development and administration enhancements and how you can start preparing for the changes ahead.
There can be a big performance difference between using table variables and temporary tables. In most cases, temporary tables are faster than table variables.
By Kalen Delaney
New query-processing techniques make the optimizer's job more complex and yours simpler.
By Michael Otey
Microsoft has had plenty of time to add many new features to SQL Server’s next release, code-named Yukon. Here are seven important features that they have announced for Yukon.
Readers agree with Michael Otey's assessment of what needs to happen to boost SQL Server's reliability reputation. Also, note the correction of a trace flag number from "Sysprocesses in SP3."
By Carolyn Mader
Check out the latest SQL Server-related new and improved products.
Microsoft's powerful performance in the nonclustered TPC-C results has shattered the glass ceiling barring the database server's way to enterprise class deployment.
advertisement