Viewing 15 posts - 406 through 420 (of 860 total)
klnsuddu (3/31/2009)
Here at 5:00AM, there will be a differential backup and also log backup occuring.
If something happend at 7:00AM,
1.restore the full backup of 1:00AM
2.restore 5:00AM differential
3.Here before restoring 6:00AM...
March 31, 2009 at 11:34 am
Have you had a look at sys.dm_db_index_usage_stats? this might be useful, it will tell you about all reads and writes. have a look at it and let us know if...
March 31, 2009 at 11:13 am
Hello,
It depends on your business requirements and how much of data loss your business can afford. If your business can afford 1 hr loss of data then your plan...
March 31, 2009 at 11:04 am
Yes, it definitely does improve the performance but remember it is an expensive operation. You have to opt doing out of business hours. After that you can see more disk...
March 31, 2009 at 10:09 am
rajiniforu (3/31/2009)
Small correction in the query:if (SELECT DATEDIFF(day, crdate, getdate()) FROM master..sysdatabases where name = 'dbname') > 10
BEGIN
drop database 'dbname'
END
Else
PRINT 'Database not older than 10 days'
That was a good...
March 31, 2009 at 8:13 am
143.manvendra (3/31/2009)
I am bignner for SQL 2005 so i want to details for topic
BOL is your "best mate"
,that what is the advantage And why we use for this ?
Thanks
The...
March 31, 2009 at 8:08 am
iqtedar (3/30/2009)
should i first execute sys.dm_db_index_physical_stats view and the look at the fragmentation level...and if the avg percentage is mroe than 30 %
Yes, but it really depends on...
March 30, 2009 at 2:21 pm
Hi,
Sorry I din't realize this before. Your table is very small 25 pages only and the fragmentation on these tables does not count much only with pages >1000 i...
March 30, 2009 at 1:25 pm
Hi,
Can you run sys.dm_db_index_physical_stats please? and look for avg_fragmentation_in_percent which gives you the fragmentation levels in your table.
It really depends on your system when you should defrag and when you...
March 30, 2009 at 12:44 pm
and also fragmentation on these tables and accordingly defrag them or rebuild them
March 29, 2009 at 5:17 pm
Check out Kimberley's blog for a better management of Transaction log :
http://www.sqlskills.com/BLOGS/KIMBERLY/post/8-Steps-to-better-Transaction-Log-throughput.aspx
March 29, 2009 at 3:12 pm
No it won't. If you have enough memory that will sort out the problem. The only time transaction log will hit the performance is when there is Fragmentation and also...
March 29, 2009 at 1:42 pm
Matt (3/29/2009)
HiA website that I run has a forum on it and the table that holds the posts has 10 indexes on it including the clustered index.
Matt
As ALZDBA and others...
March 29, 2009 at 11:54 am
Viewing 15 posts - 406 through 420 (of 860 total)