Viewing 15 posts - 21,106 through 21,120 (of 49,552 total)
MarkThornton (1/12/2012)
My current theory is that this isn't working, due to the presence of an ntext field in the table.
A ntext column won't prevent the index from rebuilding but, as...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 12, 2012 at 6:23 am
There are two allocation errors that you haven't posted. Please run the command I gave you (which will return only the errors) and post the results
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 12, 2012 at 6:22 am
sharmaamard (1/12/2012)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 12, 2012 at 4:18 am
SQLPhil (1/12/2012)
But having said that, it begs the question what is the point of copy_only backups now?
This: http://sqlinthewild.co.za/index.php/2011/03/08/full-backups-the-log-chain-and-the-copy_only-option/
You wouldn't be the first to argue with me about full backups breaking...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 12, 2012 at 4:16 am
That is not the entire output of checkDB. Please run the following and post the full and complete output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 12, 2012 at 4:15 am
MarkThornton (1/12/2012)
This explains my problem.... unfortunately, rebuilding the index had no effect!I wouldn't be too surprised if the coders of the "Rebuild Index" functionality just forgot about dealing with ntext.
I'll...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 12, 2012 at 4:14 am
crazy4sql (1/12/2012)
What if you create a blank file and name it as AdventureWorks2008R2_log.ldf and then try to attach the mdf and ldf file.
You'll get an error saying that the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 12, 2012 at 4:01 am
sharmaamard (1/12/2012)
You can attached database mdf file without ldf file, see example given below:-
sp_attach_single_file_db @dbname='Amber',@physname='S:\AMBERDATAFILE\Amber.mdf'
From that link:
This feature will be removed in a future version of Microsoft SQL Server....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 12, 2012 at 4:00 am
Small chance, bug in SQL, large chance IO subsystem error, same as all other corruption.
Can't give you any advice on fixing it without seeing all of the output from CheckDB.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 12, 2012 at 3:59 am
MarkThornton (1/12/2012)
Or should I wait and schedule it for the middle of the night?
Yes. The table will be inaccessible while the index rebuilds.
You should have regularly scheduled index rebuilds as...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 12, 2012 at 3:57 am
MarkThornton (1/12/2012)
I'm thinking of scheduling a monthly SHRINKFILE as it seems the least bad option... but I am very open to better suggestions!
If the size of the table is due...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 12, 2012 at 3:56 am
Define exactly what you mean by 'duplicate content' please. Also please post your table definition (as CREATE TABLE statement) and some sample data (INSERT statements) and your expected result. If...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 12, 2012 at 2:57 am
Evil Kraig F (1/11/2012)
GilaMonster (1/11/2012)
Errrrr... Someone(s) want to tackle this? http://www.sqlservercentral.com/Forums/Topic1234441-61-1.aspxAlready responded. I'm waiting to see his answer before continuing.
I just had a look over his posting history, surprised...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 12, 2012 at 2:55 am
All shrink does is release free space within the data file to the OS. If there are no free pages within the data file, it can't do anything.
Deleting rows (unless...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 12, 2012 at 2:54 am
chaudharydpk0 (1/12/2012)
Sir, actually i delete 5000 rows in my table in sql 2008 r2 but after that the table size in unchanged.
Nothing unusual there. The deleted rows are scattered throughout...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 12, 2012 at 2:44 am
Viewing 15 posts - 21,106 through 21,120 (of 49,552 total)