Month: September 2017

How to use Approximate and Exact match in VLOOKUP function? — Excel Mode


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

Advertisements

How to Kill User Sessions (SPID) in SQL Server? – Interview Question of the Week #140 — SQL Authority with Pinal Dave


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…

via How to Kill User Sessions (SPID) in SQL Server? – Interview Question of the Week #140 — SQL Authority with Pinal Dave

How to Bring the Power of Purpose into Daily Practice — Leadership Freak


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

Recover Deleted Data from SQL Table Using Transaction Log and LSNs — Prashanth Jayaram


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

Rank functions in SQL Server — My coding exploration


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 […]

via Rank functions in SQL Server — My coding exploration

SQL Server: The danger of large data types — SQL TECH BLOG


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

Developing Metadata-Driven ETL Framework Using SQL Server — For the Love of Code and Data


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