Viewing 15 posts - 811 through 825 (of 991 total)
Here's some more in-depth info for you:
Why data file shrink is bad: http://www.sqlskills.com/blogs/paul/2007/11/13/AutoshrinkTurnItOFF.aspx
Running out of log space: http://www.sqlskills.com/blogs/paul/2007/09/24/SearchEngineQA1RunningOutOfTransactionLogSpace.aspx
Clearing the log: http://www.sqlskills.com/blogs/paul/2007/10/12/BACKUPLOGWITHNOLOGUseAbuseAndUndocumentedTraceFlagsToStopIt.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
January 27, 2008 at 7:39 pm
There are no changes in this area in SS2008.
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
January 26, 2008 at 4:18 pm
Just to avoid the extra workload. Every index you rebuild unnecessarily means:
- potential for data file growth
- depending on how you rebuild, reduced concurrency on the table (for offline rebuild)...
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
January 26, 2008 at 4:12 pm
Removing indexes will have no effect. As I said in the MSDN forum thread, the PFS page tracks free space (among other things) for heaps and text data - nothing...
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
January 26, 2008 at 4:09 pm
The reason you're getting that error is that you're trying to run online checkdb (the default) on a database that can't support it. I rewrote checkdb in 2005 to use...
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
January 26, 2008 at 6:01 am
Specifically, rebuild will update statistics with a full scan (so don't manually update stats too otherwise you could end up with worse stats if your default is to 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
January 26, 2008 at 5:56 am
What compatibility level are the databases you're trying to execute in? They need to be 9.0 for DMVs to work.
Also, use DB_ID ('DatabaseYouAreIn') instead of DB_ID ().
That should sort you...
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
January 26, 2008 at 5:52 am
I took care of this on the MSDN HA/DR forum where it was cross-posted. See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2736150&SiteID=1.
To comment on the two replies:
1) The Storage Engine team doesn't want to remove the...
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
January 25, 2008 at 4:44 pm
Yes, of course it does - I missed the key in there (I blame jet-lag - I'm in China this week 🙂
My bet is still a bug. There were several...
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
January 23, 2008 at 6:41 pm
The base table here is a heap (otherwise the data rows would be identified by cluster key values instead of physical RIDs). The strange thing here is that both non-clustered...
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
January 22, 2008 at 7:23 pm
I think there's some unintuitive behavior in the server here around worktables. Let me check with some people in the dev team and get back to you.
Thanks
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
January 22, 2008 at 6:39 pm
Not flying till Saturday - don't write me off yet! 🙂
Tim - this looks fine to me - the database state is ONLINE and MULTI_USER.
Can you describe in more detail...
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
January 17, 2008 at 10:07 am
Can you post:
- the exact SQL you used
- the exact error message you received when trying to detach the database
- the output from "select * from master.sys.databases where name='yourdbname';"
Thanks
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
January 17, 2008 at 7:52 am
You need way more help than you're going to get in a reasonable time over a forum like this - I recommend calling in a SQL consultant (not trying to...
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
January 15, 2008 at 5:49 pm
You're welcome. What a shame - I'd have liked to see the corrupt data (I'm strange that way :))
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
January 11, 2008 at 7:06 pm
Viewing 15 posts - 811 through 825 (of 991 total)