by XTIVIA | Mar 30, 2017 | Blog, SQL Server
Replicating Indexed Views as tables, instead of replicating all base tables and then creating an indexed view against those base tables, allows for a smaller subset of data to be replicated over. If you replicate base tables and then create an indexed view,...
by XTIVIA | Mar 14, 2017 | Blog, SQL Server
SQL Server Statistics are small, lightweight objects that describe the distribution of data in a SQL Server table or column. The SQL Server query optimizer uses statistics to estimate how many rows will be returned by parts of your query. This heavily influences the...
by XTIVIA | Mar 9, 2017 | Blog, SQL Server
Have you ever run into an SSPI error in SQL Server Management Studio (SSMS)? In this blog entry, we will show you 2 ways you can fix your SSPI error in SQL Server. SSPI Error: Cannot connect. The target principal name is incorrect. Cannot generate SSPI context Details...
by Kathleen Long | Feb 7, 2017 | Blog, SQL Server
XTIVIA is highlighting new features in SQL Server 2016! We can set you up with all the exciting new features available in SQL Server 2016. Here’s how implementing new features will benefit your SQL Server environment. Stretch Database Stretch Database allows you...
by Kathleen Long | Dec 16, 2016 | Blog, SQL Server
A common question asked from super users of applications is, “What is the difference between Windows Authentication and SQL Server Authentication?” While there are many details under the covers of SQL Server and Windows Authentication, the differences can...
by Kathleen Long | Nov 30, 2016 | Blog, SQL Server
Sometimes, the time it takes and the size of the snapshot is too large for easily configuring transactional replication. To deal with this situation, SQL Server offers the ability to initialize the subscriber from the backup of the database at the publisher. Using a...
