What is Impersonation Information in SSAS?

SSAS interview Questions : Explain what is Impersonation Options in SSAS? When creating a data source object in an Analysis Services model...

Outer Transaction is Committed but nested trans rollbacked, then what would happned, try to answer: COMMIT/TRAN SQL SERVER

Question:   Lets suppose that you have three level nested transaction, and you Rollbacked two inner transactions and you Committed outer mo...

Outer Transaction is Rollbacked, then what would happned, try to answer: COMMIT/TRAN

Question:  Lets suppose that you have three level nested transaction, and you commit two inner transactions and you roll-backed outer most ...

Set Identity in Existing table having value already in SQL Server

Suppose that you have a table with AreaID but for that column you forgot set Identity. later you got it. Now you want to set identity witho...

How you will trace all event only from a selected Database or Procedure in SQL Server Profiler

Step 1: Open SQL Profile and Click on create New Trace Step 2: Step 3: Step 4:

What is the difference between SQL, PL-SQL and T-SQL?

SQL: is a query language to operate on sets. It is more or less standardized, and used by almost all relational database management system...

What is forwarding pointer in SQL Server? How it is helpful in performance optimization?

Forwarding pointer: when you update the row in the heap table, SQL Server tries to accommodate it on the same page. If there is no free sp...

Tips for SQL Server Performance optimization by Choosing appropriate data type

Best practices for SQL Server data types for performance optimization: You can improve the performance of Sql Server query (make fast) by ...

How Fixed Length and Variable Length Data types affect performance in Sql server Explain with example

Sql Sever Performance tuning Interview Question: How Fixed Length and Variable Length Data types affect performance in Sql server Explain ...

What is Ghost Cleanup Task in Sql Server?

Ans: When you delete a row, SQL Server does not physically remove the row from the page. Rather, it flags deleted rows as ghosted (deleted)...

GAM VS SGAM IN SQL SERVER | DIFFERENCE BETWEEN GAM AND SGAM

Allocation Maps: SQL Server uses special kind of pages, called Allocation Maps, to track extent(collection of 8 pages known as extent) and...

FUNNY SQL QUERY BECOMING FAMOUS IN SOCIAL MEDIA

Today is Sunday and I was in fun mood and looking for funny thing on twitter and came across very funny query, So I think to share with you...

What is Slot Array in Sql Server? How it is related to Database Page?

Data page: The space in the database is divided into logical 8KB pages. These pages are continuously numbered starting with zero, and they ...

What are NDF Files in SQL Server?

What are NDF Files in SQL Server? Sql Server interview questions Filegroups: All database files are grouped into the filegroups. A filegr...

What do you understand by index_id = 0 and Index_id = 1? What they represent?

What do you understand by index_id = 0 and Index_id = 1? If we have a query like select top 100 index_id , * from sys . indexes wh...

SQL QUERIES INTERVIEW QUESTIONS ANSWER FOR WRITTEN TEST

WRITTEN TEST : SQL QUERIES INTERVIEW QUESTIONS ANSWER  Below are the set of most common and useful SQL interview questions for written tes...

SQL QUERY INTERVIEW QUESTION ANSWERS FOR MANUAL TESTING

MANUAL TESTING - SQL QUERY INTERVIEW QUESTION ANSWERS Below are the set of most common and useful SQL interview questions for manual tes...

Top 20 Reason Why You should Love Your Job: Even on Monday

At least a half of your waking hours spent at work. If you’re upset about being at work because you don’t love what you do, you’re on avera...

SQL SERVER PUZZLE/QUIZ SET-1 ANSWERS SET

This the the answers set for SQL SERVER PUZZLE SET-1 , So first visit quiz page then you can see answers here Correct Matches for  SQL S...

SQL SERVER ICON PUZZLE/QUIZ FOR EXPERTS AND FRESHERS SET-1

SQL SERVER ICON QUIZ : IF YOU THINK YOU ARE EXPERT THEN SOLVE THIS PUZZLE  This quiz is for both experienced and fresher Sql developers, t...

Name any three standard trace templates provided by SQL Server Profiler? Sql Server Interview Questions

Following are some most commonly used trace templates which comes with Sql Server profiler. Standard(default):  Generic starting point ...

Can you edit Sql Profiler existing/default templates? Sql Server Interview Question

Can you edit Sql Profiler existing/default templates?  Ans: Yes You can see blow screen shot

What is the extension for trace file in SQL Server Profiler? Sql Server Interview Questions

What is the extension for trace file in SQL Server Profiler? : Sql Server Interview Questions Ans: .trc

Download Top 40 New models/Sample/Example Goals for Professional

Before starting to look for a job, the first thing you should do is have a resume or CV well written. Thus, a CV should contain your most i...

How to take a good photo : Photographer interview questions answers

The photography is the most widespread among people of all ages hobby, but difficult to master. To make good photographs, not only it depen...

How to write a professional aspiration for Resume in a performance evaluation

Each year, many people must detail their performance at work through a performance assessment. While it is essential that details responsib...

Career Aspiration Example for SEO/Bloggers/Writers

Aspiration Example: Blogging is not just limited to fashion and food but also travel, technology, home decor and whatever else you can imag...

Top 10 PyQt Interview Questions Answers

1). Explain what is Pyqt? Ans: PyQt is a GUI widgets toolkit. It is a Python interface for Qt, one of the most powerful, and popular cross...

DevOps Engineer Job Description

Job Description: Sr.Software Engineer (DevOps), ASDA-GroceryAs a Software Engineer (DevOps) you will work closely with developers in suppo...

TOP 20 DevOps Interview Questions Answers

Explain what is DevOps? DevOps is a newly emerging term in IT field, which is nothing but a practice that emphasizes the collaboration and...

Advantages and Disadvantages of using Internet while Studying : Interview questions

The arrival of Internet has impacted favorably education . Thanks to this resource many people can make online courses taught by universiti...

2015 TOP 100 MOST FAQ COMMON INTERVIEW QUESTIONS ANSWERS FOR ALL

2015 BEST INTERVIEW QUESTION ANSWER FOR JOB INTERVIEW  Job interview must prepare thoroughly. Think about what kind of specific situatio...

Follow Us

Blog Archive

Recent

Comments

Donate

Side Ads

Text Widget

Connect Us

Sql Server 2017 Interview Questions
Sql Server Basic Interview Query Set-1
Sql Server Basic Interview Query Set-2
Sql Server Date-Time Interview Query SET-3
Sql Server Salary Interview Query SET-4
Sql Server Group By Interview Query SET-5
Sql Server Join Interview Query SET-6
Sql Server Tricky Join Interview Query SET-7
Sql Server DDL Interview Query SET-8
Small but very Tricky Sql Server Query SET-9
Very Much Tricky Query (not 4 fresher)SET-10
Sql Server Complex Interview Query SET-11
Sql Server Datatype Interview Questions
Sql Server View Interview Questions
Sql Server Index Interview Questions
TCS Tricky Sql Interview Queries
HCL Sql Interview Queries
Sql Server SP Interview Questions
Sql Server Trigger Interview Questions
Sql Server Temp Table Interview Questions
Sql Server 2016 Interview Questions
Sql Server Performance Tuning Interview Q.
Sql Server Constraints Interview Questions
Sql Server Storage/Size Interview Questions
Sql Server Very Basic Interview Questions
Sql Server Quiz for Fresher
Sql Server Icon Quiz for All
Sql Server 300+ Theoretical Interview Questions
Sql Server Complete Set

ASP.NET AND JQUERY INTERVIEW QUESTION
ASP.NET: Web Config Interview Question
ASP.NET: View State Interview Question
ASP.NET: Session Interview Question
ASP.NET: Session Interview Question 
ASP.NET: Security Interview Question
ASP.NET: Catching Interview Question
C# OOPS Interview Question
MORE Interview Question
JQUERY: Interview Question Set-1
JQUERY: Interview Question Set-2
JAVA-SCRIPT: Interview Question Set-1
JAVA-SCRIPT: Interview Question Set-2
ASP.NET MVC: Interview Question Set-1

POPULAR POSTS
10 MOST DIFFICULT INTERVIEW QUESTIONS
5 BEST INTERVIEW TIPS
YOUR 10 MISTAKE DURING INTERVIEW
2016 TOP 20 GROUP DISCUSSION TOPICS
HOW SQL PERFORMANCE AFFECTED BY DATATYPE

Contact Us

Name

Email *

Message *

archive