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.