I'm New to SSIS & would need help for the below.
How to determine which index has fragemenation in the data base, Unfortunately, our Service ID doesn't have authority to execute DBCC commands and the Update Statistics is not upto against our DB. So I would like
to determine what we can do to identify and "handoff" SQL to them that they can schedule to keep our db optimized as well as possible.
View Complete Post