SQL Server 2005

Today I was searching the internet for an easier way to see if a file exists. As I was searching I came across several undocumented SQL Server 2005 procedures. They are:

xp_fileexist
sp_MSforeachdb
sp_msforeachtable
sp_msdependencies

Now knowing that these undocumented extended and stored procedures exist, they will definitely make my job a lot easier. The source that [...]

Welcome back…
Today I am going to give the answers to the interview questions that I received regarding SQL Server 2005.
Question 1
What are the different versions (editions) in SQL Server 2005
Answer
SQL Server Express Edition, Workgroup Edition, Standard Edition, Enterprise Edition
Question2
What is the difference between RAID 0 + 1 and RAID 1 + 0
Answer
Here the argument [...]

Hi again…
I wanted to share with you my latest experience in interviewing for a Senior SQL Server Production (no development) DBA position in Southern California. As we all have come to learn that the “typical” process is a phone interview and then if they like you they invite you for an in person interview. Typically [...]

Today I was working with SQL Server 2005 SSAS (SQL Server Analysis Services) and I needed to look into the server to see if there were any issues. My users were telling me that the pivot tables in their Excel spreadsheets were taking longer than usual. Microsoft does not allow you to run [...]

Hello again… I hope you had a good holiday weekend for those of you who had the holiday off. Last night I came across a stored procedure that used SQL Server reserved words in the SELECT and INSERT statements. Since I am using SQL Server 2005, the words that came up as “reserved” [...]

Hello and welcome back to my blog… today I was needing to change the port number on one of my production SQL Server 2005 boxes. Wouldn’t you know it… I had to look for it because it has been awhile since I have had to change the port number on the server. So [...]

In SQL Server 2005 there several ways to detect a CPU bottlneck.  The first way to detect a bottleneck is by looking at the System Monitor counter Processor: % Processor Time.  If the value of this counter  is greater than 80% for  15 to 20 minutes in duration, then it is a good indication that [...]

Welcome back and happy new year! Today I wanted to share with you my experience with SQL Server 2005 Reporting Services on a 4 node cluster.
The other day we had failed over one of the nodes to test functionality to see if the Reporting Services databases failed over as well. After the fail-over [...]

I thought today I would share with you a great way to move SQL Server logins from one SQL Server 2005 server (source) to another SQL Server 2005 server (destination).  In the past I have tried to use DTS to move logins (passwords and SIDs) from one server to another but without much success.  As I [...]