Recent Interview in SQL Server

4 views
1. I have 2 tables Employee and Dept.

a. Get names of all employees who do not work for anu Dept.

b. Arrange the salaries as Emp Name, Sal, Lower Sal and ...
posted Jan 20, 2017 in SQL Server by martinziller218 (100 points)
2 views
1. Tell me about last project

2. Difference between Snow and start flake schema.

3. How to increase SQL query Performance.

4. What are the ...
posted Jan 20, 2017 in SQL Server by martinziller218 (100 points)
1 view
What are different Transactions are there in SSIS?

What are the package configurations are there in SSIS?

Have you ever deal with the XML source?

posted Jan 20, 2017 in SQL Server by martinziller218 (100 points)
1 view
Stored procedure,

Joins,

Normalization,

Precedence

Constraint,

Containers
posted Jan 20, 2017 in SQL Server by martinziller218 (100 points)
1 view

How you get the requirement? verbally or by document .what is the process?
Have you ever worked for production ...

posted Jan 20, 2017 in SQL Server by srisravani132 (100 points)
1 view

Interview Question
1. difference between local and global temp table.
2. Difference between truncate and delete.
3. How ...

posted Dec 2, 2016 in SQL Server by martinziller218 (100 points)
1 view

1. Diff between local and global temp table.
2. How to load data for qlikview.
3. Types of reports in SSRS.
4. Diff ...

posted Nov 23, 2016 in SQL Server by konaharish (180 points)
1 view

1. Tell me something about you.
2. Tell me about your last project.
3. How to create cube?
4. Partition of SSAS ...

posted Nov 15, 2016 in SQL Server by prasanthshetty0 (100 points)
1 view

1) what is ssis? what is control flow, data flow and event handler?
2) what is logging? which logging way is easy and easy to ...

posted Sep 19, 2016 in SQL Server by srisravani132 (100 points)
2 views

1) tell me about ur last project?
2) what is company do?
3) which are columns in last project?
4) what is particular role ...

posted Sep 8, 2016 in SQL Server by konaharish (180 points)
1 view


PFB questions from UPS client questions:

1. Tell me about your self and explain resume
2. Indexes - cluster and non ...

posted Aug 25, 2016 in SQL Server by prasanthshetty0 (100 points)
1 view

1. Tell me about recent project.
2. Tell me about your experience with
data modeling.
3. Selectivity of Index, ...

posted Aug 4, 2016 in SQL Server by martinziller218 (100 points)
1 view

About Experience

posted Aug 4, 2016 in SQL Server by martinziller218 (100 points)
1 view

Expertise knowledge of SQL 2014 with High Availability
SQL 2008 and 2012 migration to SQL 2014
Ensure all database servers ...

posted Aug 4, 2016 in SQL Server by martinziller218 (100 points)
2 views

Brief background about myself
SSis and Datawarehouse questions
What is precedence constraint and what it's used for
What ...

posted Jul 6, 2016 in SQL Server by prasanthshetty0 (100 points)
3 views

1. writing query
2. Difference between CTE and Temp Table
3. Difference between Delete and Trunket 

 

posted Jul 6, 2016 in SQL Server by prasanthshetty0 (100 points)
4 views

About Experience and last project
Difference between UNION and UNION ALL
Scenario based question - on employee table to ...

posted Jul 6, 2016 in SQL Server by prasanthshetty0 (100 points)
1 view

Recent project
In SCD, Customer table have millions of records, in that table some columns are slowly changing, 3 columns are ...

posted Jul 6, 2016 in SQL Server by prasanthshetty0 (100 points)
1 view

Sql best practices
SSIS performance tuning
Ssis Error handling
Triggers
Indexes 

 

posted Jul 6, 2016 in SQL Server by prasanthshetty0 (100 points)
1 view

1. data profile
2. data validation
3. data cleaning
4. SDLC
5. SCD
6. Dimension and fact table
7. Star ...

posted Jul 6, 2016 in SQL Server by prasanthshetty0 (100 points)
Welcome to I Can Crack, where you can ask questions and receive answers from other members of the community.

68 questions

47 answers

3 comments

5,318 users

...