July 2007

  • SQL Server Integration Services how-to

    SSIS makes managing SQL Server data a more customized and flexible task. Our SearchSQLServer.com experts are no exception to those reaping the benefits of this tool. Take a look at this collection ...30 Jul 2007

  • 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 t...30 Jul 2007

  • SQL Server queries with DMVs for examining bottlenecks

    Here, you'll find queries incorporating Dynamic Management Views (DMVs) that display information on some of the common SQL Server performance bottlenecks.26 Jul 2007

  • T-SQL commands vs. XML AUTO in SQL Server

    XML functions may use many more resources than the standard T-SQL commands, depending on the amount of data. SQL Server database expert Michelle Gutzait shows performance implications for each when...26 Jul 2007

  • Identify performance bottlenecks in SQL Server

    Identifying and resolving bottlenecks is key to a high-performing SQL Server. Types of bottlenecks include memory, disk and CPU bottlenecks. SQL Server MVP Hilary Cotter explains how to locate thes...26 Jul 2007

  • Detect performance bottlenecks with these tools

    Detect performance bottlenecks in SQL Server with these four tools: Task Manager, System Monitor, SQL Profiler and Dynamic Management Views (DMVs).26 Jul 2007

  • Create baseline and consider bottleneck symptoms

    First, create a performance baseline as a SQL Server activity record. Next, look at memory, disk and CPU to find performance bottleneck symptoms.26 Jul 2007

  • Podcast: Log shipping in SQL Server: Basics to best practices

    SQL Server database administrator Eric Johnson explains how to back up your primary database and restore it to a secondary server through log shipping. He'll explain log shipping setup via SQL Serv...24 Jul 2007

  • Why restore a full SQL database vs. a failed filegroup?

    To restore a failed file or filegroup vs. restoring the entire SQL Server database could be both a time-and space-saving technique. But consider these reasons why avoiding a complete database resto...23 Jul 2007

  • Top 10 SQL Server development questions

    Development in SQL Server can put you in a crunch and seeking for a quick solution. We've compiled a Top 10 list of your frequently asked questions when it comes to SQL Server development. In this ...20 Jul 2007

  • Building a data warehouse in SQL Server: Eight tips to get started

    When building a data warehouse using SQL Server technologies, there are some challenges you may face. SQL Server database expert Baya Pavliashvili addresses some of the most common issues.17 Jul 2007

  • SQL Server password management: Six risky assumptions

    You think your SQL Server passwords are invincible? Ha! IT security specialist Kevin Beaver explains why you should plan before testing passwords, focus security attention outside your main databas...11 Jul 2007

  • 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 an...09 Jul 2007

  • Installing SQL Server 2005 on a SQL 2000 machine

    So, you've decided to upgrade your databases to SQL Server 2005. Database expert Michelle Gutzait highlights some issues that may arise when installing a SQL Server 2005 instance on your SQL Server...02 Jul 2007

  • Compatibility of SQL Server 2005 and 2000 coexisting

    So, you've decided to upgrade your databases to SQL Server 2005. Database expert Michelle Gutzait highlights some issues that may arise when installing a SQL Server 2005 instance on your SQL Server...02 Jul 2007

  • SQL Server 2000 and 2005: Six compatibility concerns

    So, you've decided to upgrade your databases to SQL Server 2005. Database expert Michelle Gutzait highlights some issues that may arise when installing a SQL Server 2005 instance on your SQL Server...02 Jul 2007