In this article, we look at the features of the copy database wizard for moving objects from one SQL instance to another. We further look at restrictions and tips to get past them. A SQL Server instance comprises of several objects, and if...
Read more »In this article, we look at stretch enabled tables that one should be aware of including key constraints Stretch Database is a SQL Server feature which allows users to migrate cold data securely and transparently to Azure cloud. Users can even...
Read more »This article addresses the installation error ‘A Constraint Violation Occurred’ and how users can solve it. This is among the most common problems witnessed by most people while installing SQL Server in Windows. Usually, this error occurs...
Read more »In this article, we look at roles being used to grant permissions on the report server. We also look at who sets these permissions how these permissions are stored. Reporting Services in SQL Server use a role-based authorization and...
Read more »The following article lists multiple solutions for you to free up data disk space in different situations. While working on SQL Server Database Engine, users often face the problems related to insufficient disk space, especially during the...
Read more »This article explains the relevance and importance of indexing in SQL Server along with explaining the best practices and priorities to follow when creating indexes in SQL Server. Understanding of Indexes and their practices is essential if you...
Read more »The following article explains the key differences between Heap tables and Clustered tables. While working with tables in SQL Server, users often face the dilemma to use clustered tables or heap tables. Tables which don’t have clustered indexes...
Read more »The article explains in depth the use of Vertical Partitioning in improving the performance and maximizing I/O operations on a SQL server. Vertical Partitioning in SQL Server, an important feature introduced in SQL 2005 Enterprise Edition, is...
Read more »In this article we explain about ERROR 208, why it occurs and how to deal with it. We often come across situations which seem to be very complicated and challenging but are actually very easy to get out of; provided we think logically. One such...
Read more »If a database is read-only, you can easily identify the status from the sys.databases or from the SSMS. A well-known fact is that you cannot update data in a read-only database. In this article, we will learn how to troubleshoot and fix this. Two...
Read more »