Viewing 15 posts - 27,436 through 27,450 (of 49,552 total)
Neither is going to work directly. To restore a diff, the database has to have been restore with norecovery and the diff has to be based on the full that...
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
March 10, 2011 at 8:19 am
Yes, you need to repair. You've already lost those registers, the pages they are on are unreadable. Querying them will throw errors.
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
March 10, 2011 at 8:14 am
Could be computed columns, not sure. Could you explain more what the MySQL feature 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 recoverability
March 10, 2011 at 8:09 am
Steve Jones - SSC Editor (3/4/2011)
Synchronous mirroring is the only way I see to guarantee no data loss at all, and that requires Enterprise Edition, which not everyone has.
Standard edition....
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
March 10, 2011 at 6:30 am
I'm not talking about a post when an existing thread, we've all done that either to answer an issue, to ask comments or just (like this thread) because people might...
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
March 10, 2011 at 6:26 am
Table definition, sample data and desired result please.
Using the time data type as Chaz showed requires matches to the nanosecond.
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
March 10, 2011 at 5:59 am
There must be at least one shared drive that is a cluster resource. SQL can only use such drives in a cluster.
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
March 10, 2011 at 5:51 am
Report it. Advertising should be paid for. They do get removed (not the first those people have posted)
The forums are for questions and discussions, not promotions of software/services/blogs. I know...
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
March 10, 2011 at 5:47 am
Please note: 3 year old 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
March 10, 2011 at 4:39 am
Have a look in Books Online for logon triggers.
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
March 10, 2011 at 4:15 am
Please note: 4 year old 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
March 10, 2011 at 4:14 am
Get a backup from before the truncate ran. Restore it as a new database. Copy the data over into the table that was truncated.
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
March 10, 2011 at 3:17 am
SQL doesn't keep track of when logins are used. You'll have to set some form of logging up, login triggers or server-side trace should work.
Once you have the data from...
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
March 10, 2011 at 2:36 am
Why?
There probably are, but they'll be hectically complex, hard to read, likely bad performing and hard to maintain. David wrote it that way for a reason. It's a reasonably common...
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
March 10, 2011 at 2:33 am
You need to rebuild indexes based on fragmentation. You need to run checkDB on a regular basis. Maybe not daily, but at least weekly.
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
March 10, 2011 at 2:23 am
Viewing 15 posts - 27,436 through 27,450 (of 49,552 total)