(Muthusamy Anantha Kumar) Every organization has a system of weekly reboots or monthly reboots etc., for all their servers. When it comes to clustered servers, the reboot cycle would be little different. Usually the active node in the cluster will always be active, unless there is a failover initiat

(Nils Bevaart) As a SQL Server DBA, one of my tasks is to monitor the performance of our databases. Our primary database holds the data of over 18 million people. A web-based application queries the database with a variety of search options. When examining the performance of these queries, most perf

A user-defined function returns results that are not correct for a query if all the following conditions are true: • The GROUP BY clause contains two or more references to the same user-defined function. • The calls to the user-defined function pass the same first parameter. • The user-d

(Andre Vigneau) I have been working for a while in administering and developing for SQL Server, MSDE, even with the new SQL Server Express. I have put in place a resident database to store tools I use to perform administrative tasks and statistical collection tasks. I also have an automated system t

(Dina Fleet Berry) There are many times when using SQL Server 2000 Query Analyzer to debug Sql statements is a better choice than debugging in the .NET Visual Studio environment. I generally choose SQL Query Analyzer to debug SQL if the bug is narrowed down to the SQL stored procedure. If you have n

When you install your custom application, or you uninstall your custom application, a problem occurs. The Microsoft Windows Installer service that is named Msiexec.exe tries to repair Microsoft SQL Server 2000 Desktop Engine. SQL Server 2000 Desktop Engine is also known as MSDE 2000. This problem on

(David Talbot) In a normal application development environment, you will likely need to use encrypted columns to store passwords if you are using a custom users table. The need for encrypted columns is even greater in the world of HIPPA compliant applications. HIPPA requires encryption of any data t

(Barrie Sosinsky) Database indices are a key determinant in your database performance. Every time you run a query, create a view or cursor or retrieve a dataset in some way, you are hitting up against indices. Put aside the instances where you are building indices on the fly; all of the longest-runn

(Jimmy Nilsson) In this article, the author presents the pros and cons of using globally unique identifiers (GUIDs) as the datatype for primary keys in SQL Server 2000. In doing so, he shows you test results that hint of performance characteristics and introduces you to a special type of GUID that h

(Santveer Singh) Sometime we come across specific request from our managers or users that needs to explore system tables and database. Today I got the same kind of request from my manager. He needs a list of all database users with database roles. I looked here and there but I didn’t find any he