I have a few years experience developing with oracle and have now moved to a place where they use SQL server (2005). Where would be a good place to learn things like SQL Server query optimisation, basic dba stuff and sql server gotchas for someone with my background. Thanks! ...
Hello all, I feel that this is likely a common problem, but from my google searching I can't find a solution quite as specific to my problem. I have a list of Organizations (table) in my database and I need to be able to run queries based on their hierarchy. For example, if you query the highest Organization, I would want to return th...
My database has a parent table with an auto-incrementing primary key identity 'ID', and a normal 'TIMESTAMP column'. I have child tables with a foreign key that refer to the parent 'ID' column. I want to write a stored procedure that inserts a new column into both the parent and child databases. How would I set the child 'ID' column to...
It would seem these days that everyone just goes with MySQL because that's just what everyone goes with. I'm working on a web application that will be handling a large quantity of incoming data and am wondering if I should "just go with MySQL" or if I should take a look at other open-source databases or even commercial databases? Thanks...
Should I always have a primary key in my database tables? Let's take the SO tagging. You can see the tag in any revision, its likely to be in a tag_rev table with the postID and revision number. Would I need a PK for that? Also since it is in a rev table and not currently use the tags should be a blob of tagIDs instead of multiple entr...
I am making an application that simulates an ATM (its totally trivial). I was having a little trouble saving my transactions to the hard disk. The two main questions are: A) Should I save it as a DB or a text-file, B) How would I save to disk using either DB or txt format in STL C++ (I don't really want to use a third-party library but I...
Hello, I have a stored procedure that makes very complex joins and returns 1 row of data (LIMIT 1 is used). In my application I then use that data to make some calculations. This way I try to keep business logic out of stored procedures. But now I need to get that data in another stored function to also make some calculations. The reaso...
Hello, I have a database that I have created using SQL Server Developer 2008. I want to script it to a file so that it can be recreated by anyone at any time. Any Ideas? ...
I am trying to join two tables; the purpose being able to search and display event information for an artist that is entered by the user. The tables are as follows: artist table: [id],[name] events table: [id],[artist_id],[venue_name],[city],[state],[date],[time] I created a search engine, but what I want to do is when an artist name...
Hi, We have an Android app and a Web Service. We want to download part of the places objects to the mobile. The user will be able to download more of a certain city. Because of that we need to save the city_id of the web in the mobile database. We've thought on two options: Each database will have it own primary IDs, but we will save ...
The following code continues to be displayed even if there are entries in my database and I don't understand why. Am I missing something? I'm not sure if this makes sense, but help would be great. :) if($numrows==0) { echo"<h3>Results</h3>"; echo"<p>Sorry, your search: "".$escaped."" returned zero results</p>"; } ...
In SQL Server, what are Instead Of triggers? ...
Some of the people in my project seem to think that using a common development database with everyone connecting to it is the best thing. I think that it isn't and each developer having his own database (with periodic updated data dumps) is the best. Am I right or wrong ? Have you encountered any problems in any of these approaches? ...
Is there a standard/convention for how the columns should be ordered in the definition of a database table, and if so what is the motivation for that standard? (pros/cons) For example, should the primary key be the first column? Should the foreign keys directly follow the primary key or should they be placed at the far right of the tabl...
Hi, is there someone out there who can help me select multiple records that were entered/updated on different tables on the same time in the SQL Server database. Do you think this is possible or not? Your help is highly appreciated, thanks! ...
I have a database which is 6GB in size, with a multitude of tables however smaller queries seem to have the most problems, and want to know what can be done to optimise them for example there is a Stock, Items and Order Table. The Stock table is the items in stock this has around 100,000 records within with 25 fields storing ProductCode,...
Hi I am stuck while making a programming decision, I am a .Net developer, I am currently building an application for my client that receives data from a third party application, it has to then perform operations on the values and send it to a webservice/servlet which then displays data to a webpage, The catch here is that the data bein...
I have a legacy schema that cannot be changed. I am using a base class for the common features and it contains an embedded object. There is a field that is normally mapped in the embedded object that needs to be in the persistence id for only one (of many) subclasses. I have made a new id class that includes it but then I get the error t...
This is a really strange one. I am using SQL Server Express 2005, and have the following connection string (in a DotNetNuke web.config): Data Source=ELECTROMORPH\S15304561;Integrated Security=True;User Instance=True Note that there is no AttachDbFilename parameter - so I'm not sure how SQL server even knows what to connect to. But it...
To get more into django programming I'm planning to create a google maps mashup, which finds routes from A to B, but avoids streets/junctions that cross public surveillance cameras' perspectives. Therfore I will create a database (probably Postgres based, because of its GIS capabilities) containing surveillance type (surveillance camer...