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...
I want to know the relation ship between recompilation and indexes Does any index forces for any recompilation of the procedure Thanks
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 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...
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...
I have a sql server 2005 mirrored.I wish to applt the lateest service pack to both servers .Does there any order in applying the service pack ie on...
I am optimizing the index and space utilization I have run sp_space used on a table and the output is attached Name Rows...
Ihave a 50 gb database and it takes an hour to bak it up at night .But I tried by creating two back up devices and it takes only half the time .Does...
Our one production db is 48 gb and it takes more than an hour to take back up .We are thinking to reduce the back up time .The data files are on san...
We have a critical sql server 2000 server and we wish to change it sql 2005 machine .How can we ensure that the application works flowlessly on sql...
On my sql server 2005 system .when we click the disk subsystem ,it is giving the message as connecting to disk manager service message is shown. It...
I have the below info about the system .ie the server is 32 bit with 16 gb ram and virtual memory 2 gb.But the total virtual memory is showing as 17...
I have a server that has sql 2000 sp4 running under local system account.I tried to create a linked server to sql 2005 with windows account and it...
We have a mirrored database with 55 gb in size .We wish to know how much time it will take to make snap shot of the DB .If we are making snap shot at...
Separate names with a comma.
