Interview by Lee Thé – Find out about the future of SQL Server 2000 and extreme scaling from Microsoft’s resident expert in large databases.

By Prashant Dahalkar – There are situations where you may have to rethink queries to tackle complex problems. Here is one of them. We had a table in a SQL Server database called NAMELINK where no primary key was defined. The structure was as follows:

By Vyas Kondreddi – Unfortunately, there is no built-in support for arrays in SQL Server’s T-SQL. This article provides 5 different techniques to simulate arrays in T-SQL, with working examples. It also provides you with links to additional information and books.

This article describes how to manually install SQL Server Books Online if they were not installed when the product was originally installed.

ClearData Consulting offers a one-day audit of your Microsoft SQL Servers to ensure secure, efficient systems. Our consultants will come on-site to monitor your system, perform system tests and interview your staff to look for possible ways to improve in the following areas:

By Russ Whitney – Analysis applications frequently contain confidential information. Here’s a scalable way to use MDX to determine which users can access sensitive information.

No, but autogrowth of data files blocks allocations of new extents because SQL Server blocks changes to the allocation pages, which keep track of which extents in the file are in use, during autogrowth.

Alexander Chigrik’s new backup/restore troubleshooting checklist is the first resource you should consult when attempting to diagnose and solve SQL Server backup/restore-related issues.

Need to calculate the current day, without the time? Michel Ulens, presenting a session on “Working Better With Linked Servers,” has a simple and efficient piece of code you can use:

by Drew Georgopulos – Learn how to determine the state of your indexes and understand whether that state should be changed. See how evaluating the construction and location of your system’s indexes and deciding whether to adjust their fill factors and padding can improve the system’s performance.