The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Explore whether you need the extra muscle that the new 64-bit version of SQL Server provides, see how to use T-SQL to retrieve hierarchical XML data, learn how to write rock-solid MDX, and more in this issue of SQL Server Magazine!
By Julian Watson
Using SQL Server to return an entire tree in XML format is becoming a common requirement. These step-by-step examples show you how to use T-SQL to retrieve hierarchical XML data.
By Brian Moran
Using an EXISTS check is more efficient than a SELECT COUNT(*) when you need to see if a particular value exists in a table.
By Michael Otey
Yukon will be here before you know it. And nothing would put you in a better position to hit the ground running with the upcoming SQL Server release than to start evaluating when and where to use the new CLR languages in your environment.
By Steve Kass
You think you've written a simple query that will return summary data from your SQL Server database, but the query fails! How can you find the reason for the query's unexplained demise? Elementary: Return to the basics of database normalization.
By Kalen Delaney
Think you know a lot about SQL Server memory? Think again.
A lot of people are confused about the differences between MSDE 2000 and SQL Server 2000, especially about how MSDE differs from SQL Server 2000 Personal Edition. Michael Otey counts seven important ways that MSDE differs from SQL Server 2000.
By Carolyn Mader
Check out the latest SQL Server-related new and improved products.
By Rich Rollman
Sure, your XML app is running fine now. But what if you need to transmit a new type of data through the same app later? With open content, you don't even need to know it's there.
By Itzik Ben-Gan
Here are some tips about using partitioned views, including how to circumvent the limitation on inserting data into tables through a partitioned view, and problems with using constants in the partitioning criteria.
Do you need the extra muscle that the 64-bit version of SQL Server 2000 brings to the table? See what's new, what's different, and what's stayed the same in the latest version of SQL server for the enterprise.
By
Do you need to defragment your database but still maintain high availability? Microsoft offers several options for defragmenting tables in SQL Server 2000.
Here's a replication tip for ensuring the data that your franchises transfer to your head office is synchronized and includes modifications from each branch.
By Russ Whitney
Challenge your skills with this month's MDX puzzle.
SQL Server doesn't rename directories as part of the upgrade process. Here's a renaming problem you might face when upgrading and how to handle it.
Filtering data effectively isn't always as simple as finding the top n items in a list. Here's one query that performs a more-than-basic filter--finding and ranking the top five products in each department in the FoodMart 2000 Sales cube.
MDX is powerful, but it can be more complex than SQL. You can make MDX's complex queries easier to handle if you break them into smaller parts. Here's a two-part method for making complex MDX manageable.
Use the DBCC OPENTRAN command to identify the longest running transaction in your database.
Here's a simply way to determine how long a particular instance of SQL Server has been running.
Readers give advice about configuring the Client Access ODBC driver for DTS data transfer between the AS/400 and SQL Server and ask about concurrent security role limits in Analysis Services.
Learn how to create a SQL Server Profiler trace that will let you capture queries executed against small subsets of tables in your database.
The Itanium chip marks a step in a new direction for processors and makes 64-bit computing possible. Here's what you should know about it.
advertisement