By Editors, 09/29/2008
Check out new and improved SQL Server–related products from PROPHIX Software, AVIcode, Panorama Software, and Embarcadero Technologies.
By Shaunt Khaldtiance, 09/29/2008
Here's a T-SQL stored procedure that you can use to identify tables without indexes, indexes that aren't being used, and indexes that aren't being used efficiently.
By Tyler Chessman, 09/29/2008
Use Business Intelligence Development Studio (BIDS) to customize package logging.
By Michael K. Campbell, 09/29/2008
See why the author gives a thumbs-up to the new version.
By Pinalkumar Dave, 09/29/2008
Pick up 7 basic query analysis rules from Dave.
By Michael Otey, 09/29/2008
This product can improve the performance of your SQL Server systems if they're constrained by network bandwidth.
By William Sheldon, 09/29/2008
Draw upon your ADO.NET skills to start using ADOMD.NET
By Itzik Ben-Gan, 09/29/2008
Learn how to handle temporal data in SQL Server queries despite limited support.
By Readers, 09/29/2008
You can use the TOP clause to limit the transaction size, but there's a trick to using it: You need to keep track of which rows have already been updated so that you don’t update ...
By Andrew J. Kelly, 09/29/2008
In creating a server-side trace, your goal is to capture the events you're interested in and store them in on a locally attached disk on the server. Use these T-SQL commands to ...
By Anne Grubb, 09/29/2008
Sound off about what cloud computing means for your SQL Server career and share your insights about improving database application performance.
By Richard Ding, 09/29/2008
Use this custom solution to check error logs in a mixed SQL Server 2005 and SQL Server 2000 environment.
By Michael Otey, 09/29/2008
Reduce the stress of performing a system restore—follow these SQL Server best practices.
By William Sheldon, 09/29/2008
See how to build an MDX query against a cube.
By Eli Leiba, 09/29/2008
Use this password-cracking tool to check the complexity of the passwords being used for SQL Server database logins.
By Kevin Kline, 09/29/2008
Find and organize your server connections using this open-source remote connections manager.
By Bill McEvoy, 09/29/2008
T-SQL offers three types of built-in functions, including scalar functions. Scalar functions let you perform a wide variety of operations, such as retrieving dates and replacing ...
By William Sheldon, 09/29/2008
Take advantage of your T-SQL skills to learn MDX query basics.
By Michael Otey, 09/29/2008
How can you help your organization choose the edition of SQL Server 2008 it needs? Michael Otey takes a quick tour through the options that are available.