SQL Server Magazine November 2002
[Focus]
Trying to keep up with changing data in your reports? You can provide variable-width crosstab reports by using dynamic SQL. But ADO.NET's relational features provide a more flexible, efficient, and secure solution.
By Burton Roberts
[Features]
For accuracy and performance, you need to make sure that all IP addresses in your tables are valid. Here's how to write a CHECK constraint that validates character strings containing IP addresses.
By Itzik Ben-Gan
When you write a query, sometimes you want only a yes or no answer. In these cases, instead of using SELECT to return a rowset, you can execute an ADO.NET action command to get the specific information you need quickly.
By William Vaughn
[SQL Server Savvy]
Reading procedure code can provide valuable tips about how SQL Server works.
By Brian Moran
[Editorial]
Already, 64-bit SQL Server running on the Itanium 2 processor with Windows 2000 Advanced Server Limited Edition 1.2 has set a new SAP SD-user benchmark score.
By Michael Otey
[SQL Seven]
Web Matrix is a great way to get your feet wet using ASP.NET without shelling out the money for a full copy of Visual Studio .NET. Here are the seven best things about Web Matrix.
By Michael Otey
[Inside SQL Server]
Trace flags can be helpful for troubleshooting, but make sure you know what they do before you use them.
By Kalen Delaney
[Mastering Analysis]
From analysis to final decision, every business process requires collaboration among team members. Here’s how you can use DSO to add collaboration features to your next analytic application.
By Russ Whitney
[Solutions by Design]
In the early stages of a new career, everyone makes mistakes that prove to be costly lessons. You can shorten your adjustment period by avoiding these hidden traps.
By Michelle A. Poolet
[T-SQL Black Belt]
It's a kind of magic: Create four set-based solutions to a common SQL problem.
By Itzik Ben-Gan
[Answers from Microsoft]
Microsoft’s SQL Server development team not only describes how to call one stored procedure from within another in SQL Server 2000 and 7.0 but also presents caveats for maintaining optimum performance in both processes.
By Microsoft's SQL Server Development Team
Microsoft’s SQL Server development team unlocks the key to character limitation when a reader uses a system stored procedure in a script.
By Microsoft's SQL Server Development Team
If two rows contain the same number, certain queries might fail. Locking in a row’s incremental counter value might be the solution.
By Microsoft's SQL Server Development Team
Here are two ways to create and load update files to a remote site.
By Microsoft's SQL Server Development Team
Creating a separate log-reader agent on a database during transactional replication is a no-no, but you can create a new Distribution Agent when you add a new publication.
By Microsoft's SQL Server Development Team
You can effectively streamline your INSERT operation by adding records to two tables at the same time, but there’s one pitfall you should watch out for.
By Microsoft's SQL Server Development Team
Microsoft’s SQL Server development team describes two techniques for updating sales data from one business location to another.
By Microsoft's SQL Server Development Team
When you want to store text shorter than the 8000-character varchar data type limit, you have three options—depending on your SQL Server release. Microsoft’s SQL Server development team explains the pros and cons of using each.
By Microsoft's SQL Server Development Team
[Exploring XML]
To organize your database, you usually normalize the data to maintain optimum performance. But XML documents aren’t normalized, they nest their elements instead. So how do you define an XML view on a normalized database? Read on.
By Rich Rollman
[Letters]
Readers ask about an easier way to restore to a new server, how to delete all the rows from two related tables, how to create two time dimensions in a cube, and more.
By Various Authors
[New Products]
Check out the latest SQL Server-related new and improved products.
By Carolyn Mader
|
