So you have two tables that you want to compare to see what’s common between them and what’s not. Traditionally I have used JOINS to get what I need but did you know you can compare the two tables results simply by using the EXCEPT and INTERSECT syntaxes? Let’s look at these two beauties. EXCEPT – returns any distinct values from the left (sounds familiar LEFT JOIN) that are not found on the right query. Assuming that everyone has a master database that they can query, run the following queries to ......
Some literature first If you are not, you should start considering database encryption for your organization as data is the only reason you are in business. If and when it becomes compromised bad things are bound to happen. When TDE is enabled or disabled for that matter a background process is initiated by the server that encrypts all the database files. This is an Enterprise or Developer version(s) only feature. How it works DDL is initiated (SELECT something FROM SOMEWHERE WHERE otherthing = 'athing') ......