By Readers, 01/24/2007
If you discover a loop in a stored procedure, you might find that the code iterates thousands of times before the loop exits. One way to improve the performance of loops is to ...
By Itzik Ben-Gan, 01/24/2007
Use your logic to escape a cave that presents unique challenges.
By Michael Otey, 01/24/2007
SQL Server started out a couple of steps behind other database platforms, but with new and future releases focused on change management and end-to-end business insight, Microsoft ...
By Andrew Potter, 01/24/2007
Create better reports faster by using templates, custom assemblies, and these layout and performance tips.
By Kimberly L. Tripp, 01/24/2007
In SQL Server 2005, you can use a new GUID function called newsequentialid() to populate your uniqueidentifer column.
By Itzik Ben-Gan, 01/24/2007
Occasionally, the SQL Server optimizer chooses a plan that isn't the most efficient one possible. Itzik shows how he figured out how to produce the lowest-cost plan for a ...
By Michael K. Campbell, 01/24/2007
Spotlight on SQL Server lets you see real-time SQL Server activity, making it easy for you to monitor the performance of your databases.
By Brian Moran, 01/24/2007
Is your I/O subsystem not properly equipped to handle the workload you're placing on it? Adding a faster system probably won't magically solve the problem. You need to change your ...
By Blake Eno, 01/24/2007
Check out new and improved SQL Server-related products.
By Editors, 01/24/2007
Our editors share insights from their conversations with InterSystems Corporation, GridApp Systems, and Network Appliance.
By Kalen Delaney, 01/24/2007
Some SQL Server behaviors change in subtle ways from version to version. Learn about three such changes that might surprise you.
By Michael Cassens, 01/24/2007
Check out DatabaseSpy if you routinely work in different database environments and need a multidatabase design and management tool.
By Michael Otey, 01/24/2007
SQL Server 2005 offers various types of data replication depending on your data replication needs.
By Kimberly L. Tripp, 01/24/2007
What's important to consider in designing a database? For optimal performance, you need to be mindful about three interrelated factors: indexing, maintenance, and statistics. ...
By Kevin Kline, 01/24/2007
With SQL Server 2005, it can be tough to create a stress test that actually stresses your system. Here’s a tool that can generate a load sufficient to overwork almost any system.
By Roman Rehak, 01/24/2007
The Native XML Web Services feature in SQL Server 2005 removes dependency on IIS to help you create robust, feature-rich enterprise database solutions. Here’s how the feature ...
By Itzik Ben-Gan, 01/24/2007
In this excerpt from a post on his Puzzled by T-SQL blog, Itzik demonstrates an interesting technique that the optimizer uses to optimize aggregates.
By John Jakob, 01/24/2007
Looking for a way to script database schema without buying a third-party tool? Here’s a Windows console-mode utility that uses SMO to script tables, stored procedures, views, ...