A community portal about SQL with blogs, videos, and photos. According to Wikipedia.org: SQL is the most popular computer language used to create, modify, retrieve and manipulate data from relational database management systems. The...
[more]
A community portal about SQL with blogs, videos, and photos. According to Wikipedia.org: SQL is the most popular computer language used to create, modify, retrieve and manipulate data from relational database management systems. The language has evolved beyond its original purpose to support object-relational database management systems. It is an ANSI / ISO standard.
Sometimes, the reason for SQL database corruption are unknown. This is the time when the database administrators use all their expertise and experience in an attempt to repair the database. While in most cases the administrators are successful in resolving the issues, there are certain situations where they fail to do so. In such cases, these administrators resolve their problem by restoring the entire database from an updated backup (created on some other storage media). However, the problem... Read Full Story
The metadata structure of MS SQL database stores the records of database tables in either heap or b-tree format. The B-tree structure enables MS SQL to search, insert, or delete the sequential records. The structure is build up of one root node, at least two branch nodes, and leaf nodes. The index node contains key values related to branch nodes, which further contain key values of leaf nodes. Corruption/damage in the B-tree structure primarily results in an error message that makes the... Read Full Story
Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.
This databases discussion was started by surjyakp on 10 February 2010
I have one table having column dbg_lvl and dbg_msg.
Let say i executed some update sql statement in stored perocedure which has some eror. e.g. it threw the error like
SQL0150N The target fullselect... Read Full Story
Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.
This databases discussion was started by RazorMX on 10 February 2010
I have a SQL 2005 cluster which is working ACTIVE/PASIVE named CLUSTER-A, since the hardware is sitting there i would like to make new instance named CLUSTER-B and make it ACTIVE/ACTIVE
IT group gave... Read Full Story
Expert SQL Server 2008 Development (Expert's Voice in SQL Server) by Alastair Aitchison, Adam Machanic Publication Date: January 6, 2010 Buy new: $40.45 24 used & new from $24.99 (Ranking is updated hourly. Visit the Hot New Releases in Database Management Systems list for authoritative information on this product's current rank.) Review & Description Expert SQL Server 2008 Development is aimed at SQL Server developers ready to move beyond Books Online. Author and experienced developer... Read Full Story
Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.
This databases discussion was started by dorkygrin on 09 February 2010
In the past, I’ve made DTS packages for MSDE (SQL2000). Looking for some guidance on the following project:
Need to develop a weekly process to update a specific column in a specific table in a SQL... Read Full Story
Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.
This databases discussion was started by cveselka on 09 February 2010
We have setup Merge replication to allow to different DB’s that are being updated seperately by 2 different companies. The Merge process is working fine. We had a problem last week were the SnapShot was... Read Full Story
In November of last year we published an article about the Microsoft Web Platform Installer , demonstrating how easy it is to set up a web server on Windows with PHP, IIS, and SQL Server Express. In todays tutorial , web application development specialist Akash Mehta combines these tools to show us how to build a simple web app.
After reminding us of the various open source applications that can be installed with the WPI, Akash then takes us through the process of setting up the... Read Full Story
A Guide to Implementing Oracle Siebel CRM 8.x by Mr. Vivek Kale Publication Date: January 13, 2010 Buy new: $69.50 (Ranking is updated hourly. Visit the Hot New Releases in Database Management Systems list for authoritative information on this product's current rank.) Review & Description "In the current business environment, it is imperative that CRM (Customer Relation Management) systems need to evolve from storehouses of customer information into effective tools for building customer... Read Full Story
MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification) by Solid Quality Learning Platform: No Operating System (51) Buy new: $37.79 66 used & new from $12.85 (Ranking is updated hourly. Visit the Bestsellers in Database Management Systems list for authoritative information on this product's current rank.) Review & Description Announcing an all-new MCTS Training Kit designed to help maximize your performance on Exam 70-431, a... Read Full Story