by Tori Aubé | Dec 5, 2017 | Blog, SQL Server
What are Statistics? Statistics are exactly what the name implies. They are statistical information about the distribution and/or correlation of data in the first specified column of indexes or tables in the form of a histogram. Histograms measure the frequency of...
by XTIVIA | Aug 10, 2017 | Blog, SQL Server
There may be a time where you install security patch MS15-058, and it shows that it was successfully installed, but the version does not change in SQL. The patch actually failed to install. Follow these instructions get to MS15-058 installed successfully and have the...
by Kathleen Long | Aug 2, 2017 | Blog, SQL Server
This is a high-level description of the different High Availability Offerings in SQL Server 2016, meant to give a general idea of what is offered and the limitations for each offering. AlwaysOn High Availability Groups When most people use the terms AlwaysOn they are...
by XTIVIA | Aug 1, 2017 | Blog, SQL Server
While there are many configuration options in SQL Server that can help tweak the performance when RAM or CPU is causing a slowdown, when the disk is the culprit, your options are much more limited. Assuming that best practices are followed in regards to file locations...
by XTIVIA | May 16, 2017 | Blog, SQL Server
SQL Error 18456 is likely the most common error one will encounter using SQL Server. Error 18546 isn’t only commonplace, but also ambiguous. Generally, Error: 18456 is a result of a login failure. Follow the steps below to try and resolve the issue. Are you connecting...
by XTIVIA | May 11, 2017 | Blog, SQL Server
Obtain the Oracle client binaries from Oracles site http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-2297732.html Click on “Accept License Agreement” For 32 bit: Look for “Oracle Database Client...
