Tagged Questions
0
votes
0answers
42 views
Moving sql database [closed]
I need to move the sql database to a new server without changing the app that uses that database, how can i do this easily without affecting the users ?
2
votes
1answer
144 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 ...
5
votes
3answers
1k 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 ...
1
vote
2answers
329 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?
2
votes
6answers
937 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 ...
6
votes
9answers
2k 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 ...
