I created a widget that users of my site will embed on their web sites. I want to track the amount of times a widget renders as well as the referring URL. The widget was written in flex and my back end is Rails. One obvious way to do this would be to have my widget make a service call to the back end to register a hit. However, when ...
In MySQL you can use the syntax DELETE t1,t2 FROM table1 AS t1 INNER JOIN table2 t2 ... INNER JOIN table3 t3 ... How do I do the same thing in SQL Server? ...
I'm working on a project with couple others. We all have local copies of the project, which is also constantly updated via svn repo. Because we are in the early stage of the development, we often change the schema of our database. This leads to a lot of problem when we sync our code, because we don't have a great way to synchronize our...
I have a web application project that works with quite large database (over 5GB). Data in the database is partitioned by project. Each project takes approximately 1GB, and it is a minimal set for application to work (we do some math calculations that spread across this dataset and removing a part of the dataset is not an option). As a ...
Hi, I'm using Visual C#2008 Express Edition and an Express SQL database. Every time I build my solution, I get an error like the one above. Obviously the file name changes. A new file is also created every time I hit a debug point. I have a stored proc that gets every row from a database table, it gets these rows every time the main for...
I know that sqlite doesn't perform well with extremely large database files even when they are supported (there used to be a comment on the sqlite website stating that if you need file sizes above 1GB you may want to consider using an enterprise rdbms. Can't find it anymore, might be related to an older version of sqlite). However, for ...
If I were designing a oil refinery, I wouldn't expect that materials from different vendors would not comply with published standards in subtle yet important ways. Pipework, valves and other components from one supplier would come with flanges and wall thicknesses to ANSI standards, as would the same parts from any other supplier. Inte...
I'm copying an SQL Server 2005 database from one server to another, with the Database>Tasks>Copy Database wizard, and it works great, except for the timestamp column whose values are not copied. Is there a way to have the timestamp values be preserved on database copy? ...
I'm working on an ASP.NET project that replaces many existing paper forms. One of the requirements is that the user can save the form in any state, i.e. they could create a new blank form and immediately save it with no data or with partial data. I'm validating for data type on every save but validation for required fields does not occur...
I have asked a similar question before and while the answers I got were spectacular I might need to clearify. Just like This question I want to return N number of rows depending on a value in a column. My example will be I have a blog where I want to show my posts along with a preview of the comments. The last three comments to be exa...
I have a class (in C++), call it Data, that has thousands of instances (objects) when the code is run. I have a widget (in Qt), call it DataWidget that displays attributes of the objects. To rapidly build the widget I simply wrote the object attributes to a file and had the widget parse the file for the attributes - this approach works, ...
I'm looking for an ORM that will allow me to write a C# user interface and a C++ service. Both need to access data from the same database. Ideally I want C# and C++ classes to be generated from the database schema that I can then program against. The database will probably be SQLServer, but that hasn't been decided yet. Note: I'm doing...
Managing server logins and database users between developers workstations and other deployment environments using Visual Studio Team System Database Edition Hello people, Looking at upgarding from 'Visual Studio Team System 2008 Database Edition' to Visual Studio Team System 2008 Database Edition GDR R2. Parametrisation in vstsdb is ...
Hello! I'm writing unit-tests for an app that uses a database, and I'd like to be able to run the app against some sample/test data - but I'm not sure of the best way to setup the initial test data for the tests. What I'm looking for is a means to run the code-under-test against the same database (or schematically identical) that I cur...
Update 2009.04.24 The main point of my question is not developer confusion and what to do about it. The point is to understand when delimited values are the right solution. I've seen delimited data used in commercial product databases (Ektron lol). SQL Server even has an XML datatype, so that could be used for the same purpose as del...
I recently got database for my website and was suprised to see how expensive it was for the amount of space they gave me (only 500 mb for sql2005). The database is used to store data such as posts or articles submitted by members. the problem: I would like to be able to save not only the final version of a user post, but also all possi...
I'm trying to update all records in one table with the values found in another table. I've tried many versions of the same basic query and always get the same error message: Operation must use an updateable query. Any thoughts on why this query won't work in Access DB? UPDATE inventoryDetails as idet SET idet.itemDesc = ( ...
I have a constant data flux. All data must be stored into the database with a timestamp. The data comes in a 5 minutes interval, and a select of the latest data is made in the same interval, in pseudo SQL code: SELECT * FROM TB_TABLE WHERE TIMESTAMP = MAX(TIMESTAMP) As this table grows really big (gigabytes), I did a premature optimiz...
Environment: SQL Server 2005 SP2 (9.0.3077) Transactional Publications (Production and Beta) I have a situation where I have two different Replication Publications setup that use some of the same Articles. Each of these Publications feeds a subscriber on a different machine. One of these shared Articles is a table. At a regular time ...
I'm currently learning C# and .NET (coming from a UNIX background), and have just started writing a media player. I was hoping for some suggestions on the best way to store the internal database of songs. SQL? Some kind of text file? I don't really have any experience in this area so all points will be really appreciated. Cheers! ...