Organization of Databases as well as Tables (Relations) Part – 5 Primary Key Constriction The Primary Key constriction is demarcated on a column / attribute or on a group of columns / attributes whose data exclusively classify each and every rows or tuples in a table or relation. These columns or attributes are denoted to be the Primary Key columns […]

Troubleshooting SQL Server 2014 installation If you have problems with SQL Server 2014 installation, review this troubleshooting checklist to find potential solutions. 1. Check the hardware requirements. To install SQL Server 2014, you should have the following hardware: – Intel or compatible platform with processor speed: 1.0 GHz minimum for a 32-bit x86 implementation and a 1.4 GHz minimum for […]

Troubleshooting SQL Server 2014 installation If you have problems with SQL Server 2014 installation, review this troubleshooting checklist to find potential solutions. 1. Check the hardware requirements. To install SQL Server 2014, you should have the following hardware: – Intel or compatible platform with processor speed: 1.0 GHz minimum for a 32-bit x86 implementation and a 1.4 GHz minimum for […]

Organization of Databases as well as Tables (Relations) Part – 4 Applying Information Reliability If constraints are not used at the time of describing as well as forming tables or relations, the information kept in the tables or relations can turn out to be repeated information. For an instance, if an individual do not stock the information regarding every Customer […]

Microsoft SQL Server Database Design Principles – (Part 2) Author: Basit A. Farooq Relationships Relationships identify associations between data stored in different tables. Entities relate to other entities in a variety of ways. Table relationships come in several forms: · One-to-one relationship · One-to-many relationship · Many-to-many relationship One-to-one relationship A one-to-one relationship represents a relation between entities in which […]

Troubleshooting problems with connection to SQL Server 2014 If you have problems with connection to SQL Server 2014, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many SQL Server 2014 connection bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the […]

Organization of Databases as well as Tables (Relations) Part – 3 Deleting An End – User – Demarcated Database An individual can remove a database as soon as it is not needed. This will result in deleting every database files as well as the information. Solely the end – users having the SYSTADMIN Role plus the database proprietor have the […]

Troubleshooting problems with joins in SQL Server 2014 If you have problems with joins in SQL Server 2014, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many join bugs were fixed in SQL Server 2014 service packs, you should install the latest SQL Server service pack. At the time this […]

Microsoft SQL Server Database Design Principles – (Part 1) Author: Basit A. Farooq Database design is one of the most important tasks in the systems development life cycle (SDLC), also referred to as application development life-cycle (ADLC). That’s because, the databases are essential for all businesses, and good design is crucial for any business critical high performance application. Poor database […]