I am trying to find an article/post from Joe Chang that I read that goes over the merits of a SAN vs. local disk enclosures. It discussed how the...
I have the following settings in my clients server and sql server OS: Windows 2003 Enterprise SP1 RAM: 5GB boot.ini: /3GB /PAE...
My clients have been asking that I add Windows Authentication to my data analysis application. I told them that if that is done the users will have...
If the sub query for an IN and EXISTS clauses are identical is there a reason to use an IN clause? Will the results ever be different? Also, most...
I have an analytical application that uses ADO to access sql server 2000. My client is getting multiple denials (see below) on their firewall on port...
We have a client that is having intermittent performance issues. The data files are located on a SAN but the SAN is also being used by an imaging...
There are two instances of sqlservr.exe in task manager and I don't know why. There is only one instance installed on the server that I can see....
The only articles that I have found relating to AWE are for windows 2000. They all state that the "/3GB /PAE" switches are needed for 8GB of RAM, so...
My clients have databases that are primarily for data analysis. Are there any hints/options that I should use for tables that are read only? I am...
We have a have a set of procedures that run every night to load data. One of the steps takes about 3 minutes to run but on Sundays and Tuesdays it...
In my application I give my clients the ability to SET QUERY_GOVERNOR_COST_LIMIT for each user. One of my clients is setting the value at 120 for...
I have two tables, one has 75k rows (date dimension) and the other has 10 million (fact table). The fact table has many columns with a value from the...
I would like to give users of my application to be able to reset another user's password. I wanted to use sp_password but the user that is logged in...
Will sql server uses any indexes when tables are joined across databases on the same server? Are there any other performance considerations? Thanks...
I have a client that I want to make sure that I give them the correct information. They have a NT 4 server that has 7 physical drives. When the...
Separate names with a comma.
