Skip to content

SQL Server Repository

This site is repository of my Sql Server Learnings.

Category: columnstore

Floating Point Exception – When Accessing Columnstore indexes in SQL 2016 RTM

When working with Columnstore indexes in SQL 2016 RTM, you can get the below database exception error:SQL2016CU1

Microsoft addressed the issue in this KB article 3171759 (SQL 2016 CU1).

Refer: https://support.microsoft.com/en-au/kb/3171759

SQLWhisperer columnstore, SQL 2016 August 4, 2016 1 Minute

Recent Posts

  • Truncate a large table in Availability Group
  • Master database in single user mode after restore
  • Custom SQL Job Failure Notifications
  • Registering SPN for SQL Server Service Accounts
  • Query to search for a particular value in database

Recent Comments

Powershell script to… on SQL Query to Find SQL Cluster…
best website solutio… on PowerShell – Script to g…
Report file sizes in… on Report Time in proper for…
Display time HH:MM:S… on Report file sizes in proper…

Archives

  • April 2021
  • March 2020
  • February 2020
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • August 2016
  • July 2016
  • June 2016
  • January 2016
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • July 2014
  • June 2014
  • April 2014
  • March 2014
  • February 2014
  • January 2014
  • December 2013
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • April 2013
  • March 2013

Categories

  • "Dig" The Server
  • Backup
  • columnstore
  • DAC
  • Data Compression
  • Database Files
  • DBCC
  • General
  • Health Check Scripts
  • Index
  • InMemory
  • Log Shipping
  • Native Compiled Stored Procedure
  • Performance tuning
  • Powershell
  • Replication
  • Restore
  • Security
  • SQL 2014
  • SQL 2016
  • SQL Server Agent
  • SSIS
  • TempDB
  • Trace Flags
  • TSQL
  • Uncategorized
  • XML

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com
Blog at WordPress.com.
  • Follow Following
    • SQL Server Repository
    • Already have a WordPress.com account? Log in now.
    • SQL Server Repository
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...