Forum Replies Created
Viewing 15 posts - 28,876 through 28,890 (of 49,552 total)
-
RE: Are the posted questions getting worse?
Craig Farrell (12/14/2010)
GilaMonster (12/14/2010)
Brandie Tarvin (12/14/2010)
(Where's my halo? Self-righteous doesn't work without my halo, darnit!)How long did it take you to forge your own halo, in between the lightning strikes,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Brandie Tarvin (12/14/2010)
(Where's my halo? Self-righteous doesn't work without my halo, darnit!)Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: REPAIR_ALLOW_DATA_LOSS won't fix consistency error
There's no minimum repair level specified, hence we can conclude it's not considered repairable.
Since you have no backups, you're pretty much left with the other option I mentioned - recreate...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: View is not ordered. Why?
evald (12/14/2010)
GilaMonster let me explain with a simple example because i'm not understanding you.Suppose the view is created like this(which is the same as mine except that i'm using also...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: REPAIR_ALLOW_DATA_LOSS won't fix consistency error
Only ever tried one, didn't work.
Could you post the output of that command please?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Reducing data file size prior to a database move
Your plans are about the best.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: REPAIR_ALLOW_DATA_LOSS won't fix consistency error
Please run the following and post the full and complete output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
CheckDB can't fix all errors. Any that it can't are irreparable and will require...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: View is not ordered. Why?
evald (12/14/2010)
GilaMonster (12/14/2010)
You could read the docs. It is documented.
Yes of course, but i mean if the dbms is accepting a sql statement i'm expecting that it works.
It does...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Database Backup
That's why.
You didn't copy the jobs from the old server nor restore MSDB, so you've lost all jobs, backup and other.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: View is not ordered. Why?
evald (12/14/2010)
bad design 🙁 At least sql has to inform me about this.You could read the docs. It is documented.
yes, i'm using top and also distinct clause inside 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Reducing data file size prior to a database move
I strongly suggest that you fix the corruption prior to moving the database. It could fail to restore.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Database Backup
Deepthy (12/14/2010)
Thanks for your reply.But I wonder how could have the backups run on schedule before upgradation with out a job.
How did you upgrade? Did you keep (upgrade) the old...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Stefan Krzywicki (12/14/2010)
GilaMonster (12/14/2010)
Thunderstorms here, but no snow storms. (I'd worry if there were)Want some entertainment? I give you Gus's reply here http://www.sqlservercentral.com/Forums/FindPost1034345.aspx, nominated for comment on the week.
It almost...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: View is not ordered. Why?
Because SQL does not honour any Order By unless it appears in the outer select statement (the one that queries the view) or there's a row-restricting TOP specified. This is...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Need information about Exam: 70-450
Like all SQL exams, the pass mark is 700.
See the MS site for details of the exam content: http://www.microsoft.com/learning/en/us/Exam.aspx?ID=70-450&locale=en-us and prep material.
No details can be given as to the exam...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass
Viewing 15 posts - 28,876 through 28,890 (of 49,552 total)