Microsoft SQL Server 2005

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

  • Table partitioning with SQL Server 2005

    SQL Server 2005 offers improved database performance. One key upgrade is the table partitioning function, which, among other things, can yield significant benefits for queries executed against large tables. In this tip, see how transactional and data...  Tip

  • Synchronizing Analysis Services 2005 databases in SQL Server

    Early versions of Microsoft's Analysis Services did not support straightforward methods for migrating analytical databases. The synchronization feature provided in Analysis Services 2005 simplifies the process of copying the source server to the dest...  Tip

  • Mirrored backup and restore commands in SQL Server 2005

    Mirrored backups in SQL Server provide an extra layer of data protection. Learn how mirrored backup commands work with media sets ("media family") to minimize data loss. You'll also see how to restore a missing mirrored backup set from a different me...  Tip

  • SQL Server 2005 permissions capabilities

    In SQL Server 2005, more permissions can be given at both the instance and database level, compared to previous releases. Permissions can also now be inherited. Here are some examples to illustrate this SQL Server 2005 security feature.  Tip

  • SQL Server 2005 Express: Beyond the basics

    It might be a scaled down version of SQL Server, but SQL Server 2005 Express Edition delivers advanced performance. Windows expert Serdar Yegulalp explains how, including using it in custom applications as a data engine, securing an instance of SQL E...  Tip

  • SQL Server filegroups for backup and restore

    SQL Server filegroups have hundreds of significant uses in your database. What will be your backup and restore strategy for these filegroups? Database administrator Eric Johnson examines filegroup sizes and scenarios and shows you how to optimize bac...  Tip

  • New T-SQL features in SQL Server 2005

    Have you experienced the new T-SQL features in SQL Server 2005? SQL Server database administrator Eric Johnson outlines four of its hottest development features: error handling, ROW_NUMBER function, DDL triggers and CLR.  Tip

  • Differences between varchar and nvarchar in SQL Server

    The differences between varchar and nvarchar for SQL Server data types are detailed here by SQL Server expert Serdar Yegulalp. Learn how each data type is stored differently, how to mix and match them and what changes were made to varchar and nvarcha...  Tip

  • T-SQL error handling with Try...Catch blocks

    T-SQL Try…Catch blocks in SQL Server 2005 are key for transaction management via error handling. Also called exception handling, error handling now offers developers improved capabilities and system functions to handle errors when executing T-...  Tip

  • Piecemeal restore with SQL Server 2005

    SQL Server 2005 extends the partial restore functionality with piecemeal restore, a feature that ultimately allows you to recover your entire database as your schedule permits. Baya Pavliashvili details the benefits of piecemeal restore and outlines ...  Tip

Back to top