Is there any index available on custid column?
I believe you are using SQL 2000 and 32bit server. There is option called AWE which allows you to use more RAM if you have. Please check out enabling...
Thanks. Is there any performance impact in creating large drives like 300GB, or we need to smaller drives. I had read that the no. of drives(data...
Hi moh_hassan20, Thanks for excellant solution. I really wanted the computation like this. It gives me an idea how to compute the disk allocation....
The DB Size is 800 GB, you mean 800/60 = 13 drives? or logical file group 5 * 60 = 300 GB and 300 * 4 drives? Sorry I couldn't get you.
Hi Dinakar, Thanks for the link and it talks about the general practices for storage area. But my question is more about allocating space & drives...
Hi Experts, I need to plan space and drive allocation for 800 GB sharepoint database and I was asked to give the requirements/specification to system...
Thanks Preethi and All. I will try those scenarios.
Thanks. I think it definitely helps. One more question though, If the .mdf file is corrupted, do I still able to take log backup(with no_truncate)...
Hi Dinesh, I understand I can do point-in-restore before or upto 3pm(since I have backup until 3pm), but what about the transactions or data which...
Hi All, I need some clarifications regarding log backup and restoration .... Assume that I have full backup at 3am, diff backup at 2pm and log backup...
All, Thanks for the reply, I try out the options suggested. Thanks once again. - Bala
Hi All, I am trying to take a database backup from a sql server which is on 'x' domain and trying to store it on 'y' domain and I get the below...
Is it possible to set up replication from sql 2000(publisher) to sql 2005(subscriber)? It is not showing an option to subscribe to SQL 2005 server....
Is it possible to restrict a SQL login if it is connecting from a particular host/system?Or Is it possible to restrict a SQL login if it is...
It is SQL 2005
I have scheduled a reindex which is failed on last sunday. I didn't find any reason for the failure. I have checked the event viewer and sql server...
Hi, I have 4-5 databases that include the production db on the production box. Intermittently my tempdb grows to larger size. I am sure my...
Satya, I had read the first URL already. My problem is even after reindexing the avg_fragmentation_in_percent is still 100% for some index id, why...
Our DB production server is built with 64bit type O/S. We are thinking to install 32 bit MOM Agent on our DB server which is 64 bit. Any idea...
Separate names with a comma.
