Sql Server Videos (26) - Page 2

SQL Server interview question :- Find the second highest salary ? 

Many times during SQL server interviews , many of them ask this tricky question "Find the second highest or 3rd highest from a given table" or probably they can also vice versa saying "Find the second or third lowest from a given table". In this video we will try to answer the same.

SSIS Tutorial 2 - Load data from excel file into sql server table 

Hi friends, this video will demonstrate how to create a new SSIS package using SSIS import and export wizard. In this ssis tutorial, example to load data from excel into sql server table is very well explained. Hope this ssis tutorial will help you learning ssis.

SSIS tutorial 1 - Introduction to SSIS 

Hi friends, This ssis video tutorial will give you brief introduction to ssis and will guide you about how to start ssis.

CTE in SQL SERVER 

CTE - Common table expression. This video have complete information about CTE like what is CTE , properties of CTE and examples for CTE in sql server.

SQL Server training :- How to implement Pivot? 

In this video we will try to implement Simple Pivot function in SQL Server. So we will take a simple customer and product data and pivot them on the basis of customer name and product name.

SQL SERVER interview question - What are the different System databases in sql server ?? 

In this video we will see what are all the system databases in sql server. There are 6 system databases in sql server 1 master 2 model 3 msdb 4 tempdb 5 mssqlsystemresource (Resource) 6 distribution To know more about system databases in sql server, visit the below link:

SQL Server Error Message Resolution -- Could not obtain exclusive lock on database 'model'. 

Resolution for sql server error message: Could not obtain exclusive lock on database 'model'.

SQL Server interview questions/training: - What is page split? 

In this video we will try to understand how indexes impact performance for insert,update and delete. While doing so we will also look in to the concept of page split.

SQL Server interview question: - Difference between UNION and UNION All? 

This is a important SQL server interview question asked in the most of the interview.

What is SSIS , SSAS and SSRS ( part 2) with sample demo? 

In this video we will try to understand what is SSIS , SSRS and SSAS, We also see a sample demo of ETL ( Extraction transformation and loading). This video series is for people who wants to Microsoft business intelligence.

What is SSIS , SSAS and SSRS ( part 1) with sample demo? 

In this video we will try to understand what is SSIS , SSRS and SSAS, We also see a sample demo of ETL ( Extraction transformation and loading). This video series is for people who wants to Microsoft business intelligence

How can we improve SQL performance using profiler and tuning advisor? 

This video first starts with a simple explanation of what is a SQL server profiler and performance tuning wizard. After completing the basic concepts it then demonstrates a simple example using two tables by capturing the work load and understanding the recommendations given by the tuning wizard.