Question : Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the […]
DbaFix
Copy of a database with an existing database with schema and data in sql server
Question : I have two databases one is having master kind of tables and other will have transaction data. I […]
Query across multiple schemas, unknown until execution time
Question : I have multiple schemas that I need to query across. The schemas are not known in advance, for […]
Setting up binary replication between two PostgreSQL instances
Question : I have two virtual machines: dbrepa (-.175) and dbrepb (-.191). Both have PostgreSQL 9.2 installed; once PG was […]
Inserting data into multiple tables
Question : For my system, students are required to create a user account by completing a registration form (personal, contact […]
sp_setapprole and creating users / logins
Question : We have set up SQL Server and our Application in such a way that an SQL Server login […]
Postgresql 9.6 db connection our Oracle 11.2.0.4. db
Question : I am trying to do a connection between tables/fields between our Postgresql database and an Oracle database. When […]
Have full SQL Server restore but losing 1 day of data
Question : I have SQL 2008 R2 64bit and it is backed up with ASIGRA SQL backup. The issue I […]
When is it appropriate database design to use a separate schema?
Question : I am developing a database which has data sourced from many different applications. In my first pass at […]
Can you have a WHERE clause with a greater than operator on a composite key?
Question : I’m a web developer (not DB admin!) having performance problems processing a 1.7m record table on MySQL. Here […]