Solved

How to locate number of rows without firing select count(*) query

Posted on 2012-03-20
2
234 Views
Last Modified: 2012-03-20
Hi,
I have 4-5 massive BI tables where the records are in hundreds of millions. I can't fire select count(*) as that will take next 4-5 hours to return results from these tables. The server is already overused.

I can see the query is estimating the execution plan & rows. Is there is an internal optimizer table from where I can get apprx number of rows at each table?


Thanks
0
Comment
Question by:crazywolf2010
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 25

Expert Comment

by:jogos
ID: 37742085
In the DMV sys.dm_db_index_physical_stats and there the record_count, but read comment on this at
http://msdn.microsoft.com/en-us/library/ms188917.aspx
0
 
LVL 10

Accepted Solution

by:
Ramesh Babu Vavilla earned 500 total points
ID: 37742132
sp_spaceused 'tabelname'
resutls gives, rows, reserves space, data space, index space
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server maintenance plan 8 61
How can I use this function? 3 35
T-SQL: Need Group By to use "fuzzy logic"?? 3 46
Any benefit to adding a Clustered index here? 4 32
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question