SELECT t.NAME AS TableName, i.name AS indexName, SUM(p.rows) AS RowCounts, SUM(a.total_pages) AS TotalPages, SUM(a.used_pages) AS UsedPages, SUM(a.data_pages) AS DataPages, (SUM(a.total_pages) * 8) / 1024 AS TotalSpaceMB, (SUM(a.used_pages) * 8) / 1024 AS UsedSpaceMB, (SUM(a.data_pages) * 8) / 1024 AS DataSpaceMB FROM sys.tables t INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id INNER JOIN sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id WHERE t.NAME NOT LIKE 'dt%' AND i.OBJECT_ID > 255 AND i.index_id <= 1 GROUP BY t.NAME, i.object_id, i.index_id, i.name ORDER BY TotalSpaceMB desc --OBJECT_NAME(i.object_id)
Source: http://stackoverflow.com/questions/3927231/how-can-you-tell-what-tables-are-taking-up-the-most-space-in-a-sql-server-2005-d
A good blog. Thanks for sharing the information. It is very useful for my future. keep sharing
ReplyDeletefacebook baixar
baixar facebook
baixar facebook gratis
facebook movel baixar
ReplyDeleteالرائد من افضل شركات الخدمات المنزلية في المملكة وخدماتها تغطى كل المنطقة العربية للمزيد قم بزيارة
شركة تنظيف خزانات بمكة شركة تنظيف خزانات بمكة
افضل شركة تنظيف منازل بالمدينة المنورة افضل شركة تنظيف منازل بالمدينة المنورة
افضل شركة تنظيف بمكة بالبخار افضل شركة تنظيف بمكة بالبخار
شركة نقل عفش من جدة الى الاردن شركة نقل عفش من جدة الى الاردن
شركة تنظيف مجالس بمكة شركة تنظيف مجالس بمكة
ReplyDeleteشركة تظيف مكيفات بالرياض
شركة تنظيف افران الغاز بالرياض
شركة تركيب غرف نوم بالرياض
شركة تركيب مكيفات بالرياض
شركة تركيب اثاث ايكيا بالرياض
Excellent Blog! I would like to thank for the efforts you have made in writing this post. I am hoping the same best work from you in the future as well. I wanted to thank you for this websites! Thanks for sharing. Great websites! Packers And Movers Mumbai
ReplyDeleteSpolu offers OnePlus, Mi, Vivo, Lenovo & iPhone all types od mobile mobiles repair service at your doorstep. All our phone repairs come with 6 months warranty, same day service. We'll send you a text with a link to download the app.
ReplyDeleteYou can download the mobile app here-
Doorstep Mobile Repair Service in Noida
Orel State University which is also known as Government State Educational Institution of Higher Education is identified as a prime higher education Institution in the metropolis of Orel. Orel State University was founded in 1931 as an industrial-Pedagogical Institute. In 1932 Orel Pedagogical University became Orel State University. Orel State University is unique in many aspects.
ReplyDeleteTo get Admission and more information-
Orel State Medical University
Orel State University is unique in many ways. It is the only classical university Orel, a member of the Association of classical Russian universities. It is the only institution in the region, which is training on a wide range of areas and specialties of higher and postgraduate education, training, re-training (more than 300).
ReplyDeleteTo Get more information and Admission-
Orel State Medical University
Packers And Movers Bangalore Local Household Shifting Service, Get Free Best Price Quotes Local Packers and Movers in Bangalore List, Compare Charges, Save Money And Time at
ReplyDeleteLocal Packers And Movers Bangalore
In truth, 바카라사이트 it might need the opposite effect and lead to larger losses. When you cease a slot machine by yourself, you scale back the 'time of spin' , making the sport go faster. These gamers believe that if you can cease the reels fast enough, have the ability to|you possibly can} control finish result} of your spin and determine what mixture will be displayed on the display screen. Developers paid a reasonably penny to lock within the rights to bring to the market slots that characteristic popular manufacturers and franchises.
ReplyDelete