Posts Tagged ‘relational databases’
May 18th, 2009 | 
Author: PHP- Database Tier Resources
There are many excellent general database texts available that cover the broad fields of relational databases, E-R modeling, and SQL. Amongst the best are:
An Introduction to Database Systems, C.J. Date (Addison Wesley).
Database System Concepts, A. Silberschatz, H.F. Korth, and S. Sudarshan (McGraw-Hill).
Fundamentals of Database Systems, R. Elmasri and S.B. Navathe (Addison Wesley).
Database Management Systems, R. Ramakrishnan and J. Gehrke (McGraw-Hill).
For a coverage of SQL, there are several good books, but many are out-of-print. Currently available books include:
A Guide to the SQL Standard: A User’s Guide to the Standard Database Language SQL, C.J. Date and H. Darwen (Addison Wesley). This book isn’t for the beginner but does an excellent job of covering the standard in detail.
SQL-99 Complete, Really, P. Gulutzan and T. Pelzer (CMP Books). MySQL supports the SQL-92 standard, but this book is an excellent and long introduction to SQL with many worked examples.
There are many books that cover the tuning of a specific DBMS. Here’s one text that is general in its introductory coverage and devotes a chapter to each DBMS product:
Database Performance Tuning Handbook, J. Dunham (McGraw-Hill).
For MySQL, the manual.html file distributed with the installation is an excellent resource. Books include:
MySQL and mSQL (Nutshell Series), R.J. Yarger, G. Reese, and T. King (O’Reilly).
MySQL, P. DuBois (New Riders Publishing).
More PHP Tutorial
Article Source: PHP- Database Tier Resources
With the SQL Server 2000, users found many administrative tools which offered the better relational databases development and maintenance. The tools like Query analyzer, Data Transformation Services, SQL Profiler, Service Manager and others eases the users’ tasks in an effective way. SQL Server 2000 was the first file version to launch in a variant for the IA-64 architecture. Hence this gave better data storage temptations to the users and still in-use amongst many enterprises, though other file versions are making their individual place.
But, due to one or the other reason the SQL Server 2000 databases are found to be suspect after opening. Additionally, you get an error messages which prompts you to take SQL repair mechanism and reads out as:
spid9 Recovery of database ‘UserDatabaseName’ (5) is 2% complete (approximately 185 more seconds) (Phase 3 of 3).
spid9 Using ‘dbghelp.dll’ version ‘4.0.5′ *Dump thread – spid = 9, PSS = 0×80178098, EC = 0×801783c0
spid9 The exception information has been submitted to Watson error reporting.
spid9 Stack Signature for the dump is 0×986D5509
spid9 SQL Server Assertion: File: , line=3430 Failed Assertion = ‘m_freeCnt + emptySlots * sizeof (Slot) >= spaceNeed’.
spid9 Location: page.cpp:3430 Expression: m_freeCnt + emptySlots * sizeof (Slot) >= spaceNeed
The mentioned error message is the fault of SQL Server itself. During the time when the row insertion is intended, if the application does mistakes while asserting free data page space, crisis can be seen with the database. Actually, the row to be inserted should have more space as compared to the available.
Though Microsoft offers a supported hotfix through its latest service pack, but there is no SQL recovery way through it. This is available for the avoiding later such problems. Actually, the culprit transaction logs have caused the corruption causing changes in the database, much earlier. So your corrupted database has no recovery way, other than backup or third party applications.
MDF recovery is best possible via the complete backup. On the other hand, in its absence or existence in bad condition, MDF repair software will do a great job. Through their effective scanning algorithms, SQL recovery software will bring you success in restoring the corrupted database intact. SQL repair software have the set of worth features to offer the help.
Stellar Phoenix SQL Database Recovery uses the most powerful scanning algorithms and makes MDF recovery possible within moments. This is a fast, safe and easy-to-use MDF repair application, which proves good to be used with SQL Server 2000 and 2005.
This SQL recovery tool has an interactive interface and read-only design. The software valuable for all the database objects.
Simpson is a freelancer for Stellar which offers file recovery software and file recovery programs for different OS and file system including data recovery mac, data recovery linux, SQL recovery, pst recovery and many other programs.
Article Source: SQL Server 2000 Database Suspect