Categories
Sql Server

SQL Server Interview Questions & Answers 3

SQL Server Interview Questions & Answers 3 In this post we will discuss some more SQL Server Interview Questions & Answers. 1.  What is SQL Server Architecture? Ans: 2.  What is page? Ans: The fundamental unit of data storage in SQL Server is the page. In SQL Server, the page size is 8 KB. This means […]

Categories
Sql Server

SQL Server Delete Duplicate Rows

SQL Server Delete Duplicate Rows Hi Friends in this tutorial we will learn SQL Server Delete Duplicate Rows or you can say how to delete duplicate rows in sql server. Sometime it is required to delete duplicate records from a table. We will delete duplicate rows using ROW_NUMBER() feature of SQL Server. Earlier we had discussed about How to […]

Categories
Sql Server

MySQL to SQL Server Data Migration Through SSIS

MySQL to SQL Server Data Migration Through SSIS In this post we will learn MySQL to SQL Server Data Migration Through SSIS. Here we are using SQL Server integration Services for data migration. SSIS will help us scheduling it as job to run this package on time to time. For this first we have to add […]

Categories
Sql Server

How to Get The Day of The Week in SQL Server

How to Get The Day of The Week in SQL Server In this post we will learn How to Get The Day of The Week in SQL Server. Sometime this is very useful. In earlier post we had discussed How to Password Protected Backup In SQL Server, How To Delete Backup Files Older Than n Days, Creating Resource Pools […]