Finding database size in SQL Express

Our system guy wants me to find out just exactly how much room is being taken up by the SQL Express databases (I am using two). I am not sure how to do this. Is there any way to find the size, or, lacking that, how many records overall? We will probably need to move up to SQL 2005 soon, but he needs to figure out the memory requirements, etc.

Thanks,

Michael

try select [size] from sys.database_files

This will give you a row for each primary datafile and log, to get it all in one statement you could use

select Sum([size]) as total_file_size from sys.database_files

|||

Thanks, that worked.

Michael

Finding a tutorial for the complete beginner.

Is there a tutorial or documentations for the "complete beginner" similar to the one made for VB.net express but for SQL Express? I went over the Visual Web Developer Express tutorial but its only mention about sql was using the 'sqlcmd' command line tool with a copy and paste. What I'm looking for is actual docs on creating, editing, updating tables, records, etc. A GUI is what I'm really looking for; I tried using SQL Express Manager but it has no docs. Any help in the right direction is appreciated.Usually the SQL Server Books Online (BOL) offer first hand information and should really become your compagnion when dealing with SQL Server. You can download them for free from here:
http://go.microsoft.com/fwlink/?LinkId=44375

However, you might also find some use in here: http://www.microsoft.com/sql/community/webcasts.mspx
https://www.microsoftelearning.com/sqlserver2005/
http://www.microsoft.com/sql/techinfo/training/default.mspx
http://assessment.learning.microsoft.com/test/home.asp
--
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. (http://www.sqlpass.de)

|||

Frank Kalis wrote:

Usually the SQL Server Books Online (BOL) offer first hand information and should really become your compagnion when dealing with SQL Server. You can download them for free from here:
http://go.microsoft.com/fwlink/?LinkId=44375
However, you might also find some use in here: http://www.microsoft.com/sql/community/webcasts.mspx
https://www.microsoftelearning.com/sqlserver2005/
http://www.microsoft.com/sql/techinfo/training/default.mspx
http://assessment.learning.microsoft.com/test/home.asp
--
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. (http://www.sqlpass.de)

Thanks, Frank!

Finding a tutorial for the complete beginner.

Is there a tutorial or documentations for the "complete beginner" similar to the one made for VB.net express but for SQL Express? I went over the Visual Web Developer Express tutorial but its only mention about sql was using the 'sqlcmd' command line tool with a copy and paste. What I'm looking for is actual docs on creating, editing, updating tables, records, etc. A GUI is what I'm really looking for; I tried using SQL Express Manager but it has no docs. Any help in the right direction is appreciated.Usually the SQL Server Books Online (BOL) offer first hand information and should really become your compagnion when dealing with SQL Server. You can download them for free from here:
http://go.microsoft.com/fwlink/?LinkId=44375

However, you might also find some use in here: http://www.microsoft.com/sql/community/webcasts.mspx
https://www.microsoftelearning.com/sqlserver2005/
http://www.microsoft.com/sql/techinfo/training/default.mspx
http://assessment.learning.microsoft.com/test/home.asp
--
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. (http://www.sqlpass.de)|||

Frank Kalis wrote:

Usually the SQL Server Books Online (BOL) offer first hand information and should really become your compagnion when dealing with SQL Server. You can download them for free from here:
http://go.microsoft.com/fwlink/?LinkId=44375
However, you might also find some use in here: http://www.microsoft.com/sql/community/webcasts.mspx
https://www.microsoftelearning.com/sqlserver2005/
http://www.microsoft.com/sql/techinfo/training/default.mspx
http://assessment.learning.microsoft.com/test/home.asp
--
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. (http://www.sqlpass.de)

Thanks, Frank!

Find versus Select error in SQL Express.

I am trying to look up records by the first letter of the last name in SQL Express ADO recordsets.

"Select * from people where people.lastname like 'a%'"

works correctly. (a*) works also.

ptRs.movefirst

PtRs.Find "lastname LIKE 'a%'", 0, adSearchForward

Does not work, does not find anything, but if I use 'a %' ('a<space>%') it finds the first last name starting with a.

Why does a% not work. Can you not use wild characters in Find Statements in SQL Express?

Hi,

find is not a sql server statement rather than a ADO statement: http://www.devguru.com/technologies/ado/quickref/recordset_find.html

For wildcards in ADO you have to use the asteriks.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Thanks for the ADO versus SQL, I did not understand that.

IT returns the exact same with asterix in the find?

Am I doing it wrong or missing something?