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.
Advertisements
Author: Afterowl
Growing up playing Street Fighter at Dunkin Donuts or at 7-11 until I ran out of quarters I knew I was going to program video games as an adult. I started out web programming and database programming to the point that became me. Programming video games unfortunately became a hobby. When smartphones first came out, I programmed Android, Windows, and IOS mobile apps but would never leave desktop and web programming.
Batch Delete
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.
Batch Insert
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).
Alter Schema
Why should you use many schemas?
Create and Write to a File
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.
Union vs Union All
So what’s the big difference between Union and Union All? Let’s take a look.
Useful Basic Functions
Here’s a short video on using some basic MS SQL Functions
