SQL Server Articles


Categories : Performance | Audit | Business Intelligence | Clustering | Developer | Reporting | Windows Server | SQL Azure | Powershell | ASP.NET | Other .NET

Installation of SQL Server Clustering

Pre-Installation Spot Verification Review the Windows Event Log, it should not have any errors before you begin the SQL Server clustering installation. Ping from one node to another to verify a good connection and a latency of less than 500ms. In regard to the services listed under Pre-Install Preparation Checklist above, make sure all of […]

Un-Install a SQL Server Cluster: Step-by-Step

If SQL Server Cluster Install ends up in errors and fails, consider doing a clean up of the cluster install and then re-start it. Here is a step-by-step process which gives a clean un-install of a SQL Server Cluster environment. Step-1 Execute sqlrem.bat Execute sqlrem.bat with following parameters on each node: Syntax: sqlrem.bat <sql install […]

What is New with SQL Server Clustering on Windows 2003

Security Patch – Server Accessibility If latest security patches are not installed on SQL Server, you may see following error message in event log. You are running a version of Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (also called MSDE) that has known security vulnerabilities when used in conjunction with the […]

Basics of SQL Server Clustering

If your AAA critical SQL server faces a memory board failure, how long will be the outage? How much will this cost your business in productivity and data availability to the users? Being a SQL Server DBA can be demanding and stressful, as the success of your application is often a function of your database […]

How Clustering Works

In a two-cluster node Active / Active setup, if any one of the nodes fail, then the another active node will take over the active resources of the failed instance. It is always preferred while creating two-node cluster using Windows 2000 Advanced Server and Microsoft Clustering Service, that each node be connected to a shared […]

How to Perform SQL Server Row-by-Row Operations Without Cursors

SQL cursors have been a curse to database programming for many years because of their poor performance. On the other hand, they are extremely useful because of their flexibility in allowing very detailed data manipulations at the row level. Using cursors against SQL Server tables can often be avoided by employing other methods, such as using […]

SQL Server Connection Pooling Myths

Many of us are already familiar with connection pooling and understand to some degree its importance in web and SQL Server programming. We’ve all heard the adage that “connections are expensive” and “pooling is good”. This article will examine the topic in more detail, bringing to light some of the finer points of connection pooling. […]

SQL Server Hardware Tuning and Performance Monitoring

The hardware configuration that SQL Server runs on top of can make or break you. How do you know how much hardware is really needed by your applications? How do you know if your applications have grown to the point where they are now overloading your system?  In this article I will give you the […]

SQL Server Index Fragmentation and Its Resolution

While there is no doubt of the benefits of adding indexes to your tables, and for the most part you have to do little work to keep the indexes maintained, some maintenance is required as indexes can become fragmented during data modifications. This fragmentation can become a source of performance issues with your queries. So […]

Demystifying the SQL Server DATETIME Datatype

When you follow online communities dedicated to SQL Server with open eyes, you certainly notice a whole lot of questions are closely related to the DATETIME datatype in one way or the other. Obviously, working with DATETIME not as easy as it may seem. To me this seems kind of strange. My believe is that […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |