I found the information athttp://www.sql-server-performance.com/jc_system_storage_configuration.asp . Below is what I was looking for. Fiber Channel...
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...
Thanks Satya. I have read the Microsoft links before and I believe that my settings are correct that is why I am not sure why only 3GB is being...
I have the following settings in my clients server and sql server OS: Windows 2003 Enterprise SP1 RAM: 5GB boot.ini: /3GB /PAE...
This is one of the threads that I came across while researching if my application can use application roles....
Great news, it looks like SQL 2005 will allow the stored procedure creator to define which user to execute all sql (including dynamic) as. Check out...
That would help with the auditing (I already have one built into the app though) but they will still circumvent the vertical (fields available) and...
satya, Thanks for the helpful link. Based on the information that I gave you am I correct in not allowing Windows Authentication? Daniel Reber...
Frank, All users authenticate to a table of users in my database that has an encrypted password. The application logs into sql server with the...
Frank, Thanks for the information. Dan
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...
Thanks for the insight, that was helpful. Is there a protocol that is faster than the others? Thanks Dan Reber
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...
Thanks for you insight. Daniel Reber Datamasters, Inc
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...
OK, thanks. Daniel Reber Datamasters, Inc
That makes sense. Would you have any idea what "MSSQL$DTC" would be? Thanks Dan Reber
The other client has a service named "MSSQL$DTC" Dan
quote:Originally posted by LuisMartin A second instance was installed before and then removed? No, a second instance was not installed and then...
Separate names with a comma.
