All Questions
Tagged with sql-server oracle
6 questions
1
vote
1
answer
272
views
Strategies for managing legacy data for a medium sized enterprise
I work for a mid market manufacturing company with around 1700 internal employees and about 7000 external users (employees of our customers). We grew through acquisition which means we have many ...
- 190
10
votes
1
answer
3k
views
Partial name matching in millions of records
We have developed a web based application for name matching. It operates by breaking names into parts and the Soundex value of each part is stored in a database. The Levenshtein distance metric is ...
- 229
18
votes
7
answers
12k
views
500 databases or 1 database with 500 tables or just 1 table with all the records? [duplicate]
I currently have an application that is used by a single end customer. For ease of discussion assume the application only needs a single database table for all records. I now need to support multi-...
- 409
0
votes
1
answer
8k
views
Oracle Database Integration with Team Foundation Server?
So my company is using TFS and SQL to Manage their Database (MS SQL Server). It integrates with the nightly build servers to do builds and produce scripts to build the entire Database. Also the ...
user6791
3
votes
4
answers
275
views
.NET app - Should we use SQL Server and duplicate some reference data from an external Oracle DB? Or use Oracle and have a DB link?
We're looking to migrate some existing Excel/Access processes into a new system which will provide the users with a Silverlight frontend to run and view the reports instead of using MS Access. The ...
- 39
173
votes
21
answers
163k
views
Stored Procedures a bad practice at one of worlds largest IT software consulting firms?
I'm working at a project in one of the world's top 3 IT consulting firms, and was told by a DBA that company best practice's state stored procedures are not a "best practice". This is so contrary to ...