Site 1 , Server A and B (Production) Site 2 ,Server C and D (Pre-production) Site 1 is production and Mirroring is happening between A and B i need...
What should be the design consideration for OLAP system in terms of disk Management (RAID Levels etc) and how it differs with OLTP disk design?...
We will be getting transition from other team and have 400TB Datase , Can somebody point me to handle best practices for this much big DB and if...
In SQL Server 2000 replication under Publication folder on right panel column 'Type' i was able to see if it is 'PULL' or 'PUSH' but same i am not...
I have PULL Subscription in SQL 2005 where disribution agent is running on subscriber but through replication monitor it is not showing me its...
Hi, Recently some body played with our SQL Server and removed our Sys admin group login and we dont have builtinadmin as login and no SA Password can...
I am having issue with SQL Agent while starting , it does not restart until i explicitely run sp_configure 'Agent XPs', 1 , also not able to create...
Hi , I heard there is no need of sysadmin to monitor replication in sql 2005 and one role is required , can any body point me to that role/permission...
Hi , i have hundreds of SPs where i need to find where some specific hints/keywords are used like 'nolock' or keyword like noexpand with indexed...
Can any body point out the benefit of x64 Bit SQL 2K5 over x32 Bit SQL 2K5 on windows server 2003 x64 Bit, thanks much
We are going for SQL 2K Upgrade to SQL 2k5 Upgrade for Active-Passive Clusters (windows 2K3)and thinking for below plan , can anybody confirm if we...
Hi , We are planning for ‘in place’ SQL Upgrade from SQL 2000(Ent. Edition with SP4) to SQL 2005 Ent.Edition with SP2 for 1)Replication...
i have a question as dbcc updateusage correct page and row count inaccuracies in catalog views, and I had problem that my DB space available was...
Hi , I have a question possibly a basic but need to clarify ,as 4 GB address space is divided into user and kernel partition for windows in x86...
Hi , I am looking some information regarding scenario in SQL 2005 where project team wants 3 servers running as active and one extra server will...
Hi , I have scenario where we have huge tables Transactional replication and now requirement is to re-initialize the subscription , what are the...
Hi , I have two publication of two different database and they are replicating data to other server but both are sending data to same database with...
Hi , can any body pls confirm what are the best practices for databases used only for reporting purposes ,our requirement is users should also be...
Separate names with a comma.
