GoGreen PC TuneUp™
Learn More

this is how we code sign our software and ssl encrypt our websites from our affiliate partner SSL.com


myBlog Home

Back to Blog List View Table View MTNCOMP


Indexing data and searching revisited - SQL - MS Access

by Mountain Computers Inc., Publication Date: Friday, May 7, 2021
View Count: 66, 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.