|
I would help but I have never used MSDE, isn't this a forerunner to sql server express? Looks like some likely responses with this search[^]
|
|
|
|
|
Hi,
I am using sqlserver 2008, How can I calculate the total memory occupied by the Database with tables (>30) and also data in it.
I mean if I have DB (DB_name) and with few tables(tblabc, tbldef......) with data in it, how to calculate the total memory occupied by the database in the server.
Kindly Help me.
Thanks
Ramm
|
|
|
|
|
Like this:
use YourDBName
SELECT size FROM sys.database_files
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
Hi D@nish,
I executed the query, it showed, 1408 and 2768 without data in database.
even with data it showd the same numbers.
please help me.
Thanks
Ramm
|
|
|
|
|
Well have a rat around the management studio, sysobjects also has lots of info.
Take a look at the system views, they are design to give you info on your databases.
|
|
|
|
|
Right Click your database in Object Explorer, Select Reports - Standard Reports - Disk Usage
explore these reports for common reqs.
I don't speak Idiot - please talk slowly and clearly
I don't know what all the fuss is about with America getting it's first black president. Zimbabwe's had one for years and he's sh*t. - Percy Drake , Shrewsbury
Driven to the arms of Heineken by the wife
|
|
|
|
|
Size is the size of mdf and ldf file in 8K pages. Divide the value by 128 to get the size in MB.
It might come same with/without data depending upon the amount of data your DB holds.
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
Hi,
Hi,We are migrating our DB from MS Access to SqlServer 2005. So could anybody please let me know how to copy the data in MS Access tables, first to an XML file and then to a table in Sql Server 2005, using C# as programming language and .NET 2005 as platform.
Thanks & Regards
Puneet
|
|
|
|
|
What happenned to your migrate from Access to SQL - what you are trying is not the best way of doing it.
If you assume that SQL Server can read a datatable written as an xml file you could read the table into the client C# and wtrite it out using datatable.writexml(filename)
|
|
|
|
|
i've installed sql server in windows authentication.I want to change the authentication mode to sql sever..How can i do this without reinstallation?
|
|
|
|
|
I thoight that was a setting on the database not the server - nope just checked.
I can change it in Management studio 2005+, you may need to use a script to change it in 2000. Can you right click on the server in QA and get the properties of the database?
|
|
|
|
|
Start 'SQL Server Enterprise Manager"
Right click on your server and choose properties
Select the Security tab and do you configuration.
Wout Louwers
|
|
|
|
|
Hi,
We are migrating from MS Access to SqlServer 2005. Could anyone please let me know how to copy tables and other objects (Stored procedures, triggers) from our current Access Database to SqlServer 2005.
Thanks & Regards
Puneet
|
|
|
|
|
This is how it is being done in sql server 2000.first from enterprise manager right click on the database.
2)choose new database and create a new database with the name of your sql server database.
3)Right click on the new database created and from tasks choose import data.
4)A dialog box will appear.you have to specify the datasource there,which is microsoft access in your case.Then just follow the instructions and you will get your database migrated.
|
|
|
|
|
hi
i want 2 update this record
EMP_ID SHIFT DEPT OVERTIME TIME_DATE
1 General IT 6 19-AUG-09
when i update this record then overtime add in 6 means i add 2 so overtime is 8.
how can i do this???
thanks in advance.
|
|
|
|
|
General form: update TABLENAME set FIELDNAME = VALUE where WHERECLAUSE
eg:
update tblEmployeeOvertime set Overtime = Overtime + 2 where Emp_ID = 1
|
|
|
|
|
how to send captured WireShark packets to sql database
|
|
|
|
|
Like this:
1. Parse the information.
2. Split the information into bite-sized pieces that match your table structure.
3. Use SQL (or a Stored Procedure) to insert the information.
4. Repeat until you have no packets left to process.
|
|
|
|
|
so i saved the packets to a excel file. from here i want to write a code that would let me read from that file and send that data to the database but am having problems writing that code to do this .., do you have any reading material on how this can be done
|
|
|
|
|
Last night I wanted to copy an Access 2007 .mdb file and the thing was 618 MB !  I know that there is no way there could be that much data, so I did a compact & repair and the size went down to 6 MB.
The other interesting thing about this .mdb is that there is actually no user data stored in it. It contains just the forms, queries, reports, modules. It references the data tables stored in a separate .mdb via linked tables.
What could have caused this to grow to such a large size ? I never had this problem with Access 2003.
I really can't stand any of the Office 2007 products. 
|
|
|
|
|
Why is it so? Because Access doesn't do garbage collection or cleanup particularly well.
Usually, your file will swell rapidly if you are creating temp tables through code or make-table queries.
Since you say it's your front end, one way to combat this issue is to have it compact and repair on exit.
|
|
|
|
|
This problem has been around for ages - I remember having a compact method in access 97, the user could check the size via a form and would decide when to compact the database.
This is one of the (minor) reasons to move to a decant database platform.
|
|
|
|
|
Mycroft Holmes wrote: decant database platform
Is that one that you pour from a bottle? rofl...
|
|
|
|
|
I build application in vb.net 2005. Now i want to deploy it through setup (build through setup and deployment project in vb.net),
I want to install sql server2005 express with my setup but this installation must be unattended (silent)
if anyone know, please help me and tell me the complete steps.
thanks
|
|
|
|
|
I just took an online evaluation of my SQL skills (SQL-FU?).
How would you answer this question:
"
Given the following SQL statement:
SELECT customers.customerid, currentbalance
FROM customers
LEFT OUTER JOIN customer_balance ON customers.customerid =
customer_balance.currentbalance
Which of the following statements correctly describe the result set?
A. Only customerid values with a matching value in the customer_balance table will be displayed in the result set.
B. All currentbalance columns from the customer_balance table will be displayed in the result set. Customerid values will be displayed for each customerid with a matching value in the customers table. Null will be displayed as the value for currentbalance for all customerids with no match in the customer_balance table.
C. All currentbalance columns from the customer_balance table will be displayed in the result set. Customerid values will be displayed for each customerid with a matching value in the customers table. A customerid value of null will be displayed for each customerid without a matching value in the customers table.
D. All customerid columns from the customer_balance table will be displayed in the result set. Current balance values will be displayed for each customerid with a matching customerid value in the customer_balance table. Zero will be displayed as the value for current balance for all customerids with no match in the customer_balance table.
E. All customerid columns from the customers table will be displayed in the result set. Current balance values will be displayed for each customerid with a matching customerid value in the customer_balance table. Null will be displayed as the value for current balance for all customerids with no match in the customer_balance table.
"
I decided that customers.customerid = customer_balance.currentbalance was a typo and chose E.
Ah, well, at least I got 83rd percentile. 
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
