Viewing 15 posts - 36,361 through 36,375 (of 49,552 total)
Carla Wilson-484785 (10/9/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
October 9, 2009 at 9:53 am
Steve Jones - Editor (10/9/2009)
That's not a bad idea, Richard. I'll see if there's a setting.
Agreed. good idea. Maybe PMs after 10-20 posts, emails after 40-50 (or more). I find...
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
October 9, 2009 at 9:52 am
FileID, Page Number, Display mode
If you want to know about DBCC PAGE and DBCC IND, go read Paul's blog. He's written pages on 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
October 9, 2009 at 9:39 am
Silverfox (10/9/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
October 9, 2009 at 9:30 am
Krasavita (10/9/2009)
Thank you very much, why did I need to check for it if my db got corrupted?
It was the table that was referred to in the error. Guess Paul...
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
October 9, 2009 at 9:28 am
guptaajay1985 (10/9/2009)
When I restore a full back up then I also got a log file at restore...
Yup, it's a full database backup. It restores the full database to the state...
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
October 9, 2009 at 9:12 am
Silverfox (10/9/2009)
Why would you automatically run REPAIR_ALLOW_DATA_LOSS, check what dbcc checkdb returns first. using any of the repair options is last resort until you see what the problem is.
If 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
October 9, 2009 at 9:12 am
2TB is the max permissible size for the tran log, so saying that the file is limited to 2TB is the same as saying unrestricted growth.
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
October 9, 2009 at 9:10 am
sudarram (10/9/2009)
One of my Critical Database went to Suspect mode due to unavailablility of a SAN Drive.The Drive is up now but not the database.Should i need...
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
October 9, 2009 at 9:08 am
Well, there are no incremental backups in SQL Server. Do you mean differential or are you referring to log backups?
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
October 9, 2009 at 9:07 am
hypermommy (10/9/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
October 9, 2009 at 9:03 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
October 9, 2009 at 9:00 am
Absolutely without question yes. As a consultant it's even more important than for a full time employee. When you're consulting, up to date, deep knowledge = work. If there's stuff...
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
October 9, 2009 at 9:00 am
That's saying when CheckDB last ran successfully. It's not saying that checkDB has just run, it's not saying that checkDB ran since the last time SQL was started. The date...
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
October 9, 2009 at 8:54 am
Krasavita (10/9/2009)
I am sorry to ask a a stuped question,but I want to know is id good that is contains 31 rows in a page?
It's not good or bad. 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
October 9, 2009 at 8:47 am
Viewing 15 posts - 36,361 through 36,375 (of 49,552 total)