I have a procedure used to search the product and used to give results to the users.The issue is if I run it as SP , it is getting more time than...
Hi, Just to update on the lock issue When snapshot are created a shared lock is created on the table until the snap shot files are created on the...
I want to know the relation ship between recompilation and indexes Does any index forces for any recompilation of the procedure Thanks
Thanks satya for updating As per the top mgmt we need to take the full backup before and after the process and it slows down the access over the...
The database is financial and is around 120 gb in size .
Also one more point to keep in mind that we have the plan of taking backup two times from the stand by server ,before a process is run and after the...
I tried to set up logshipping in stand by mode and not able to backup the database from the stand by server.We are looking for for options that...
After the log back up i am able to shrink the log back to normal
The database is in full recovery mode .Also whe i tried to run dbcc shrinkfile it returnsCannot shrink log file 2 (LogFile) because all logical log...
Hi Every One, I have a sql 2005 server with a database with compatability to 80. Daily we are taking backup at 10 pm and transaction log backup at...
ONE Database was mirrored to another server and it was working for a long time .Due to some issue the data base on mirror seems correpted. Inorder...
I have end of day process on the database and it takes a long time(1.5 hours) and hope that by dividing the data between files on the same file...
I have a db with one file group having 80 gb size on a single file.I wish to create one more file on the file group to divide the operations If i...
HI, I have a sql 2005 box that needs to be mirrored .The server is configured to take transaction log backup and the file size comes to 2.5 gb to 3...
I have to create a proxy account to run xp_cmdshell procedure in 2005 .I tried to create a credintial and it gives me decryption error .Is this was...
I have a sql server 2005 entertprize on windows 2003 ent with total 16 gb memory .Pae was on on boot.ini The sql server min and max server memory...
Thanks for the advice ... Also after installing 2005 as named instance and migrating all login jobs ,dbs to 2005 Is it possible to change the 2005...
I am converting sql 2000 enterprice into sql 2005 enterprice server to a windows 2003 enterprice box ...The box has only two drivve the system drive...
HI, I have a sql 2000 enterprice machine for storing edi data and we have created a full text catalog and added two table s and scheduled for...
HI, My SQL server 2000 sp4 and windows 2003 enterprice data is stored on D drive .And the drive is coming from the SAN DS 4300 with raid 1 with 8...
Separate names with a comma.
