When working in a very large SQL Server environment, it is very common that no one in the organization knows who uses a particular database. This scenario is very common if there are multiple legacy systems. Follow this article to identify how effectively your SQL Server databases are used.
Method 1:
In this method, we are going to read the output of sp_who2 and capture it in a table. The first step is to create the table using this script.
CREATE TABLE T1 (
session_id INT
...
Read more »
“Cleaning” information before you import it into your database is pretty standard – after all, one of the reasons you’ve started to use a database is so that you can predictably query that database for set criteria right…right? So how you handle external situations where, for example, you have to import info from a file where one person enters “$” but another assumes you know it’s a monetary value – or worse, where someone enters “am” or “pm” but another person uses the 24-hour clock? As usual,...
Read more »
In this post, we are happy to share with you 4 ways to unselect the trailing space while selecting a word by double click in Word.
The quickest and easiest way to have a word in selection is to double click on it. However, Word by default selects the trailing space after the target word for you as well. This feature can be annoying if you need to copy the word as a part of password.
Therefore, we find 4 methods to tackle this problem.
Method 1: Press “Shift+ Left arrow”
First of...
Read more »
