Distributed queries – (Part-2) Author: Basit A. Farooq Linked server for another SQL Server To create a linked server object for another SQL Server, using SQL Server Management Studio: · In Object Explorer, expand Server Objects. · Right-click Linked Servers and choose New Linked Server. · Enter the name of the linked server. · Select SQL Server. · Click Security. […]
SQL Server
Inquiring Information By means of JOINs As Well As Sub — Queries Part — 1
Inquiring Information By means of JOINs As Well As Sub – Queries Part – 1 Introduction In a standardized database, the information to be look at can be kept in several tables or relations. As soon as an individual want to take a look at the information from associated tables or relations collectively, an individual can inquiry the information by […]
Troubleshooting Upgrading to SQL Server 2014
Troubleshooting Upgrading to SQL Server 2014 Should you have problems with upgrading to SQL Server 2014, review this troubleshooting checklist to find potential solutions. 1. Check the hardware requirements. To upgrade to 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 […]
Organization of Databases as well as Tables (Relations) Part 8
Organization of Databases as well as Tables (Relations) Part – 8 Altering A Table Or Relation An individual want to alter tables or relations as soon as there is a necessity to introduce a fresh column or attribute, modify the data type of a column or attribute, or introduce otherwise eliminate any constrictions on the present columns or attributes. For […]
Troubleshooting SQL Server 2014 Indexes (Part 3)
Troubleshooting SQL Server 2014 Indexes (Part 3) If you have problems with SQL Server 2014 indexes, review this troubleshooting checklist to find potential solutions. 1. You can get the error 666. This is the error message text: “The maximum system-generated unique value for a duplicate group was exceeded for index with partition ID %I64d.” To resolve this problem, you can […]
Organization of Databases as well as Tables (Relations) Part 7
Organization of Databases as well as Tables (Relations) Part – 7 Forming A Segregated (Partitioned) Table Or Relation The minute the size of information in a table or relation upsurges plus it consumes huge to enquiry any information, an individual can segregate (partition) the tables or relations as well as stock dissimilar portions of the tables or relations in several […]
A Framework for Applying Query Hints Without Changing TSQL Code
A Framework for Applying Query Hints Without Changing TSQL Code Introducing the problem This problem, in most of the cases, usually occurs upon dealing with supplied software packages and not in self written code. The problem scenario goes like this: you experience many query performance problems with some SQL databases that are being accessed from applications using TSQL source code […]
Troubleshooting SQL Server 2014 Indexes (Part 2)
Troubleshooting SQL Server 2014 Indexes (Part 2) If you have problems with SQL Server 2014 indexes, review this troubleshooting checklist to find potential solutions. 1. The error occurs when you try to create indexed view on a partitioned table that has a clustered columnstore index. This is the error message text: “Internal Query Processor Error: The query processor could not […]
Organization of Databases as well as Tables (Relations) Part – 6
Organization of Databases as well as Tables (Relations) Part – 6 Check Constriction A Check constriction implements area reliability by means of limiting the data to be added in a column or attribute. It is thinkable to describe several Check constrictions on a one (1) column or attribute. These several Check constrictions are assessed in the sequence in which they […]
Distributed queries — (Part-1)
Distributed queries – (Part-1) Author: Basit A. Farooq Distributed queries are queries that involve data from data sources on multiple computers or multiple instances of SQL Server. SQL Server supports distributed queries through OLE-DB, a library that allows connections to any data sources that has an OLE DB provider. In this two part article series, you’ll learn how to […]