Tagged Questions
1
vote
4answers
139 views
At least one database view per database table-Is this good or bad design and why?
We are building a Windows Mobile based application to interface with a customer's existing web application. We are reading and writing data to the customer's SQL server 2008 database.
The customer ...
2
votes
3answers
109 views
Designing a large database with multiple sources
I have been tasked with redesigning, or at worst optimising the structure of a database for a data warehouse.
Currently, the database has 4 other source databases (which is due to expand to X ...
4
votes
4answers
144 views
Putting audit functionality into the database
Our database does not have any audit functionality.
It does not records who inserts the record or who who changes it
It does not keep a history of the changes made
Nothing can be restored if ...
5
votes
5answers
237 views
Anti Identity Column
I recently came across some code which generates an identity value for a key:
DECLARE @ID INT;
SELECT @ID = MAX(ID) + 1 FROM Person;
INSERT INTO [Person]
([ID], [FirstName], [LastName])
VALUES
...
2
votes
3answers
148 views
How to query a very long list of properties fast
I have a structure for storing item properties on SQL Server:
ItemId PropertyId Value
1 1 a
1 2 b
2 1 a
2 2 5
Currently there are over 130000 ...
