Migrating poorly designed database to new, normalized one
Expert: Michael Hotek | 10 Jan 2005 EXPERT ANSWER - I have a database developed about two years ago. The database is not
designed properly and the problems are a) there are no indexes, b)
data units repeat in several tables, c) there are no
refrential/integrity ...
Procedure for finding last modified info?
Expert: Michael Hotek | 10 Jan 2005 EXPERT ANSWER - I need to find when (date/time) the STRUCTURE of some tables and stored
procedures have last been changed. Querying the crdate/refdate in
sysobjects gives the creation date only. Is there a system procedure,
object that ...
Applying LDF file to MDF without turning it to .BAK first?
Expert: Michael Hotek | 10 Jan 2005 EXPERT ANSWER - HELP! Our MDF file was somehow corrupted on Dec 31st. We worked with
Microsoft support over the phone for two days trying to repair it...
with no luck.
We also found out that the SQL Server backup has not been working ...
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.
