SQL Server Magazine April 2003
[Focus]
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 Michael Otey
[Features]
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 Steve Kass
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 Julian Watson
[SQL Server Savvy]
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 Brian Moran
Use the DBCC OPENTRAN command to identify the longest running transaction in your database.
By Brian Moran
Here's a simply way to determine how long a particular instance of SQL Server has been running.
By Brian Moran
Learn how to create a SQL Server Profiler trace that will let you capture queries executed against small subsets of tables in your database.
By Brian Moran
[Editorial]
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 Michael Otey
[SQL Seven]
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 Michael Otey
[Inside SQL Server]
Think you know a lot about SQL Server memory? Think again.
By Kalen Delaney
[Mastering Analysis]
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.
By Russ Whitney
[T-SQL Black Belt]
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.
By Itzik Ben-Gan
[Answers from Microsoft]
Do you need to defragment your database but still maintain high availability? Microsoft offers several options for defragmenting tables in SQL Server 2000.
By Microsoft's SQL Server Development Team
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.
By Microsoft's SQL Server Development Team
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 Microsoft's SQL Server Development Team
[Exploring XML]
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 Rich Rollman
[Letters]
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.
By Various Authors
[New Products]
Check out the latest SQL Server-related new and improved products.
By Carolyn Mader
|
