Question : I have a DB2 database with a table for daily transactions, which is cleared to a history table […]
INSERT/UPDATE in same query from previous SELECT with some singularities
Question : I’m trying to perform a INSERT|UPDATE by selecting data from another DB and this is what I have […]
GETDATE() uniqueness when used on INSERT
Question : Recently I was reading this blog post: http://blogs.msdn.com/b/sqlazure/archive/2010/05/05/10007304.aspx which contains this section: Picking a Clustered Index There are […]
What data is duplicated when MySQL/MariaDB BLOB columns are copied?
Question : Let table_1 be created as follows: CREATE TABLE table_1 ( id INT AUTO_INCREMENT PRIMARY KEY, some_blob BLOB ); […]
Insert into a DB that was selected via other DB?
Question : I have a table that stores what database should I use for a given device( specified by its […]
Sudden performance decrease in SQL Server
Question : I’ve got a problem with a SQL Server 2008 R2 instance. Last week the performance suddenly broke down. […]
Deny insert/delete for all users in SQL Server 2005
Question : In our database we have about 20 users, that is used be some program (and users are added […]
not exists’ seems to be slowing insert
Question : I am trying to run a script that will batch insert over 20 million records into a table […]
Which DB design should scale better?
Question : I’m sorry for the vague question description, but I’m honestly a noob in DB design, as I’ve only […]
MYSQL Error 1064 on INSERT INTO with CTE [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]