Viewing 15 posts - 886 through 900 (of 991 total)
I always advise people to restore all their backups - if you're taking a backup its because you think you may need to use it in the future. If that's...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 22, 2007 at 9:34 am
My guess is that there was a huge amount of free space in the pages comprising your indexes and that rebuilding them with a larger fillfactor got back a bunch...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 19, 2007 at 11:46 am
Sounds like you have a database but it's been detached - is that the case? If so, how did it get detached?
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 19, 2007 at 11:41 am
Can you post the before and after (removing fragmentation) results from the DMV for each index?
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 19, 2007 at 11:38 am
Also, if you're having continuous problems with fragmentation, you might want to see if you can change your index keys so that the indexes aren't so prone to fragmentation. E.g....
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 19, 2007 at 11:28 am
Yup - if you take an exact copy of the database and then make a change in one that isn't reflected exactly in the other, as far as SQL Server...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 19, 2007 at 11:25 am
It can't be done unless the databases are identical copies of each other - otherwise the LSNs in the databases get out of sync. It's an often-requested feature of SQL...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 18, 2007 at 6:16 pm
Yup - forgot about that. There's also a presentation available that I presented at TechEds in China and Hong Kong last year that's based on that whitepaper - see http://www.mshk.com/hk/technet/teched2006/ppt/Day_1/Session_1/DAT319_Paul_Randal.ppt
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 18, 2007 at 5:32 pm
This is a big problem for many VLDBs that are mirrored. There are a couple of things you can do in 2005:
1) use a potentially less expensive (in terms...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 17, 2007 at 9:01 am
Please - don't shrink tempdb - it's likely to just grow again and you'll end up with file system fragmentation.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 17, 2007 at 8:00 am
One thing to do before restoring master - figure out why the errors happened in the first place. If you took a power failure and you have caching turned on...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 16, 2007 at 7:18 pm
It'll be in one of the future CTPs of SS2008. See http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_oltp.mspx for more info.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 16, 2007 at 2:33 pm
Be careful - make sure you understand the ramifications of switching to bulk-logged recovery mode. For the duration of the bulk-logged operation in the log backup, you cannot do a...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 15, 2007 at 4:30 pm
Being dealt with here - http://www.sqlservercentral.com/Forums/Topic408782-357-3.aspx
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 14, 2007 at 8:41 pm
Please don't cross-post on multiple threads - thanks.
How large is your database, and how large is the largest table you're reindexing?
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 14, 2007 at 8:41 pm
Viewing 15 posts - 886 through 900 (of 991 total)