Fixing Microsoft SQL SERVER database slow issue (Only expert)
Budget: $30 – $250 USD
I have identical two database one is slow and one fast both are cleaned database.
The databases had data and i used this query to clean the tables
DELETE FROM tablename
DBCC CHECKIDENT (tablename, RESEED, 0)
I have used this query to clean every table with one database the other database im not sure if i used this query with all table or sometimes used TRUNCATE table
I want someone who are able to find why one of them are slow and fix it.
I will show you both databases when i restore them from bak file.
You will use anydesk to access to my computer to show you the problem.
The databases had data and i used this query to clean the tables
DELETE FROM tablename
DBCC CHECKIDENT (tablename, RESEED, 0)
I have used this query to clean every table with one database the other database im not sure if i used this query with all table or sometimes used TRUNCATE table
I want someone who are able to find why one of them are slow and fix it.
I will show you both databases when i restore them from bak file.
You will use anydesk to access to my computer to show you the problem.