Practical use of approximate match and exact match in Vlookup function of excel.
via How to use Approximate and Exact match in VLOOKUP function? — Excel Mode
Month: September 2017
Question: How to Kill User Sessions (SPID) in SQL Server? Answer: Before I answer this question, I need to ask one more question – “Why do you want to kill all of the user sessions in your SQL Server?” Honestly, I do not see any valid business logic to kill all the SPID in the SQL…
Managers complain that they don’t have time to monitor and manage their team’s energy. Yet, when their car gets close to “E”, they take time to fuel up. Short-sighted managers care more about fueling cars than energizing people. You refill the car when the gauge reads low. So why are the tanks on your team […]
via How to Bring the Power of Purpose into Daily Practice — Leadership Freak
Introduction At times a user may perform UPDATE operation or DELETE operation in SQL server database without applying the WHERE condition. This is a very common reason for encountering loss of data from SQL Server Tables. As the SQL Server database is a highly popular relational DBMS among corporate sectors and businesses, the data loss […]
via Recover Deleted Data from SQL Table Using Transaction Log and LSNs — Prashanth Jayaram
In these article, let us discuss about the rank functions in SQL server. The ranking functions are the subset of built-in functions in SQL Server. It provides the ability to rank the rank the rows from the result set over the partition. It assigns the numbering to the records in the result set. Let see […]
Databases are platforms that are designed to securely store and retrieve your data. Perhaps that’s why they’re called a data “base”? So if your data is in a base, you’d want to lay it out in some logic way.
via SQL Server: The danger of large data types — SQL TECH BLOG
In the world where Data is the new oil, there is an overwhelming demand for organizations to provide data-driven business decisions. Numerous Business Intelligence tools are being used to assist in providing competitive advantage. Yet, the backbone of these is Data Integration. Numerous sources, such as flat files, databases and spreadsheets are being consolidated in […]
via Developing Metadata-Driven ETL Framework Using SQL Server — For the Love of Code and Data
