Thanks Elizabeth for the prompt reply. Below is the output. I am aware of the chances of db getting fragmented by shiniking but I dont have any...
Hi All. I have a database of 90 GB. Recenlty database size grew to 120 GB. When I checked files. I found few file groups with around 60%-70% empty...
Hi Mohammed, Where can I find -outputverboselevel setting? I am using sql server 2005 with sp2. Thanks Sachin
Hi Experts, I have configured transaction replication beween 2 servers with updatble subscription in SQL Server 2005 with SP2. Everything goes fine....
Hi All, I am trying to configure Transactional replication with updatable subscription sql server 2005 with service pack 2. Creating distributor and...
You can find SQLbrowser.exe under "C:Program FilesMicrosoft SQL Server90Shared", But to run this exe, please follow the below method. 1) Click on...
Thanks Dineshasanka, But SQL refractor is more into formating. I want a tool which can scan through all the objects and prompt if there is any...
Hi All, Do we have any tool to do code review for SQL Server 2005 code (Stored procedures, functions, views and TSQL)?. A tool which can help in...
Hi experts, I am upgrading my database from SQL Server 2000, SP4 to SQL server 2005, SP2. 1) Is it required to recreated my user defined...
Thanks satya, I am not attaching the database or any file. I am restoring the entire database on a standby mode. Below is the code which I am using....
I got the same error. But no solution so far. Please reply to the post if anybdy has got any solution for this....
Hi Experts, I am setting up new production box. I have 2 separate boxes with SQL server 2000 Standard Edition with sp4. As SQL server standard...
Will there be any performance difference if I keep the partion table in the same database? I dont think so but still feel free to elaborate on this....
Thanks Satish, We have already impletement both the points u mentioned but still no luck. I am getting an clustered index seek where I m hitting the...
Hi Sat, Thanks for the instant reply. 1> What are the long running queries or SP's ? We are already in process of optimizing badly running sps. But...
Hi Experts, We have a table which is really huge. Approximatly 156 million record or little more than it. Fetching rows or doing any operation used...
Hi All, We are evaluating DB mirroring for our production box. But we have some queries with the operating mode available for mirroring. 1) I set...
No I am not. Moreover mirroring cannot be done in any other recovery model other than FULL recovery model.
Hi Experts, I have configured mirroring and its working fine. But in an article from microsft I came accross a line " • The principal database...
Hi Experts, Does anybdy have set of queries which can be asked on SQL interview? Any blog or link will be helpfull. Thanks in advance S
Separate names with a comma.
