Hi Friends, If you put a view on a 1 billion row table for data processing. Getting the min date etc. What wouldyou say the process time would be?...
Hi Friends, I am trying to create a backup maintanence plan through Management Studio. when I saved this plan its give me following error: "apply...
Hi Friend, I m in the middle of designing of a big database. The expecting size of DB is 600 GB. What u guys suggest. Is it better to creat one big...
Hi Friends, Anyone have idea what is the overhead of varchar datatype in SQL server 2005. I remember that in SQL server 2000 its 1 or 2 bytes...
Hi Friends, I have set unlimited growth of database in option but after some point my database do not grow & give error. Any light on this ? thanks...
Hi Friends, I have one question here. Do SQL Server 2005 provide data encryption at database level in cluster mode ? I know Sql 2005 provide data...
Hi Friends, I need ur help in one of issue. Please suggest... Does SQL Server 2005 support an XML datatype? If so, can you explain to me how an...
Hi friends, I need a your help. Could you please tell me any good book on SQL server 2005 for DBAs. Thanks a lot for your help in advance. Regards,...
Hi, DBCC DBREINDEX updates Index statistics. Does it use FULLSCAN or use the sample size. Please let me know. Thanks !! MAST ITS IMPOSSIBLE TO...
Hi Friend, I dont have access to direct box on my Database server (because of security reason). But I come to know that CPU utilization of the server...
Hi Friends, Can I restore one server from other server ? I have one server A. I take the backup of this A server on the local hard drive of this...
Hi Friends, Is there anyway I can check what text a process is running ? I mean one process is running on SQl server & I have spid of that. Can I...
Hi Friends, I have to copy backup from one server to another standby server. I have script which select latest backup & then copy it to another...
Hi Friends, One of my user unable to see any DTS package created on the server. I can't give him SA access. Is there any role by which he can access...
Hi, Do anyone have link for Master database restortion or Can you please guide me step by step ? Thanks a lot for your help. Regards, MAST ITS...
Hi Friend, I have created a DB with tran. log intial size 4GB by mistake. But now when I m trying to shrink this file, its not going through & I...
Hi Friend, Currently my server store data into non-unicode format but now we need to store data into unicode format. Can anyone please tell me what...
Hi Friends, I have a prod. server I need to take backup from this server & restore on the standby server. But one the database have 5 files at...
Hi Friend, I need to check that any user hit one of my DB in last one month. How can I check that ? Please guide me. Thanks much for ur help.....
Hi friends, I have remane the DB Instance & server (at OS level). Now when I am going to disable the job its give me error; error 14274, can not...
Separate names with a comma.
