I need to get results where the column contains a string that includes [ ]. When I use LIKE, it takes the [] as a wildcard sequence, and doesn't work as I need.
For example, I want to search through ...

I want to know if there is a way to create unique keys (not PKs) in SQL Power Architect using forward engineering.
I've searched google, saw the tutorials by the software vendor, and checked out in ...

I have a very old Oracle 7.x database that I need to open or convert to a new Oracle 11g.
Here's the content of the old database:
control01.ctl
control02.ctl
control03.ctl
findata01.ora
finind01.ora
...

I'm writing Windows Service in C# and inside of it I'm unable to connect to the database.
This is the question I've asked recently:
SqlException: Cannot open database "path\db.mdf" requested by the ...

using other words:
does the one-write-lock-per-database policy (it's not a "bug" but a "feature" by design) affect contention making its usage in certain kind of workloads less then optimal?
if not ...

Scenario
I am developing a full-text search over a products table.
The full-text indexed field of th table contains a brief description of the product, the name of the category and the product code.
...

There are similar questions on this site, but they mostly cover server failure and data backup aspects.
I'm concerned only as far as query performance. If master and slave share the same resources, ...

I'm building a backend system using MongoDB. Now I want to restrict access on certain numbers of database collections to this system. For example I have users, admin_users, pageviews and I want this ...

I want to know what is there a way for storing equations or formula in a DB column.
Below is the table where I am storing the machines details(master table). But the last column is what I am worrying. ...

Suppose I have an SQL Server 2008 which is installed on windows 2008. There is a db MyDb under the instance. MyDb is have full backup every night. Because of storage space on hard driver, only 7 days ...

Everywhere I search for SQL Server 2012 Express with Advanced Services, I ended up with this link, http://www.microsoft.com/en-us/download/details.aspx?id=35579, and every time I install it, I do not ...

Due to an unforeseen hardware error, I had to take our secondary replicas down for maintenance. This was really due to a storage issue and, it was decided at a higher level, to purchase a new storage ...

I am building a SQL query in Oracle 10g that needs to sum overtime hours for the base table, but needs fields from the parent tables as well. I am looking for the fastest way to build the query. The ...

We are planning to package MongoDB-PostgreSQL hybrid solution in our application that will be deployed on customer site on-premise. It will be packaged as a software virtual appliance.
Our reason for ...

A MySQL v5.1.61 relay got corrupted when the machine suddenly shut down. I tried to fix it but it didn't work.
— How do I fix it? Did I do something wrong?
As far as I've read, corrupted MySQL relay ...

In SSIS, we can use the OLE DB Source SQL command to run a T-SQL script on the database and then use the output as the source. For example the a complex query can be wrapped in the OLD DB source SQL ...

Just need a little help here about replication. I have an intermediate knowledge in Mysql. And I can't find any simple solutions on web how to establish a database replication in Mysql. All I need to ...

I am curious as to whether the performance of postgres depends on the amount of RAM available. i.e. will postgres performance(during reads) on several runs get affected by the amount of RAM that is ...

I have 4 python scripts each running in their own virtual machine. The scripts are accessing a central postgresql database. All scripts are reading from the same table but posting to different tables ...