Get size in SQL server

Question

0.00/5 (No votes)

See more:

Is it possible to get the size of a table by select-command in SQL-server with some conditions?
for example, I would like to get the size of the table when its date=currentTime
not for all dates just size in the table by the current date.
Thank you.

What I have tried:

size of the table in by condition

Posted 20-Oct-20 0:03am

Moses_k

Updated 20-Oct-20 1:44am

Add a Solution

Comments

CHill60 20-Oct-20 6:19am

By "size" do you mean the amount of space taken up on disk or the count of records that match your conditions?

Moses_k 20-Oct-20 6:41am

Yeah, I want to get this size on disk

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2020-10-20T01:44:00

Solution 1

Ok. This isn't an exact science because you also need to cater for indexes but these posts will get you started -
sql server - Find the disk size of specific rows - Database Administrators Stack Exchange[^]
Calculate Data Row Space Usage In SQL Server[^]

Posted 20-Oct-20 1:44am

CHill60