Viewing 15 posts - 12,871 through 12,885 (of 49,552 total)
Please run the following and post the full and complete, unedited output here.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Save the output to a text file, zip the file and attach...
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
June 7, 2013 at 3:07 am
Shadab Shah (6/6/2013)
My question is my do we need Partition function?
To tell what rows go in what partition of a partitioned table
What would have happen if microsoft would have not...
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
June 6, 2013 at 11:47 am
With the query form that you've got, you cannot both support the predicate and the group by with a single index (as explained in the blog post I referenced earlier),...
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
June 6, 2013 at 9:17 am
Lots more detail required.
What exactly do you mean by a 'file group restore'? What was restored, from what backups? What's the file/filegroup layout of the source database?
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
June 6, 2013 at 5:20 am
asco5 (6/6/2013)
i think yes someone run a sql request with drop table things like that but im not surebut everything is empty now
and i have no backup
Then I guess you'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
June 6, 2013 at 5:19 am
What do you mean, the database is empty? Someone ran a script dropping all tables?
Production server or local test DB?
Without a backup, there's no way to restore a database to...
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
June 6, 2013 at 4:34 am
Take a backup first. Just in case.
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
June 6, 2013 at 2:10 am
I would suggest you consider decrypting that column. There's no security if the value is encrypted in one place and decrypted in another and having that partial encryption is going...
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
June 5, 2013 at 11:53 pm
gmamata7 (6/5/2013)
So how we know statistics were updated with full scan or with sampling?
Definition of full scan - read the entire thing. Definition of sampling, read parts. Hence 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
June 5, 2013 at 11:38 pm
DBCC SHOW_STATISTICS and check the values for rows and rows sampled.
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
June 5, 2013 at 2:31 pm
Kirk.wilson (6/5/2013)
Understood but in my case the repair did not fix the problem.
In that case, yes, script and recreate (or restore backup), but in the OP's case CheckDB did fix...
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
June 5, 2013 at 2:27 pm
You don't need to manually rebuild indexes or to script out and recreate the database. The latter is only indicated in cases where CheckDB can't repair the damage.
This is one...
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
June 5, 2013 at 1:47 pm
Data been added to existing tables that are in the primary filegroup?
People specifying ON [PRIMARY] when creating tables and indexes?
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
June 5, 2013 at 9:19 am
Maybe ahave a read through this, seen it causing all sorts of problems before.
http://support.microsoft.com/kb/942861
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
June 5, 2013 at 6:24 am
Please note: 4 year old answered thread.
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
June 5, 2013 at 5:58 am
Viewing 15 posts - 12,871 through 12,885 (of 49,552 total)