January, 2009

Due to any issue, you may want to rerun SQL 2000 SP4 upgrade. SQL 2000 Service Packs are cumulative. But when you re-run SP4 it only updates 7 Scripts those are new with SP4. This could be useful when SQL Server is already on SP3 and due to some reason...

We have seen several issues where installation of Service Pack/Hotfix/GDR/CU fails to install on one or more components of SQL Server 2005. In this blog , I have tried to include few troubleshooting tips and tricks for these kinds of installation failures...

While running your application on SQL CE v3.1 databases you may observe slowness in the performance of some of the queries especially those which involve querying the primary key. In Sql server databases when you create a Primary Key on a column of...

We have observed a number of issue now where in clustered instance of sql server 2005 fails to come online after performing changing on shared disk on a cluster. As mentioned in my previous posts if the sql server fails to come online we need to start...

We have observed a common issue which is faced by many of our  customers who export the result set from DTS package to excel worksheet. DTS package that exports results to an existing excel workbook appends the data  each time you run it. ...

Recently I encountered a case wherein clustered instance of sql server 2000 fails to come online on other node of a 2 Node Cluster.  Usually for such cases we need to start troubleshooting by checking the Error log of the sql server from the server...

I've seen a couple issues where SQL 2005 SP3 setup failed with below error for database engine and tools. Customer had installed SQL 2005 and SP2 from network location (using mapped drive) and is concerned that problem is due to install being a network...

We have configured Merge replication in SQL Server and we have the replicated constraint's name on the subscriber is different from the constraints on the publisher. It is possible that we will have the constraints on the subscriber even after they have...

Most of the Customers using sql server 2000,2005 and 2008 have this doubt in their mind when using parallelism in sql server. Why Do I see more threads per SPID in sysprocesses than MAXDOP? The above question is being addressed in the following...