E-Mail:

sqlsquirrel

Using SQL Server Reserved Words

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” [...]

Locating The Server Port In SQL Server 2005

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 [...]

Detecting A CPU Bottleneck

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 [...]

STB files on SQL Server…

Today a junior DBA asked me about the files with the .STB extension were for. Then I realized that other DBAs out there may not know what the .STB files are for and what creates them. The .STB files stand for STand By (STB). These files are created when a database is [...]

Common Bottlenecks In SQL Server

When your application experiences a performance problem chances are some aspect of your application has or is hitting a bottleneck. What exactly is a bottleneck? Per Wikipedia a bottleneck is a phenomenon where the performance or capacity of an entire system is severely limited by a single component. A common single component [...]

The Different States Of Worker Threads

Today I was going through one of my production SQL Servers and looking at the connections\spids it dawned on me that some people that are new to SQL Server might not know the different “states” of a worker thread. Here are 3 states that you will come across when executing sp_who or sp_who2:
Running - [...]

Reporting Services On A Cluster

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 [...]

The Value Of A MCDBA

Hello and welcome back again…
After a little break I thought of what else people would be interested in and I thought about education. In my years of experience I have not seen an employer “want” or more to the point “request” a person that has an MCDBA. Employers seem to “want” people with [...]

Custom Stored Procedure To Restore A Database!

Here is a stored procedure that will restore your database without having to remember the SQL syntax of the RESTORE DATABASE command in SQL Server 2000. This stored procedure is to be compiled and run from MSDB. The stored procedure reads from the registry to figure out the data and log path of [...]

SSIS In A Cluster

Today I wanted to share with you my “painful” experience with having SQL Server Integration Services (SSIS) installed on a cluster. I just got done installing and configuring a 4 node (3 active 1 passive) cluster. It has Windows 2003 and SQL Server 2005 Enterprise edition installed on it. I got the [...]

28 queries / 0.203 seconds.