we have a server setup where cube & datawarehouse data located on same drive but the datawarehouse db has increased a lot over the past few months and running out of disk space
is there a qeury to check which tables & data are not used in Datawarehouse & cubes?
Thank You all, i found a script to check which tables & indexes are not active
Thank you Razvan :)
Your question is a bit unclear. Can you please elaborate a little more on it?
Per aspera ad astra!
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?