GoGreen PC TuneUp™
Learn More

Insta-Install™
this is how we code sign our software and ssl encrypt our websites from our affiliate partner SSL.com
MTNCOMP | List | Table

myBlog

myBlog Home

Blog


SQL

Indexing data and searching revisited - SQL - MS Access

by Mountain Computers Inc., Publication Date: Friday, May 7, 2021
View Count: 113, Keywords: SQL, Data, Searching, Sorting, Hashtags: #SQL #Data #Searching #Sorting



Today, I had the opportunity to work on a 2TB database that was live, no archives, no backups.
 
So, I had to help some clients rework their reporting and queries, and it was, fun! They had good indexing and their tables were okay. They just had a problem getting some joins to work on their reporting queries. No Problem for me!
 
My days of T-SQL are long gone-- NOT! I love to explore the complexity of the database and all the tables, some 100 tables, loosely connected and tons of data.
 
When you get to play in a live production database in SQL, remember, there was a time, this was normal.
 
I am surprised they did not have a daily offline version accessible by something like MS Access with some protection and backups, etc. I might suggest that shortly. 
 
more to come...

if you found this article helpful, consider contributing $10, 20 an Andrew Jackson or so..to the author. more authors coming soon
FYI we use paypal or patreon, patreon has 3x the transaction fees, so we don't, not yet.

© 2021 myBlog™ v1.1 All rights reserved. We count views as reads, so let's not over think it.