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 … Continue reading
Monthly Archives: January 2009
SQL SERVER 2005 RESOURCE FAILS TO COME ONLINE ON CLUSTER AFTER CHANGING THE SAN DRIVE TO ADD MORE DISK SPACE
TweetWe 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 … Continue reading
SQL SERVER 2000 Cluster FAILS TO COME ONLINE ON OTHER NODE
TweetRecently 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 … Continue reading