how you can get the list of largest tables in a database? : Sql server administr

how you can get the list of largest tables in a database? : Sql server administration

Question Posted / kum anshu

how you can get the list of largest tables in a database? : Sql server administration..

Answer / Abhishek Srivastav

The list of largest tables in a database can be obtained using either the sys.partitions view or the DBCC IND function.

Is This Answer Correct ?

0 Yes

0 No

More SQL Server Interview Questions

What is table constraint?

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

what is difference between NULL and ISNULL in SQL Server 2008?

What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

How do you delete duplicate rows in sql server?

How to create a new login name in ms sql server?

What is a trigger?

What is in place upgrade in sql server?

Explain about unique identifier data type in sql server?

hi,i want t0 knom d syntax for a super key with an example

What is join query?

For more SQL Server Interview Questions Click Here