locked
test 21 RRS feed

  • Question

  • 1234


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    Wednesday, March 15, 2017 2:42 AM

All replies

  • test
    Thursday, March 30, 2017 8:22 AM
  • test
    Thursday, March 30, 2017 8:23 AM
  • use AdventureWorks2008R2;
    select t1.name,t2.rows from sysobjects t1
    inner join sysindexes t2
    on t1.id=t2.id
    where t1.type='U' and t2.indid in (0,1)
    --order by t2.rows desc
    order by t2.rows desc,t1.name

    test codebox


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, April 10, 2017 7:50 AM
  • Hi arifulhaq,

     

    You can refer to this case:

     

    I suggest you trying the method given by Erland, but please refer to this document: System Dynamic Management Views -> https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/system-dynamic-management-views if you are not familiar with these DMV stored procedures.


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, April 10, 2017 7:51 AM