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...
Thanks , but I am not able to see the 'Publication Identification' under publication for my PULL subscriptions , is there any way to figure that out...
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...
Thanks ,but it did not show in case of PULL subscription as dist agent running at subscriber end , for PUSH there is no issue...
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...
Thanks but as i said fiber mode is already off ,any other pointers?
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...
for Replication Distribution server i am getting which i dont understand so any help is appreciated... Object reference not set to an instance of an...
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...
Thanks Sathya , but i am still looking my answer that until i run dbcc updateusage and 'available space' shows as 0 and i leave this as it is,is it...
My customer is coming up again , does any body know for sure?
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...
Inside SQL Server 2000 Memory Management by Ken Henderson says 'It is usually disk drive space. Specifically, it is space in the system paging...
Separate names with a comma.
