Viewing 15 posts - 32,911 through 32,925 (of 49,552 total)
Didn't you know, RAID means that you don't need backup. *cough*
The upgrade error message worries me....
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
May 13, 2010 at 3:22 am
That's not how they'd appear in the log (msg number would be folowed by the message itself), but I suppose good enough.
Now, about that upgrade message. Please don't tell me...
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
May 13, 2010 at 3:20 am
Alert: 3 year old thread.
Even as a single user, you cannot guarantee that SQL will return data in a particular order without an ORDER BY. If, however there is an...
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
May 13, 2010 at 3:11 am
BrainDonor (5/13/2010)
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
May 13, 2010 at 3:01 am
Upgrade? Please don't tell me that you're trying to attach this to a different version of SQL to what it was originally attached.
Messages and error numbers appear mangled. Please post...
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
May 13, 2010 at 3:00 am
The clustered index (primary key) is on the ping_time, device_id column. The only where clause predicate you have is on the ping_time column. Hence it makes sense to use 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
May 13, 2010 at 2:56 am
Consultants don't want to work for free? How unfair of them. They should remember there are people stuck in jobs they can't do, and drop everything to give these people...
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
May 13, 2010 at 2:48 am
Looks like the diff doesn't belong to that full backup. Maybe there was a full backup somewhere in between.
Which of the backups are you trying to restore, in which order?
p.s....
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
May 13, 2010 at 2:35 am
Open the SQL error log, find all errors relating to this DB (from the time of the attach) and post them.
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
May 13, 2010 at 2:32 am
What's the state of the database? Query sys.databases (a view) and check the value of the status_desc column.
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
May 13, 2010 at 2:28 am
Preferably same name.
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
May 13, 2010 at 2:24 am
Sunil Padarath (5/12/2010)
this was in production environment and we do not have a backup.
Why the hell not? How can you, as the DBA, possibly justify having no backups of a...
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
May 13, 2010 at 2:12 am
Restore from backup.
Your transaction log is damaged and the database was not cleanly shut down. SQL's hitting the corruption while trying to do it's restart-recovery (which is essential to get...
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
May 12, 2010 at 3:40 pm
lcaruso (5/12/2010)
...and I was about to ask if the exec plan estimator was dumber than a DBA...
Depends on the DBA...
I'm calling from an external program in a loop for every...
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
May 12, 2010 at 3:00 pm
dma-669038 (5/12/2010)
... but these tables are small (under 20000 records) and i would not expect the optimiser to use an index on them....
I would. 20000 is not small and it's...
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
May 12, 2010 at 2:55 pm
Viewing 15 posts - 32,911 through 32,925 (of 49,552 total)