I'm currently developping a windows .net compact framework application which is basically a local datalogger.
Since my application will log data to the database (located on compact flash card) a few times a second over long period, I wonder if SQL Server Compact Edition offers some mechanism to reduce disk access.
By example, can SQL Server compact edition wait let's say 5-10 "insert into" commands before actually write to the database located on the flash card ?.
Any ideas which could help me to reduce flash wear would be greatly appreciated !
I want to copy a database in my company's computer to my flash driver. Then I am going to copy this database to my home compuer. What is the full procedure?
I have a utility I wrote which can backup/restore my database as wellas schedule backups. This has always worked pretty well except when Itry to backup to a USB Flash Disk. When I use one of these the backupfails. If I backup to the C:/ drive then copy it over to the disk itworks fine but when SQL Server tries to do it, it can't.I am simply doing the following:BACKUP DATABASE MyDatabase TO DISK = 'E:/backup.dat_bak' WITH INITAnyone know what could be going wrong?
I hope somebody here can help on my problem. I wrote a MFC application using sql ce and is running prefectly smooth on wince and PPC 2003. But when i deploy it to Windows Mobile, the database performance drop dramatically. I knows the drop on performance is due to the I/O speed on the flash memory.(The previous mobile os are using ram instead). Is there any solution or work around which I can solve this problem.
Recently i solved the performance issues on "insert" to DB by using a commit buffer(Instead of commit to the sdf instantly). But how about the "select" performance? It's too slow which take about 3 sec to select a record from the DB.
Does Microsoft provide any suggestion on the sqlce perofrmance on windows mobile?
I have a question about using SSCE with flash memory. Our CE components equally allocate the write access to the memory location. But write access is guaranteed only 10000 times per memory cell. So I need to know
1. what changes are made to the file system if I add an entry to a table? Is this entry the only information added to the file system? 2. What happens if I delete an entry? Will SSCE optimize the data in the filesystem?
Hi friends, i want to know something abt sql server installation and database properties as under.1) how much disk space reqd by multiuser sqlserver 2000 db to install ?2) is it possible to install sql 2K on Flash Drive ( gen connect at USB) ?3) When v create a database user Enterprise Manager , which files created by database ?4) If i Know datafiles name of a database e.g. pubs , and if v copied on cd and paste on other system which has sql 2K install , does those database works ?5) is it possible to create database on flash drive ? thanx in advance.
I am not sure if this is the right folder to post, but currently I'm considering using Flash as an interface, the application at www.mobik.com seems impressive, simple and sweet. But I'm wondering if I can build desktop application with flash and SQL2005 as backend for all the processing. at the same time, the flash shall be getting updates from a server. Possible?
I'm working on a project where the client wants us to create custom charts which have features not found in the standard Reporting Services charts. I would like to use flash to build this and have found an existing flash charting package for which I have the code and which I plan to expand.
Here's the problem:
The client wants to include these charts in his Reports. Is there some way to add a flash control to a report so that it will appear on the web page as a fully-functional flash presentation, which can then be included when printing or exporting?
The alternative, would be to figure out some means of generating the chart using flash outside of the report, exporting a bitmap of the chart and then saving the bitmap to a known location on the file system so It can be referenced by a report. This has some serious complications, and may not be feasible.
Hello friends, So, this is my senario... i'm using SQL 2005 reporting service which reports are shown to the client from my web-site... I've included a report viewer in my ASPX page through which i'm displaying the reports. I wanted to know if their is any way by which i can embed a flash file in my report.
Secondly, i have some reports in which I have used the matrix control. And to display the headings of the columns i've created individual text-boxes & have made them overlap on the top region of the matrix.thoe these text boxoes are getting rendered in proper places when i preview the reports during design time, but when they get rendered in my website all the heading text-boxes get scattered all 'round the report......has anyone faced such weired problems & is there any alternate way of do'in the same ??
Can someone please tell me if it is possible to insert a flash movie into MSSQL 2005 and if so what would be the most appropraite data type to use for this. Any links to tutorials on how to uplaod such fiules would be appreciated
Hi There, Can I store flash files in the database. I have a table with one of the columns as varbinary datatype. Previously, I was saving images (as filebytes) into this column. But now I need to implement something to store the flash file. So, is it possible to store flash files in the database and retrieve them and display them in an asp.net page? Thanks a lot for your suggestion!!
I have installed 2 SQL Server 2005 Express sample databases from 2 books, ASPnet 2.0 and ADOnet 2.0. The ASPNETDB.MDF was shown in App_Data and Database Explorer, but not in the SQL Server Management Studio Express. The AdoStepBy Step database created by a ConfigDB.exe was displayed in the Management Studio, but not in the App_Data, or Database Explorer.
Is this the way SQL Server 2005 runs the 2005 databases for SQL Server 2005 Express only? Or also in SQL Server 2005?
In SSMS, I connect Object Explorer to a partially contained database using a contained user login with password. This user has a database role of dbdatareader. When I try to expand the Tables in the database, I get the error:
The SELECT permission was denied on the object 'extended_properties', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)
Is there a way to set permissions for the contained user so that this could be done?
I have looked everywhere I can think of for the answer to this and am completely confused. My IT dept created an SQL database for me on a server. My plan is to create web pages in asp.net using Visual Web Dev Express released this week. I have connected to the database but I can't figure out how I am supposed to create my tables in the database. What simple/obvious thing am I missing here? I keep trying to download SQL Server Express in hopes that I can use that to manage my database but it keeps telling me that it won't install because I have previous Beta versions left on my machine. I can't find those either so am out of luck. I am new to this so perhaps I am asking all the wrong questions.Does anyone know what I can do to find a useful database management tool that will allow me to add/create the tables?Thanks for any help!
Hi, I need support for the following problem. It is a teamwork.Suppose 25 databse developer developing a databse.every one make modification (update,delete,insert)to the centralized database.I want that every one its on database copy and make modification to that instead to centerlized database.As source control softwares do(e.g visual source safe).or any other way to manage database in such senerio. Hope any one will help. Thanx in advance.
Hi to All, I am working in vb and C# .net as front hand and use mySql or Squel server as back-hand. task is, i did here it that, we have more than one table, each and every is related by using the concept of Primary and Foreign key management. in that database if i remove a record from master table, than the related record of all child talbes shall auto-matically reoved that is my question how it does happen. first thing that you have understood my problem if yes than please if you have any idea, mail me. i will very much thnks in advance to you. bye regards Rajat.
I just realized recently that a database "XYZ" in the Object Explorer of my SQL Server Management Studio Express (SSMSE) is put in the Database Explorer of my VB 2005 Express for processing a Stored Procedure in executing the SELECT statements (not by using Input and/or Output Parameters) during the ADO.NET 2.0-VB 2005 Express programming, then the content of the database "XYZ" is not in the SSMSE. How can I return the database "XYZ" from the DataBase Explorer of VB 2005 Express back to the Object Explorer of SQL Server Management Studio Express (SSMSE) safely? Please help and advise.
Hi I am using SQL server database with asp as front end. I use asp command object to call sql stored procedure. The procedure runs a while loop for say 100,000 records and based on the IF condition calls particular stored procs which process the record. I am running this app on a p4 IBM pc with win 2000 sever and IIS on same m/c . The cpu utilisation goes upto 98-99% and the process has started running very slow of late. Is this slow processing speed a hardware/OS problem or is it due to calls for stored proc within stored proc? how can i optimise the process. Each stored proc called does have if conditions,table scans etc.
Hi All, I installed sql server 2005 express edition beta 2. which come as part of visual studio 2005 beta 2. Please tell me which administration tool i have to use to manage my database.
I am not an SQL guru by any stretch but I am trying to understand the differance bewteen the size of the data contained in the tables and the physical size of the .MDF file.
Currently I have a website for a client with 27 megs of Physical data stored in the tables but a Data file size of 334 MB set a 3% autogrow. I have my Log capped at 5mb, but I can't seem to contain the Data file. My database just keeps growing and growing every 2-3 days with very little new data being inserted.
Why is there such an enourmous differance bewteen the size of data stored in the tables and the size of the data file and is there anything I can do to fix it?
I installed the SQL Express SP2 and it supports the sql mobile database. Is there any better free tool for sql mobile database management than sql server management studio express?
Doesnt support to create/export, import scripts, doesnt support editing existing fields (name)... (i used sqlite and it has a lot of free stuffs with and without gui to manage databases...)
i use VSC 2013 (C#, .net4.5, ADO) and i installed SQL Express 2014 on a PC Under W8.1pro. I succeeded to create and access a database with my application. My database is created with a code like:
using ( var connection = new System.Data.SqlClient.SqlConnection( "Data Source=(local); Integrated Security=true;User Instance=True;" ) ) { connection.Open(); using ( var command = connection.CreateCommand() ) { command.CommandText = String.Format( "CREATE DATABASE {0} ON PRIMARY (NAME={0}, FILENAME='{1}')", dataBaseName, dbFileName ); command.ExecuteNonQuery(); command.CommandText = String.Format( "EXEC sp_detach_db '{0}', 'true'", dataBaseName ); command.ExecuteNonQuery(); } }
My problem is to manage this database with "Microsoft SQL Server Management Studio"; i fact, i never succeeded to see my database in this tool. The .mdf file of my databae is located in a directory "C:UsersmyuseraccountDocumentsSQLServerExpDBs".
I tried to join my mdf file, but MSqlSMS refuse to display the content of all my user account directories.how to manage such DB in MSqlSMS?
All, I copy my reallistdb.mdf file to this MS SQL SERVER directory .Microsoft SQL ServerMSSQL.1MSSQLData eallistdb.mdf. When I open my ms sql management studio, I don't see my realistdb.mdf under object exploer. Could anyone help? Thanks
I'm working on an application which is mainly used to look up compressors and their data which are held in documents.
This is a simplified representation of the tables of importance:
Document -------- Id (int, identity) (PK) Number (nvarchar(50))
Compressor ---------- DocumentId (int) (PK, FK) Id (int, identity) (PK) Name (nvarchar(50))
CompressorData -------------- CompressorId (int) (PK, FK)) Id (int, identity) (PK) Value (nvarchar(50))
The tables are linked as follows: Document -> Compressor -> CompressorData
Non clustered indexes are created on Document.Number and Compresor.Name because these fields are used for querying.
At certain points corrections will be released on compressors which will result in: - Creating new documents with new document numbers (note that a non clusterd index exists on Document.Number). - Copying affected compressors of existing documents into the new documents (note that a non clusterd index exists on Compressor.Name). - Copying the data of the affected compressors into the new documents.
This can result in creating ten's of new documents and copying hundreds compressors and thousands compressor data records.
My question:
Will the users still be able to query for compressors while corrections are released (thinking about indexes which need to be modified) or will their be so many locks held that the database becomes unusable?
Having problems with SQL 2005 Database management plans!!!!
I can't seem to delete any old logs that I don't need.
I have put together a Maintenance Cleaning Task on the back of my backup plan but I can't get the log files to delete even though I have set "delete files older than the following" to my requirements.
I need advice on my design. I'm developing a system that track the catalog distribution.
I have a 5 table. Company Table - Store list of company. Each company can have many staff.
Staff Table - Store list of staff.
Catalogs Table - Store list of catalog. Each catalog can have many revision. PKEY id name latest
CatalogsRev Table - Store list of catalog revision. PKEY catalogID -> Catalogs.id PKEY year
Staff_Catalog Table - Each staff can have many catalog revision. PKEY staffID -> Staff.id PKEY catalogID -> CatalogsRev.catalogID PKEY year -> CatalogsRev.year
Is the above table good enough to track which company do not have latest catalog revision?
For the Catalogs Table should I use a trigger to update the Catalogs.latest column everytime a new CatalogsRev is entered? I've read some article on the web says trigger is slow, but in my situation is it suitable to use trigger?
I use visual studio express 2005, and just downloaded Management Studio Express. (I have SQL Express). I've already created my projects and created database tables and everything but I do not know how to connect an existing database to management studio. Can someone tell me how to connect an existing database to management studio? Thanks, Computergirl
Hi I am using ASP.Net user management tool. How can I get the user name of the current user who does some activity to log those details using triggers.Any web link/tool/suggestion is welcomed.
Hi, I have installed an ASP.NET 2.0 application which uses a SQL Server Express database file on a client's network. I am able to connect to my client's network remotely over the internet. I would like to know if there's a way - and if so, how - to manage the Database file remotely. I have VWD Express, SQL Server Manager Studio Express and a trial version of SQL Server 2005 on my development machine. Thanks very much. Regards Gary
