-
Licensing a standby server for SQL Server replication
Is a license needed for a standby server if it's used for SQL Server replication? Get that answer and a comparison of SQL Server log shipping to replication.
-
Can I encrypt and restore a database backup in SQL Server 2005?
Discover the best solutions for encrypting, decrypting and restoring a database in SQL Server 2005.
-
SQL Server trigger vs. stored procedure to receive data notification
Learn why using a SQL Server stored procedures vs. a trigger can be a preferred method to retrieve data notification from a database field.
-
Configuring SQL Server with a changed computer name
Find out how to reconfigure all aspects of your SQL Server after your computer name has been changed.
-
Using MDX and UDM in a SQL Server Analysis Services environment
Learn the specifics of Multidimensional Expressions (MDX) and the Unified Dimensional Model (UDM) in a SQL Server Analysis Services environment.
-
Troubleshoot Web service issues in SQL Server 2005 Reporting Services
Learn why your Web service in SQL Server 2005 Reporting Services (SSRS) is not responding. You could be missing Reporting Services configurations.
-
SSIS error message due to installation problem on SQL Server 2005
If you are receiving an error message in SQL Server Integration Services (SSIS), your problem might be with the installation of the SQL Server 2005 client tools.
-
Ordering the results of a SQL query
Learn how to order the results of a SQL query when using case statements in a SQL Server Reporting Services (SSRS) report.
-
Tool to synchronize two SQL Server databases
Discover a tool that synchronizes two SQL Server databases allowing changes to one SQL Server database to update on the other.
-
Troubleshoot SQL Server 2005 temporary table performance problems
Learn how to troubleshoot SQL Server 2005 temporary table performance problems when a stored procedure execution time is slower than usual.
-
SQL Server tools don't appear in menu after SQL Server 2005 install
After installing SQL Server 2005, the SQL Server tools may not appear in the start menu. Our expert explains how to troubleshoot this problem.
-
How to retrieve SQL Server database disk space in use
Find out where to look for the current amount of SQL Server database disk space being used in your environment.
-
Use SQL Profiler to find long running stored procedures and commands
Troubleshoot long running stored procedures with SQL Server Profiler by adding events to find the command with high run time.
-
Performance tuning for SQL Server 2005 and Exchange running on SBS
To avoid performance problems when running multiple instances of SQL Server 2005 with Exchange on Windows SBS, refer to these expert best practices.
-
Upgrading to SQL Server 2008 advantages and hardware requirements
Planning an upgrade to SQL Server 2008? Our expert weighs in on advantages and hardware requirements you should consider before upgrading to SQL Server 2008.
-
Maintain large SQL Server database and resolve website 'Timeout Error'
If you have exceptionally large SQL Server databases, refer to these best practices for proper database maintenance to steer clear of a website 'Timeout Error.'
-
Code to restore SQL Server databases in VB.NET
Learn how to restore a SQL Server database in VB.Net using this ADO.Net code sample provided by our expert.
-
Workaround to Reporting Services error in SQL Server Express
Discover a SQL Server workaround to fix an error that pops up when trying to view a report in the Report Manager when using Reporting Services in SQL Server Express.
-
How can I export stored procedures in SQL Server 2005?
Export stored procedures in SQL Server 2005 with these step-by-step instructions in SQL Server Management Studio.
-
Using BULK INSERT to insert rows from SQL Server dataset to table
Learn how to use BULK INSERT to import all SQL Server dataset rows to a table.
-
Tips for tuning SQL Server 2005 to improve reporting...
There are a few things you can do to tune SQL Server for improved reporting performance. Here are some generic and Reporting Services-specific tech...
-
Storing and searching for image files in SQL Server
Learn about working with image files in SQL Server, including advice on using queries to locate them, in this expert answer.
-
Manipulate column names in a SQL Server table
Learn SQL Server commands to manipulate column names in a table and turn column names into variables or rename SQL columns.