Viewing 15 posts - 151 through 165 (of 860 total)
Oops edited as it was bad suggestion dint realize there was a second page to this 😀
April 28, 2009 at 12:23 pm
Matt (4/27/2009)
weekly basis, but it looks like I'll have to try and diagnose the problem
Could be bad indexing check that out, fragmentation levels, update statistics.....Just defragging the indexes might give...
April 27, 2009 at 5:43 pm
Matt (4/27/2009)
Today My website started running very slowly and in many cases timed out before the sql statement could complete, I restarted the SQL server instance and found that everything...
April 27, 2009 at 1:13 pm
ichbinraj (4/27/2009)
Is it possible to restore from recent backup ?look like its going to take nearly 22 Hrs to complete.
experts : can we do this thing ?
Thanks
Ichbinraj
Yes,...
April 27, 2009 at 12:47 pm
Tara (4/27/2009)
yes there was some processing running and the reboot was done according to our shedule.anyways if nothing much i can do i will wait to recover.
Was it a clean...
April 27, 2009 at 12:22 pm
Alvin Ramard (4/26/2009)
ally (4/26/2009)
As above, zipping sounds like your best plan. Bak files will compress a fair bit.
If you go this route be sure to test your backup after...
April 26, 2009 at 5:08 pm
DBCC FREEPROCCACHE- you can clear the procedure cache
April 23, 2009 at 1:41 pm
Tara, Rebuilding indexes will compact the databases and reduces fragmentation, probably that might be the reason you see difference in the DB size. In your original Database what is the...
April 22, 2009 at 9:09 pm
anand00025 (4/22/2009)
actually i am starting sqlserver and it showing error: 1068what could be the reason.
and how to handle that problem
Could be better if you post the complete error message and...
April 22, 2009 at 9:03 pm
kenneth.holm (4/22/2009)
the developers doesent wanna listen to me
😀 I suppose that why We the DBA's are there to straighten them up.
Take it as a challenge, improve the...
April 22, 2009 at 8:51 pm
Roust_m (4/22/2009)
I have a couple of indexed views which slow down occasional data loading into the tables. They used to drop the views and re-create them after the data...
April 22, 2009 at 8:31 pm
madhu.arda (4/22/2009)
I asked the Network team to exclude data and log (mdf n ldf files) files from Antivirus scan. But they are telling the Anti virus is running From a...
April 22, 2009 at 8:12 pm
sharanurampur (4/21/2009)
when I checked into the log files i got some message like..
No errors there. Are there any messages in the log that relate to the database Common?[/quote]
If you cant...
April 22, 2009 at 11:57 am
David O (4/21/2009)
I appreciate the direction you are taking this but this server configuration is rock solid. The server is not experiencing any obvious signs of a memory...
April 22, 2009 at 11:44 am
vrabhadram (4/21/2009)
i've prepared a database for log shipping. But it is showing standby/read-only mode for that database.
I just want remove that mode. I have executed alter command.
ALTER DATABASE FTDTVer5...
April 21, 2009 at 4:52 pm
Viewing 15 posts - 151 through 165 (of 860 total)