sql server experienced interview questions Different Companies

Comments

Post a Comment

Popular posts from this blog

Package Deployment in SSIS using example

Image
http://www.learnmsbitutorials.net/package-deployment-ssis.php Introduction Hello Friends, welcome to learn #MSBI step by step I'm your #MSBI host Gurunatha S.Dogi. Little About Me : I'm one of the trainer in Questpond having more than 8 yrs of experience in #server tools, #programming and #seo. I do take trainings for freshers or an individual with 3 yrs of experience. My focus area to teach / concentrate freshers to make them comfortable in learning technology step by step. In short to make their basics strong to get started into tech world. If you want to learn #MSBI step by step then feel free to touch base with the below mentioned details. Today, In this session we will learn how to do SSIS project deployment or SSIS package deployment step wise or to deploy SSIS project into production server. SSIS Project Deployment Step by Step Deployment : Deploying is nothing but moving something from one place to another place. For example let's say dep...
Read more

FIND MISSING NUMBER

Image
https://www.dbrnd.com/2015/06/query-to-find-missing-number-id-sql-server/ Query to Find Missing Number and ID in SQL Server In this post, I will give you one full demo to find a missing number of identity column in SQL Server. Before a few days ago, I was working on production report and found that some number is missing. This sequence and missing number are very important. Immediately one requirement come to my desk is, please find a list of all missing number for investigation purpose. Below is a full demo script to find the missing number in SQL Server. First Create one sample table with data. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 /*Create one table to store Numbers*/   CREATE TABLE dbo.tbl_Numbers ( ID INTEGER ) GO   /*Insert some test records. You can also see I have missed many number which we are going to find by query*/   INSERT INTO dbo.tbl_Numbers VALUES (1),(2),(3),(4),...
Read more

Type of DataBase Model

Image
https://www.lucidchart.com/pages/database-diagram/database-models               What is a Database Model Contents A database model shows the logical structure of a database, including the relationships and constraints that determine how data can be stored and accessed. Individual database models are designed based on the rules and concepts of whichever broader data model the designers adopt. Most data models can be represented by an accompanying database diagram. Want to make a Database Model of your own? Try Lucidchart. It's quick, easy, and completely free. Make a Database Model Types of database models There are many kinds of data models. Some of the most common ones include: Hierarchical database model Relational model Network model Objec...
Read more