Tagged Questions
9
votes
9answers
3k views
Foreign key restrictions -> yes or no?
I would like to hear some”real life experience” suggestions if foreign key restrictions are good or bad thing to enforce in DB.
I would kindly ask students/beginners to refrain from jumping and ...
6
votes
3answers
2k views
Are there any special advantages of SQL Server with Visual Studio?
I have seen the forum dba.StackExchange, but this question involves Visual Studio as well, therefore I wanted to post this question here.
One of my old application was built on VS-2008 and MySQL ...
3
votes
2answers
115 views
Handling changes to data types and entries in a database migration
I'm fully redesigning a site that indexes a number of articles with basic search functionality. The previous site was written about a decade ago, and I'm salvaging about 30,000 entries with data ...
2
votes
1answer
255 views
How to swap out a DB from MySQL to SQL Server in a multiple large projects?
Is there a sane way / best practices way to swap out a DB from MySQL to SQL Server in a multiple large projects? Some of the projects are ASP projects, some of them are windows services, some are ...
2
votes
6answers
1k views
what is the benefit of using key/value stores with respect to database sharding?
What has key/value stores got to do with making database sharding easier?
Because if I do not use a key/value store, I can easily shard my database too right?
(Like say, I can easily say users with ...
1
vote
2answers
490 views
what is storing data in constant space?
"bloom filter allows us to store data in constant space"
Can someone explain what exactly does that sentence means?
0
votes
1answer
135 views
How should I evaluate the Database Solution for Large Data Application
Background
I have been tasked to write an application that will be a combination of document and inventory management in VB.net which will be used to store document images in TIFF, PDF, XPS, TXT, DOC, ...
0
votes
1answer
343 views
Are there any SQL servers that support compiled queries?
Can SQL queries be compiled into byte code or equivalent to enhance performance?
I know that most database servers support prepared statements, but is that the same thing as compiling? Most ...
0
votes
2answers
169 views
How should I handle using two databases with a legacy PHP application?
I have a legacy PHP application that was written in 2004 and uses MSSQL as a database backend.
At this stage MSSQL is still supported by PHP but only just via a Microsoft driver. I have looked at ...
