1-10 of 203 hubssort by Hot Best Latest
60Metadata structure damage results in “System table mismatch...”
Almost all good DBMS (Database Management System) are built with some sort of metadata structure (data dictionary) and MS SQL is no exception. You can view the metadata either through the INFORMATION_SCHEMA...
0 comments
70Resolving “Text node referenced by more than one node” Error Message
Data, such as, tables, views, etc in SQL Server database is stored in blocks of 8Kb known as Pages. The two ways in which these Pages can be organized are clustered and non-clustered tables. While...
2 comments
65Tips to resolve “Table error: IAM chain linkage error...” Error message
IAM (Index Allocation Map) pages in SQL Server database tracks nearly 4GB file space to store critical “Extent” information belonging to a particular entity. These IAM pages are have to be linked together...
1 comment62How To Resolve “...high key value on page...” Error Message
The technique used in locating and placing data in SQL Server Database is known as B-tree. A B-tree contains a tree-level page that maintains and stores a key value for each child page. In case, the child...
1 comment
63recover data
Each and every computer user values his or her precious computer data and yearns for its safety. Be it a businessman, a student, a corporate person, an office employee or any other user, data holds prime...
0 comments64Data Recovery Software Tool
Any person using the binary basket (the computer system) for any sort of work definitely deals with the issue of data loss at some or the other point. This can happen due to some reasons that even the user...
0 comments
63SQL 2005 Find Time of Day (morning, night, twilight) based on lat/long
What a glorious sunrise. Psalm 84:11 For the Lord our God is our sun and shield. He gives us grace and glory. The Lord will withhold no good thing from those who do what is right. Morning, Night or...
0 comments
69SQL 2005 calculate sunrise/sunset based on latitude/longitude
Fly me to the moon, pick up stationary for letter to Santa and calculate the sunrise and sunset for a given latitude/longitude in SQL 2005. uh huh, so here we go. Calculate Sunrise and Sunset in SQL, this...
0 comments
64SQL 2005 error trapping
SQL can be tricky to track down errors, here's a quick routine to help. BEGIN TRY --SQL statements here END TRY BEGIN CATCH -- Execute error retrieval routine. EXECUTE usp_GetErrorInfo; END CATCH; SET...
0 comments
65Tips to Resolve “Table error: Object ID.......was not seen in the scan” Error Message
A heap or clustered index in SQL Server is a way to effectively organize records saved in tables. These metadata structures enable the database user to increase retrieval speed of database records. While the...
3 comments
