-
Recent Posts
Contents
- Database Concepts
- Downloads
- Interview Questions for SQL DBA
- Sample Interview Questions and Answers
- SQL Concepts
- SQL Server 2012
- SQL Server Analysis Services
- SQL Server Interview Questions and Answers
- SSAS Interview questions
- SSIS Interview Questions and Answers
- SSIS Issues and Resolution
- SSIS Study Guide
- SSRS Interview Questions
- Uncategorized
- What is SQL Server
- What is SQL Server Analysis Service
Archives
Author Archives: randheerparmar
Materialized view or Indexed view
A materialized view or indexed view is a db object that stores the results of a query physically. it may be a local copy of data located remotely, or may be a subset of the rows and/or columns of a … Continue reading
Posted in Database Concepts
Leave a comment
Database Views
A view consists of a query accessible as a virtual table in a relational database. Unlike normal tables (base tables) in a relational database, a view is not form part of the physical schema. Changing the data in a table … Continue reading
Posted in Database Concepts
Leave a comment
Database Lock
A lock is used when multiple users need to access a database concurrently. This prevents data from being corrupted or invalidated when multiple users try to update to the database. Any user can only modify those database records (that is, … Continue reading
Posted in Database Concepts
Leave a comment
Normalization Denormalization
Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency. Normalization usually involves dividing large tables into smaller tables and relationships between them. The main goal is to isolate data … Continue reading
Posted in Database Concepts
Leave a comment
Data Modeling
Data modeling is a process used to define data requirements needed to support the business within the scope of corresponding information systems inside the organizations. There are three different types of data models produced while progressing from requirements to the … Continue reading
Posted in Database Concepts
Leave a comment
Primary Foreign and Unique Keys
In a relational database , a “Primary Key” is a key that uniquely defines the characteristics of each row .The primary key has to consist of characteristics that cannot be duplicated by any other row. The primary key may consist of a single … Continue reading
Posted in Database Concepts
Leave a comment
Deployment issue’s in SSAS cube
After configuring and installing SQL Server when we try deploy our first sample cube it throws error regarding the access to data source. The error message says that the connection to data source is not valid or data source is not … Continue reading
Posted in SQL Server Analysis Services
Leave a comment
Difference between Varchar and Nvarchar
As we all know the basic difference between varchar and Nvarchar is that one holds non Unicode and other holds Unicode data. But we are just aware theoretically and don’t know how it works actually. Here I am showing an … Continue reading
Posted in Uncategorized
Leave a comment
Control Flow Task in SSIS
Control flow task is the starting point of package design. It’s the first step or window which developer opens while designing the package. Package control flow task contains the package workflow where entire flow of multiple tasks designed. The … Continue reading
Posted in Uncategorized
Leave a comment
Deploying SSIS Package
For Deploying SSIS package Deployment utilities need to be created. For creating deployment utilities 1. Go to solution explorer. 2. Right click on SSIS project. 3. Open properties window. 4. Set create deployment utility to true. 5. Right click on … Continue reading
Posted in SSIS Study Guide
Leave a comment