creative developer(SQL-DOTNET)

Introduction Waterfall model follows application development in phases with checkpoint and deliverable documents in each checkpoint. It advocates rigours project management, strategy and processes to track the status. The main drawback is that it requires more than 80% project understanding before kicking off the project which is impossible in major cases. Cause of volatile requirements and understanding business feels, 80% of software projects using this methodology fail to meet their objectives. Typical Waterfall Model Agile Methodology Agile mythology has small box iterations rather than phases. The output of each iteration will be production release deliverable and could be evaluated and get early feedback. Agile was a significant departure from the heavyweight document-driven software development methodologies—such as waterfall—in general use at the time. Agile refers to more collaboration and interaction between different departments at enterprise level and delive...

SQL SERVER – The Difficult Interview Question – Moment of the Life – Day 31 of 31 Please read the  Introductory Post  before continue reading interview question and answers. Complete  List of all the Interview Questions and Answers Series blogs . We have spent the last 30 days going over questions and answers you may come up against when you are being interviewed.  Of course, I am only human and I can’t provide you with the answer to every question, or even the answer to every situation – because sometimes acing an interview is more than getting all the answers right. Sometimes acing an interview is more about impressing the interviewer with your personality or with your reasoning abilities.  Remember that you are probably being hired to work at a company with many other employers, so your interviewer is not only concerned with how much you know but how well you will work in a team. Even if you are totally prepared and are a great team player,...

SQL SERVER – ORDER BY Does Not Work – Limitation of the Views Part 1 Recently, I was about the limitations of views. I started to make a list and realized that there are many limitations of the views. Let us start with the first well-known limitation. Order By  clause does not work in View.  I agree with all of you  who say that there is no need of using ORDER BY in the View.  ORDER BY should be used outside the View and not in the View. This example is another reason why one should not use ORDER BY in Views. Here is the quick example for the same. I have used sample database AdventureWorks for the example. USE  AdventureWorks GO -- First Run regular query and observe SELECT  * FROM  Sales.SalesOrderDetail ORDER BY  SalesOrderDetailID  DESC GO -- Create view with same T-SQL Script IF  EXISTS ( SELECT  *  FROM  sys.views  WHERE  OBJECT_ID  = OBJECT_ID ( N'[db...