One of the most common reasons for performance issues in software applications is missing or incorrect database indexes, so the goal of this article is to provide an introduction to the concepts and real-world practice of indexing for developers.
-
-
Parameter Sniffing
References https://hackernoon.com/why-parameter-sniffing-hurts-your-sql-query-performance-d73c0da71fbc https://blogs.technet.microsoft.com/mdegre/2011/11/06/what-is-parameter-sniffing/ https://www.mssqltips.com/sqlservertip/3257/different-approaches-to-correct-sql-server-parameter-sniffing/
-
What is Data, Database and Database Management System (DBMS)?
Data Data is any sort of information which is stored in computer memory. This information can later be used for a website, an application or any other client to store for future purpose. The most common information is User information in the form of user personal, address and banking information. Let’s consider Facebook, it stores our personal data, images, posts, comments and many more things. Banking application also stores user data, their transactions details, funds summary etc. All this information is data, but when it put together and store in a structural way, it becomes informational data. Database A database is a collection of information that is organized so that…