The SELECT statement you’re running isn’t what it’s cracked up to be. See how SQL really sees your query. This is the SQL Order of Operation.
The SELECT statement you’re running isn’t what it’s cracked up to be. See how SQL really sees your query. This is the SQL Order of Operation.
Before you go deleting millions of records DON’T! You need to watch this video to understand why you should not delete records in one full swoop but rather in blocks.
Inserting millions of rows will take a tow on the transaction log. When you’re inserting this much data, your log file will quickly grow and will have potentials to crash your database. To help relieve the pressure of the log file, you’ll want to insert in batches (this is something that is done in SSIS).
Why should you use many schemas?
If you need a quick way to log all of the current running processes to a text file you’ll want to check out this video. In this video, I’ll show you how to get all of the currently running processes in Task Manager/Activity Monitor and save that information to a text file. Python is small in size and allows the same code to run in both Windows and Mac which is great because you don’t need to recode for the specific OS.
So what’s the big difference between Union and Union All? Let’s take a look.
Here’s a short video on using some basic MS SQL Functions
In this tutorial, I’ll show you how to draw a histo-graph using your computer’s CPU usage as the values.
Schema’s are use to help isolate users to a specific schema, ETL purposes, reusing a table name that already exists, and etc. reasons. In this video, I’ll show you how to import data into a table. Once the data is ready an Alter Schema is performed to prevent any downtime of the table.
Do you want to use Oracle’s driver to directly connect to an Oracle database instead of using ODBC (DSN)? Is it any faster? You be the judge!
Make sure you have Oracle 12g drivers installed on the server. This could be any version of Oracle
Make a note as to where your Oracle installation path is. You’ll need a few information from the TNSADMIN.ora file. For example, my path is C:\Oracle\Ora12\Network\Admin\tnsadmin.ora
Inside tnsadmin.ora, you’ll need the HOST, PORT, and SERVICE_NAME
In SSMS, navigate to the OraOLEDB.Oracle providers and open up the properties
Create a Linked Server
This is how you would use your new shiny Oracle Linked Server
SELECT * FROM OPENQUERY(“ORACLE”, ‘SELECT * FROM MyTable’) AS MyTable