Viewing 15 posts - 41,971 through 41,985 (of 49,552 total)
I had a similar piece of code (for SQL) at my former company. I didn't take the code when I left, of course. I should probably rewrite and retest it...
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 5, 2009 at 12:24 pm
Jonathan Kehayias (1/5/2009)
They were an online blogging/community site for six years, and had no backups of their SQL Database
Now that's just stupid. As is their comment that mirroring (as in...
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 5, 2009 at 12:03 pm
SQLBOT (1/5/2009)
You don't need a third party tool.
use DBNAMESELECT * FROM ::fn_dblog(null, null)
GO
That only reads the active portion of the transaction log. It doesn't read a transaction log backup.
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 5, 2009 at 11:13 am
Eeep. That does not look good.
There's no way that I know of to get a negative page number, as the page number is an incremental count of 8k chunks...
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 5, 2009 at 11:01 am
Ells (1/5/2009)
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 5, 2009 at 10:59 am
Michael Earl (1/5/2009)
I used to link to google now and then, but that link makes the point much better so I am going to have to use it.
Likewise. 😎 :hehe:
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 5, 2009 at 10:51 am
GermanDBA (1/5/2009)
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 5, 2009 at 10:41 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic629723-106-1.aspx
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 5, 2009 at 10:36 am
RBarryYoung (1/5/2009)
Actually, I heard from someone at PASS that WITH RECOMPILE does not work reliably for this problem in SQL2005, but "is fixed" in SQL 2008.
Wasn't that for the 'catch-all'...
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 5, 2009 at 10:22 am
RBarryYoung (1/5/2009)
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 5, 2009 at 10:01 am
Grant Fritchey (1/5/2009)
Since you're working in SQL Server 2005, you could simple add the index as an INCLUDE column.
From what I can tell from the exec plan, they're already include...
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 5, 2009 at 9:55 am
Meteor hits the server room.
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 5, 2009 at 9:53 am
shahnawaz (1/5/2009)
infact i dont have a backup of the database.i was having only one copy of the database that is giving me this error.
Why no backup?
is there any way i...
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 5, 2009 at 1:32 am
Your only option to fix this is to restore a clean backup that was taken before the corruption. If the DB is in full recovery and there are tran log...
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 5, 2009 at 12:42 am
How are the two tables related?
What makes dd relate to ed and fr to gd?
If it's the order of the rows, then what column defines that order?
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 5, 2009 at 12:31 am
Viewing 15 posts - 41,971 through 41,985 (of 49,552 total)