SQL Server Performance Tuning
Database mirroring is a primarily software solution for increasing database availability. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model. There may be a requirement to disable database mirroring for a database that is no longer required. To achieve this, delete the ENDPOINT for the database and [...]
Why can’t I install multiple instances of SQL Server Integration Services components on the same physical server?
The SQL Server Integration Services (SSIS) component of SQL Server 2005 runs as a service, and only one instance of SSIS can run on a single physical server at a time. If you are working with one instance of SQL Sever on a single physical box, the SSIS service will by default use the default [...]
Question: On our SQL Server 2000 system every Sunday early hours we have a scheduled job to execute the database optimization tasks such as DBCC DBREINDEX and DBCC CHECKDB which is running without any problems. But during this time we are getting errors and alerts about user database transaction log is out of free space. [...]
When using SQL Server Management Studio Express I get the error “SQL Server does not allow remote connections”. How to resolve this error?
Question: In SQL Server 2005 when trying to connect to a remote database with SQL Server Manager Studio Express, I get this error: “An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does [...]
SQL Server Management Studio takes a long time to load, how to improve the load performance of this tool?
In general the SQL Server Management Studio takes at least 10 to 15 seconds to load on a user machine. Sometimes the SSMS tool can take a long time to load when there are a lot of SQL Server instances, this problem may also occur on the new 64-bit SQL Server 2005 platform. One resolution is to [...]
The SQL Server 2005 Standard Edition isn’t better or worse than the SQL Server 2005 Enterprise Edition, and vice versa, they are just different and offer different features to meet the specific needs of different groups of customers. If you need the specific features of SQL Server 2005 Enterprise Edition, which are mostly related to [...]
SQL Server 2005 Express Edition is the next version of MSDE and is a free, easy-to-use, lightweight, and embeddable version of SQL Server 2005. Free to download, free to redistribute, free to embed, and easy for new developers to use immediately, SQL Server Express includes powerful features such as SQL Server Management Studio Express, for [...]
Performance delay when a full-text query is executed on a SQL Server with no connection to Internet.
To utilise the FULL-TEXT performance features in SQL Server 2005 the DBA might need to run a full-text query on a SQL Server instance. Occasionally the user might notice a delay in performance to produce the results of full-text query in a timely manner. This issue arises because Full-Text engine for SQL Server uses the [...]
My manager has asked me to put together a plan for a backup server for our production server running SQL Server. Should I use log shipping or clustering?
Most of the production SQLServersI have run across don’t have any easy or quick way to failover to a working server should they fail. Generally, most people hope their production SQL Server never fails. And in the back of their minds, they think they know what to do to recover should the worst happen, but [...]
How do I find the most frequently occurring value for all data in a table? How do I find that value per group?
As always, there is more than one way to get a correct result. But which way gives you the best performance? Let’s first build a simplified test scenario to illustrate what we’re after. CREATE TABLE #t (ArticleGroup CHAR(2), Price DECIMAL(8,2)) INSERT INTO #t VALUES(‘SP’, 1.2) INSERT INTO #t VALUES(‘SP’, 1.2) INSERT INTO #t VALUES(‘SP’, 2.1) [...]