by XTIVIA | Feb 13, 2020 | Blog, Database
Data is the lifeblood of your business, which means taking care of it is essential for operating your business. Whether your company uses SQL Server, Oracle, Db2, or PostgreSQL, quality database support, maintenance, and protection must be an integral part of your...
by Marc Petros and Rebecca Mitchell | Jan 2, 2020 | Blog, Db2, SQL Server
THE PROBLEM While working with a client on a data migration from Microsoft SQL Server 2014 to IBM Db2 11.1, the client reported that the application was displaying the following error when attempting to read records from tables containing LOBs that we had just loaded....
by XTIVIA | Oct 24, 2019 | Blog, SQL Server
There may be a situation where you want to remove a node out of an Availability Group (AG) may be due to testing, something wrong with the server and need to build a new one, running out of space on that server so you can move files around, move the server to a...
by XTIVIA | Aug 29, 2019 | Blog, SQL Server
One of the most common missed configuration settings in SQL Server is the cost threshold for parallelism. By default it is set to 5, meaning that when SQL estimates that the cost of a query will be greater than 5 running a serial plan, SQL will split the plan into...
