In our SQL Server Database we have at least 25-35 lookup / empty tables that are never used. Is there any negative effect for keeping them in our database (performance, storage etc)
Basically, would deleteing them have any positive impact on queries etc.
Remove them anyway - it's a pain to maintain a database when you have to first figure out what is and isn't being used.
No there would be no positive or negative impact to removing or leaving them there, if they are not used. I would remove them.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With