Server Configuration

SQL Server 2005 Replication and Third Party Tool
I am looking into possible options for replicating data for reporting purposes. I have found transactional replication to work best for realtime reporting, source used for user transactions and target for reporting. I have come across a large vendor database 50GB on SQL Server 2005 where reports are taking too ... 30 Apr 2010 16:19

Statistics Creation on SQL 2005
My db has "auto create statistics" on. For some reason, there are quite a few indexes that don't have statistics. What could be the cause? Thanks in advance ... 4 May 2010 04:39

Disk Speed
Hi all I am being handed a Dell 2950 for a SQL server 2005 standard deply but I will need to put all new disks in it. I was told the best I can do is SATA 7200 RPM. I was going to RAID5 this to about 2TB. Is 7200RPM going to be too slow?? This will be hosting sharepoint services and a goldmine database r... 6 May 2010 05:17

SQL Workgroup Licensing
The manufacturer is now saying they operate under the MS Royalty Licensing agreement and this is what allows multiple installs of SQL up to the license count of the hosted application. But, they will not provide technical support, which if I'm understanding royalty licensing correctly they must do to be in com... 3 May 2010 10:57

double mail sent
Hi! I've a problem on mdaemon on W2003 Sometimes I send 2 same messages.... and I think that using webmail I don't have this problem (only with outlook express) Can you help me? Thanks ... 29 Apr 2010 07:53

Broken foreign key?
Hello, one or two of my colleague has managed to break a foreign key in our database, I'd like some help to understand how this have happened. This might be a long story so bear with me :) There are two tables involved in this. The "DataRepository" that holds data that are to be sent to a "DataAddress". Thus t... 7 May 2010 06:44

How to keep format when importing Excel into SQL.
Can anybody help me please? When I import Excel file into SQL, a field that formated as 0000000000 (custom), loosing leading zeros. I tried to change data type in SQL after importing. No luck. I appretiate any help. ... 27 Apr 2010 22:27

Remove Primary Key
Hi. I want to remove the primary key on table on any column if exists otherwise do nothing. Regards, Muhammad Bilal ... 27 Apr 2010 19:06

SQL 2005EE - 64 memory question
I have an 8 core SQL2005 EE server on Win2003 EE with 16GB of memory. Is it a problem if I have the SQL Server set to use 14GBs of the memory leaving 2GBs for the OS? I can see where the SQL server is using the 14GBs and wonder if there are times when the server begins to have memory pressure issues. Use AWE to ... 30 Apr 2010 17:27

FK references same column in same table
Hi, I have been reviewing the database objects in one of our development team's databases and have found something that i haven't seen before. There is a foreign key on one of the tables that has been created on the same column that it references i.e ALTER TABLE [dbo].[tbl_Address] WITH CHECK ADD CONST... 27 Apr 2010 19:06