How Can I Determine The Size Of A Database?
Mar 8, 2007Simple question...
When I use the full version of SQL Management Studio, I can run a report to view the size. How can I do this with SQL Mgmnt Express?
ADVERTISEMENT
How To Determine Size Of Database
Feb 25, 2015I ran a query to see how big my database on my SQL Server is and do not understand the metrics. I want to see how much of my 10GB database is left.
database_namedatabase_sizeunallocated space
ANTHEMQ 6521.06 MB243.55 MB
reserveddata index_sizeunused
1332304 KB1328168 KB1800 KB 2336 KB
SQL 2012 :: Determine Size Of Database
Sep 17, 2015I am working on Sql Server 2012. and I have multiple databases there. Out of those, i want to move one of my databases to other SQL server 2012, For that i was trying to get approximate size of my database on current server. As i don't have the admin rights, so i can't get that. Can i get the approximate size by right clicking on database and by using the size property Under Database category to get the size idea?
View 4 Replies View RelatedDetermine File Size.
Aug 30, 2006Hi all,
Does any one know how to determine file size using SQL stored Procedure or a function?
My requirement is that I need to kill a file from a specific directory if the file size is 0 kb or 1 kb
Any Ideas?
HOW TO DETERMINE DB SIZE AND MACHINE REQUIREMENTS
Oct 30, 2000I'm developing a website that will be suported by a SQL Server database. The estimated number of records for that database will be around one million. I'm concerned with the possibility of my machine being unable to respond to the needs of such a database so i decided to acquire a new one. How do i calculate the hard disk and RAM i'm going to need for this database to function properly ? I know that i can make a HD prediction by adding the sizes of each field of my database and multiplying by one million but i don't know how much KBs each field occupy (some of them -few- will even be free text fields). And the RAM ?
Help... Anybody ?
Thanks,
Carlos.
Query To Determine Table Size
Mar 7, 2001Hi all,
I am looking for a query to determine the exact size of a large table.
Thanks
JJ
Determine The Size Of An Image Datatype
Nov 3, 2004Is there any method to find out the size of an image datatype currently in the database. For example I have 2 tables that contain the same image, but the archive table is not displaying the same as the main. I am thinking the image file was corrupted somehow but don't know how to check this out.
Any ideas?
Determine The Exact Size Of Row Which Contain Text
Mar 15, 2008Dear All
can any one help me to determine the exact size of existing row contain data type : varchar ?
thanks
Reporting Services :: Determine Objects Inhibiting Horizontal Shrink Of Tablix And / Or SSRS Report Size?
Jun 10, 2015I am working on complex invoice document that handles various types of invoicing, credit, and progress bill customer facing documents. Â I am faced with same problem I see many SSRS devs posting on. Â And that is extra blank pages, being generated because the report width exceeds the width of the page.
My problem is I cannot shrink the horizontal width of the tablix and therefore the report width either...
While I would have done things differently if developing from scratch, the tablix in question has only one column and objects contained in rectangles are placed in the row/column cell.....The link to the image below shows the row I am currently working on. Â Essentially all the client wants a columnar report with column lines, closed footers, etc... Â so rather redoing the whole tablix, which I still might do, I am using rectangles with the column then lining them up. Â Anyway, that is a whole 'nuther post. Â My specific questions are: Â
Invoice in Report Builder
1. In the image I have selected the parent rectangle. Â The children are other rectangles and the data is with grandchildren textboxes that exist within those rectangles. Â I clearly have a bit of right side white space in the main parent rectangle, but there is no sizing tool on a hover... just move tool. Â And if I change the rectangle size in the prop form it just snaps back to the cell width. Â How do I size the parent rectangle and keep if from expanding.
Here I am guessing that to actually reduce the horizontal width of tablix and then the report, I have to first decrease the parent width of the rectangles that occur in each row?
How To Determine Last LSN For Database
Feb 13, 2008
What is the most reliable way to determine the last LSN of a database? I've looked in sys.database_files to no avail. I've also looked in msdb.dbo.backupset which is accurate but only based on backups already performed not the current state of the database.
-joe
Need To Determine If Records Are Already In Database
Feb 21, 2001Problem: I can add 4 items to a SQL 7.0 database but I need to redirect the user if all 4 items exist in the same Record elsewhere in the Database.
Clearly I need some kind of statement like "if category1 = var1 AND category2 = var 2 AND..." but don't know where to put it.
Code:
strSQL = "SELECT * FROM tblUserQuarter"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open strSQL, objConn,adOpenStatic , adLockOptimistic
'Insert choices from report.asp into tblUserQuarter
objRS.AddNew
objRS("cboFY") = Request.Form("cboFY")
objRS("Quarter") = Request.Form("Quarter")
objRS("ID") = Request.Form("ID")
objRS("Report") = Request.Form("Report")
objRS.Update
objRS.Close
Set objRS = Nothing
objConn.Close
set objConn = Nothing
Determine Date Database Was Last Used ?
Jun 15, 2006Hi There
I am trying to establish the date a database was last used.
At first i checked out sp_helpfile and sysfiles to see if there was a date last modified, i also tried using xp_cmdshell to check the date on the actual .mdf or .ldf on the o/s but if the file has not grown the date will be the create date.
I need to establish the date a database was last used, either the last time someone logged into it or the last time any sort of command was run against the database, i cannot use sysprocesses as there are no connections to the database, so i need to determine the last time there actually were any processes run against this database.
And i need to use tsql, checking audit logs etc is not viable, can anyone help ?
Thanx
Determine Last Access Of A Database Or Table
Dec 18, 2007Does anybody know of a way to determine the last date/time a table has been accessed (query/update)? I've done enough research to know that this isn't easy. However, perhaps somebody has figured out a way through some of the stats that SQL Server keeps to determine the last access of a table. I have recently been put on a team that had no DBA and has a number of databases out there. They would like to determine which databases are inactive and get rid of them. I am a developer and haven't had much SQL Server Administration experience. Any info will help greatly! Thanks!
View 2 Replies View RelatedDetermine When A New Record Is Added To A Database
Dec 31, 2007I have a SQL database that gets populated by another program. Is there a way to determine when a new record is added to that database?
Thanks
How To Determine Sp Caller Current Database?
Aug 23, 2007When executing a stored procedure that is defined in another database, as:
USE db1;
EXEC db2.dbo.sproc;
Is there a way in the stored procedure "sproc" to determine that the caller made the call from db1?
Table Size And Database Size
Mar 2, 2008Hi,
i use this script that show me the size of each table and do the sum of all the table size.
SELECT
X.[name],
REPLACE(CONVERT(varchar, CONVERT(money, X.[rows]), 1), '.00', '') AS [rows],
REPLACE(CONVERT(varchar, CONVERT(money, X.[reserved]), 1), '.00', '') AS [reserved],
REPLACE(CONVERT(varchar, CONVERT(money, X.[data]), 1), '.00', '') AS [data],
REPLACE(CONVERT(varchar, CONVERT(money, X.[index_size]), 1), '.00', '') AS [index_size],
REPLACE(CONVERT(varchar, CONVERT(money, X.[unused]), 1), '.00', '') AS [unused]
FROM
(SELECT
CAST(object_name(id) AS varchar(50)) AS [name],
SUM(CASE WHEN indid < 2 THEN CONVERT(bigint, [rows]) END) AS [rows],
SUM(CONVERT(bigint, reserved)) * 8 AS reserved,
SUM(CONVERT(bigint, dpages)) * 8 AS data,
SUM(CONVERT(bigint, used) - CONVERT(bigint, dpages)) * 8 AS index_size,
SUM(CONVERT(bigint, reserved) - CONVERT(bigint, used)) * 8 AS unused
FROM sysindexes WITH (NOLOCK)
WHERE sysindexes.indid IN (0, 1, 255)
AND sysindexes.id > 100
AND object_name(sysindexes.id) <> 'dtproperties'
GROUP BY sysindexes.id WITH ROLLUP) AS X
ORDER BY X.[name]
the problem is that the sum of all tables is not the same size when i make a full database backup.
example of this is when i run this query against my database i see a sum of 111,899 KB that they are 111MB,but when
i do full backup to that database the size of this full backup is 1.5GB,why is that and where this size come from?
THX
SQL Server 2014 :: Possible To Determine Dataflow Within A Database?
May 14, 2015Is it possible to determine the data flow within a database? e.g. I start by adding/inserting a record in MainTable1, then through a trigger SubTable1, SubTable2 have records inserted into, SubTable3 has a record updated into, then a StoredProcedure1 is run which updates first SubTable4, then a StoredProcedure2 is run which adds a record in SubTable5. So by simply adding a record in MainTable1, I affect 5 other tables.
Imagine a more complex process than this one now (which I'm currently facing and I want to win time and precision; I will still investigate it myself (if I will find an answer first - I will post it here)) Is there a way I could "extract" this flow by using T-SQL?
How Do I Determine The Backup Date Of A Restored Database..?
Feb 1, 2007Hi All,I have to a few backups restored from a set of backup files. Thebackup files have been removed from the drive because of some storageconstrains...For some data comparison reasons, I need to figure out the actual dateof these backup files that is used to restore these databases. Isthere any system table I can query to figure the actual backup timesof these databases...Any help will be much appreciated.. Thanks in advance.- Aravin
View 1 Replies View RelatedCannot Determine How To Set Owner To Install Database Design
Jun 14, 2007My compatibility settings are fine. Anyone know how to to this?
View 4 Replies View RelatedDB Engine :: Determine Database Access History?
Jul 31, 2015I was asked to determine the last time 2 databases were accessed.
Are the .trc files an accurate way to determine the database access history?
SQL Security :: How To Determine What Certificate Is Used To Encrypt A Database In 2014
May 28, 2015I use a number of certificates on my database server. Â I'm trying to verify the correct certificate is being used on the correct database.
View 3 Replies View RelatedWay To Determine Which Logins Have Write Permissions To Database On Sever
Nov 15, 2007Hi there,
Does anyone know a way (a query perhaps?) to determine which logins have write permissions to a specific database on SQL Server 2005? Ive thought about joining sys.syslogins & sys.sysusers but looking at the columns, not sure which one would render me that info.
Any help is appreciated. Many thanks!
Waht Is Tempdb Database Used For? And How Can We Determine What Files Can Be Deleted From It?
Jun 25, 2007Hi, all experts here,
Thank you very much for your kind attention.
Just found that my tempdb is always full whenever I run a query against a large database. Could please any experts here give me any advices on what is tempdb database used for and how to determine what files can be deleted from it?
I am looking forward to hearing from you and thanks a lot in advance.
With best regards,
Yours sincerely,
Transact SQL :: Determine When Database Was Backed Up Without Using MSDB Tables?
Apr 22, 2015I was wondering if there was another method to determine when a database was last backed up without using the backup history tables in msdb? whether using DBCC DBINFO, DBCC PAGE on a specific database page...etc.
Also, when restoring a database, is there a trace flag you can use to force restore details to be written to the error log?
SQL 2005 Resize Initial Log Size: MODIFY FILE Failed. Specified Size Is Less Than Current Size.
Sep 4, 2007
I am trying to resize a database initial log file from 500M to 2M. I€™m using€?
ALTER DATABASE <DBNAME> MODIFY FILE ( NAME = <DBLOGFILENAME, SIZE = 2 ) "
And I'm getting "MODIFY FILE failed. Specified size is less than current size." I tried going into the database properties and setting the log file to 2M, but it doesn€™t keep the changes.
Any help with this process?
SQL Server 2012 :: Determine Read / Write Frequency On Database Table
Oct 6, 2015How do I determine the read/write frequency on a database table? I am trying to do this on a 2012 and 2008 R2 servers.
View 2 Replies View RelatedGetting Database Size And Log Size
Aug 11, 2000Hi,
I am using
exec sp_helpdb
go
dbcc sqlperf(logspace) for
getting database size and log size. Is this gives the correct
database size and log size or Is there any other way to get the logsize and database size by means of query analyzer.
Thanks in Advance.
Seenu. S
The Database File Is Larger Than The Configured Maximum Database Size.
Mar 20, 2007I'm getting this error while trying to insert records into a SQL Server Compact Edition database. I have pasted my connection string that was used when creating the database as well as for accessing that same database from my Windows application.
Thanks for any help any of you can give!
Data Source=OnTheGo.sdf;Encrypt Database=True;Password=<password>;Max Database Size=4091
Database File Is Larger Than The Configured Max Database Size.
Feb 18, 2008Hello,
I am developing a smart device application with Visual Studio .Net 2005 and SQL Server Compact Edition database. And also using merge replication to synchronize the data from the mobile device to the SQL Server.
My database size is around 350MB. So when I am trying to synchronize this is the error message that I get.
" The database file is larger than the configured maximum database size. The setting takes effect on the first concurrent database connection only.[Required Max Database size ( in MB; 0 if unknown)=129].
I tried changing the Max database size in the connection string and my connection string looks as follows and still did not have any luck.
connstr= "Data Source=Storage CardItems.sdf;Max Database Size=500;"
Any help regarding this would be appreciated.
Thank you
.
How To: Determine If Current Windows User Has Login Access, Database Access And If They Are A Member Of A Specific DB Role.
Mar 25, 2008
I need to determine the following about the current authenticated Windows domain user who is trying to access a SQL Server via a trusted connection.
1 Has the current user been granted login access to the trusted SQL Server?
2 Has the current user been granted access to a specific database?
3 Is the current user a member of a specific database role such as (DB_ROLE_ADMINISTRATORS)?
Thanks,
Sean
Database Log Size
Jun 7, 2007hi
my database on remote server i cannot access directly.
i can access it only with query analyzer.
my log file size is 9mb but nothing in database. only few tables there so how i can reduce log file size with query.
thanks
How To Get The SQL Database Size
Jul 15, 2004Is it possible to get the SQL Server database size programmatically?
I have an WEB application in c# ASP NET, but I can found any information about.
Thanks for your attention
Freedeveloper
Database Size
Mar 1, 2002We have a SQL server database most time for read only because the data source comes from another database( which is not SQL server database, now it is about 2G). Every day we have a job running as following:
Step 0. extra the data from another database, and create plain text files for each table for BCP job.
Step 1. drop all of the index
Step 2. truncate all of the tables.
Step 3. BCP in all of the data from plain text file.
Step 4. create all of the index again
Step 5. shirnk the database.
Everything runs fine but the database grows 1 G from yesterday's database. I am sure we do not have so much data entry in one day.
Any one can give some suggestion?
I wonder if I need do shirnk the database or shirnk the data file before create the index.
How can know how much size for all of the index file?
Thank you very much.
Judy