#SSAS, #SSAS INTERVIEW QUESTIONS ANSWERS 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, one of the 20:53 Share
#SQL SERVER INTERVIEW QUESTIONS 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 most transact 21:54 4 Share
#SQL SERVER INTERVIEW QUESTIONS 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 transactio 21:14 1 Share
#SQL SERVER INTERVIEW QUESTIONS 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 without effecti 23:39 1 Share
#PERFORMANCE TUNING, #SQL SERVER INTERVIEW QUESTIONS 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: 21:48 Share
#SQL SERVER INTERVIEW QUESTIONS 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 systems: SQL Serve 20:03 1 Share
#PERFORMANCE TUNING, #SQL SERVER INTERVIEW QUESTIONS 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 space availabl 23:58 Share
#PERFORMANCE TUNING, #SQL SERVER INTERVIEW QUESTIONS 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 reducing the 20:37 Share
#PERFORMANCE TUNING, #SQL SERVER INTERVIEW QUESTIONS 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 with exampl 20:29 1 Share
#PERFORMANCE TUNING, #SQL SERVER INTERVIEW QUESTIONS 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) in the st 19:52 1 Share
#PERFORMANCE TUNING, #SQL SERVER INTERVIEW QUESTIONS 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 page usage 19:47 Share
#FUNNY INTERVIEW, #FUNNY SQL QUERY 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, so that 04:41 Share
#DATABASE INTERNAL, #PERFORMANCE TUNING 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 can be refe 00:03 Share
#PERFORMANCE TUNING, #SQL SERVER INTERVIEW QUESTIONS 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 filegroup is a logic 23:08 Share
#PERFORMANCE TUNING, #SQL SERVER INTERVIEW QUESTIONS 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 where index_id = 0 Ans: If you h 20:06 Share
#SQL SERVER INTERVIEW QUESTIONS 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 test paper, so 22:57 Share
#SQL SERVER INTERVIEW QUESTIONS, #TESTER INTERVIEW QUESTIONS 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 testers so that y 22:41 Share
#OTHER 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 average a sad p 19:06 Share
#SQL QUERY QUIZ, #SQL SERVER PUZZLE 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 SERVER PUZZLE SE 18:46 Share
#SQL SERVER PUZZLE, #SQL SERVER QUIZ 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, there are all 18:39 1 Share
#SQL SERVER INTERVIEW QUESTIONS 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 for creating a t 23:35 Share
#SQL SERVER INTERVIEW QUESTIONS 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 23:21 Share
#SQL SERVER INTERVIEW QUESTIONS 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 23:03 Share
#CAREER ASPIRATIONS SAMPLES 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 important p 21:43 Share
#PHOTOGRAPHER INTERVIEW QUESTIONS 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 depends on havi 21:06 Share
#CAREER ASPIRATIONS SAMPLES 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 responsibilities an 20:53 Share
#CAREER ASPIRATIONS SAMPLES 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 imagine. The k 20:36 2 Share
#PyQt Interview Questions 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-platform GU 23:13 Share
#JOB DESCRIPTION DevOps Engineer Job Description Job Description: Sr.Software Engineer (DevOps), ASDA-GroceryAs a Software Engineer (DevOps) you will work closely with developers in supporting new ap 22:41 Share
#DevOps Interview Questions 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 communicati 22:28 Share
#COMMON INTERVIEW QUESTIONS 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 universities that ar 21:28 Share
#2015 BEST INTERVIEW QUESTIONS ANSWERS, #COMMON INTERVIEW QUESTIONS 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 situations, previous p 20:59 Share