Question : For example, I have a table for user registration: CREATE TABLE IF NOT EXISTS test_user ( user_id int(10) […]
DbaFix
Identity seed increased when using IDENTITY_INSERT
Question : Running this snippet on SQL Server 2008 produces different result than on SQL Server 2014. I need them […]
Log to record activity against a database
Question : I’ve been assigned to create a general log. I need a log that captures what actions were taken, […]
Aborted connection on an Update statement only
Question : I have node-mysql client that gets “ER_NO_SUCH_USER” whenever it does an UPDATE query. All other type of query […]
Why Oracle doesn’t have nolock?
Question : In MS SQL Server nolock can be used for the purpose. Why can’t we use it in Oracle […]
Setting up Master – Slave replication: error connecting to master (Error_code: 2003)
Question : I’m configuring this across two different servers on two different hosting companies. Here is the tutorial I’ve followed […]
Two-way replication between SQL Server 2008 R2 and SQL Server 2008 R2 SP3
Question : I know that in SQL Server you can’t have two-way replication between different versions. I wanted to know […]
Database inserts/updates slow only in Production
Question : We have a int/test/staging/production Mysql database setup. A Java application(using Hibernate) that periodically generates up to 200,000 updates/inserts […]
What would be a good name for a job schedule?
Question : I have encountered many different names for job schedules in SQL Server, ranging from the job name where […]
Application service down due to SQL Server error
Question : I’m using SQL Server 2012 where in I found an error in my SQL Server error logs which […]