SSAS interview Questions : Explain what is Impersonation Options in SSAS? When creating a data source object in an Analysis Services model...
Question: Lets suppose that you have three level nested transaction, and you Rollbacked two inner transactions and you Committed outer mo...
Question: Lets suppose that you have three level nested transaction, and you commit two inner transactions and you roll-backed outer most ...
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...
Step 1: Open SQL Profile and Click on create New Trace Step 2: Step 3: Step 4:
SQL: is a query language to operate on sets. It is more or less standardized, and used by almost all relational database management system...
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...
Best practices for SQL Server data types for performance optimization: You can improve the performance of Sql Server query (make fast) by ...
Sql Sever Performance tuning Interview Question: How Fixed Length and Variable Length Data types affect performance in Sql server Explain ...
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)...
Allocation Maps: SQL Server uses special kind of pages, called Allocation Maps, to track extent(collection of 8 pages known as extent) and...
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...
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? 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? If we have a query like select top 100 index_id , * from sys . indexes wh...
WRITTEN TEST : SQL QUERIES INTERVIEW QUESTIONS ANSWER Below are the set of most common and useful SQL interview questions for written tes...
MANUAL TESTING - SQL QUERY INTERVIEW QUESTION ANSWERS Below are the set of most common and useful SQL interview questions for manual tes...
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...
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 QUIZ : IF YOU THINK YOU ARE EXPERT THEN SOLVE THIS PUZZLE This quiz is for both experienced and fresher Sql developers, t...
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? Ans: Yes You can see blow screen shot
What is the extension for trace file in SQL Server Profiler? : Sql Server Interview Questions Ans: .trc
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...
The photography is the most widespread among people of all ages hobby, but difficult to master. To make good photographs, not only it depen...
Each year, many people must detail their performance at work through a performance assessment. While it is essential that details responsib...
Aspiration Example: Blogging is not just limited to fashion and food but also travel, technology, home decor and whatever else you can imag...
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...
Job Description: Sr.Software Engineer (DevOps), ASDA-GroceryAs a Software Engineer (DevOps) you will work closely with developers in suppo...
Explain what is DevOps? DevOps is a newly emerging term in IT field, which is nothing but a practice that emphasizes the collaboration and...
The arrival of Internet has impacted favorably education . Thanks to this resource many people can make online courses taught by universiti...
2015 BEST INTERVIEW QUESTION ANSWER FOR JOB INTERVIEW Job interview must prepare thoroughly. Think about what kind of specific situatio...
