SQL Server DB to big, out of disk space

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

SQL Server DB to big, out of disk space

Author

Topic

ismailc
Constraint Violating Yak Guru

290 Posts

Posted - 2013-11-12 : 02:32:32

Good day,

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?

Regards

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-11-12 : 02:54:44

http://sqlservergeeks.com/blogs/riteshmedhe/sql-server-bi/422/sql-server-identify-unused-tables-indexes

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

ismailc
Constraint Violating Yak Guru

290 Posts

Posted - 2013-11-12 : 04:05:44

Thank You very much, worked for me :)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-11-12 : 12:56:06

welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources