Troubleshooting problems with linked servers in SQL Server 2014 If you have problems with linked servers in SQL Server 2014, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because some SQL Server 2014 linked servers bugs were fixed in SQL Server service packs, you should install the latest SQL Server service […]
Tag: server
Application of Triggers and Understanding the Transaction Procedures in Database Part – 1
Application of Triggers and Understanding the Transaction Procedures in Database Part – 1 Introduction In the cutting – edge technology of Relational Database Management System (RDBMS), the information in a table / relation is connected to some additional tables / relations too. For that reason, every time an individual alters the information in one table / relation or another, the...
Attribute Discretization Part I: Introduction and Overview
Attribute Discretization Part I: Introduction and Overview This is the charter article of the SSWUG Elemental SQL Server Analysis Services Multidimensional 2012 series. – In this and subsequent parts of the article, we will introduce attribute discretization in SQL Server Analysis Services (“SSAS”) – Multidimensional, focusing upon the purpose and benefits of this capability, which, as we shall see, affords...
Monitoring Blocked Processes with Event Notifications
Monitoring Blocked Processes with Event Notifications Author: Basit A. Farooq Introduction SQL Server is able to service requests from a large number of concurrent users. When SQL Server is servicing requests from many clients, there is a strong possibility that conflicts will occur because different processes request access to the same resources at the same time. A conflict in which...