Hi. We have an MQT for a query joining a 100-rows table and a 10Million-rows table. 3rd-party software often issues update statements for the the 100-rows table, but it actually doesn’t change data. However, a single row update causes partial Continue reading Prevent automatic MQT refresh, if column val didn't actually change
Hi, I have installed db2 express c on redhat linux.I can able to start the database & I can able to do all the operations on db2.Now I m trying to connect to through IBM data studio , I m Continue reading Sql error: 4499, SQLSTATE=08001
Due to a merger, we now have a MySQL database and need to update it from MS SSIS. I have tried the latest version for ADO.NET driver and the ODBC Driver and neither has worked for row insertion. For the Continue reading Updating MySQL Database from SSIS
Hello, I did some performance tunning to a Stored Procedure but it is still running too slow. Then what I did is to run in parallel the same stored procedure. With 2 instance the time pass from 20 minutes to Continue reading performance with a stored procedure
Hello, it’s my first time here, i need your help if you can 🙂 So we have:(1) one physical server : OS : Windows Server 2003 Active Directory, DNS, DHCP, File Server, Print Server and SQL Server 2005 and we Continue reading Migration SQL Server from Physical Host to VM
I converted a string value to int CAST(TestSth3.Emp_Code AS int) it returns 1,234 but i need 1234 i am using vb.net 2008. Thanks
Hello, Sometimes MySQL freezes and I end up deleting wb_options to reopen the application. I was wandering if there was another way to stop MySQL from freezing, or even better, a more permanent solution? Thank you for your time!
Hi, below is the sql query. I get the below error while I try to refresh the database. Invalid character found in a character string aurgument of the function “Integer” SQL Query: with rdate as( select ‘2015-06-24′ dt from sysibm.sysdummy1), Continue reading Invalid character found in a character string aurgument of the function "Integer"
Pat good ole buddy! The system query that generates queries for all the databases, do you think we could set that into SQL server agent to update/insert into one table and or seperate tables? If so I would build a Continue reading System Queries version 3
Hi People, I am new to Sybase but I have extensive experience in SQL Server and DB2. I want to find the location and time of the the database backup/dump file information. How can I do that in Sybase?