Home » Database

Category Archives: Database

Cumulative Update #2 for SQL Server 2016 SP1

The 2nd cumulative update release for SQL Server 2016 SP1 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing model, please visit: CU#2 KB Article: https://support.microsoft.com/en-us/help/4013106 Understanding Incremental Servicing Model for SQL Server Microsoft® SQL Server® 2016 SP1 Latest Cumulative Update: https://www.microsoft.com/en-us/download/details.aspx?id=54613 … Continue reading

Always on\Database Mirroring Automatic Page Repair

A special thanks to Daniel Jones [daniel.jones.0543@gmail.com] for showing up interest and writing informative article for our blog (http://mssqlfun.com/).   Always on\Database Mirroring Automatic Page Repair One of the most useful as well as hottest feature in SQL Server is mirroring of database. It is helpful for numerous of organizations that implements the successful as … Continue reading

Cumulative Update #11 for SQL Server 2014 SP1

The 11th cumulative update release for SQL Server 2014 SP1 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. Please visit: CU#11 KB Article: https://support.microsoft.com/en-us/help/4010392/cumulative-update-11-for-sql-server-2014-sp1 Understanding Incremental Servicing Model for SQL Server Microsoft® SQL Server® 2014 SP1 Latest Cumulative Update: https://www.microsoft.com/en-us/download/details.aspx?id=51186 Update Center for Microsoft SQL Server: http://technet.microsoft.com/en-US/sqlserver/ff803383.aspx (Source … Continue reading

How Row versioning impact tempDB ?

Scenario: DBA found that tempdDBdatabase usage is getting high and most of the size is consumed by row versioning. DBA raised the issue with application team running that query. Once Application team close the session, tempDB usage comes normal. Question: Application tea raise concern “How can a select statement on table consume huge amount of … Continue reading

Error while loading Excel data into database

Issue: I am trying to load data from Excel 97 – 2003 sheet into a database table. I have written a simple SSIS package to do that, but unfortunately, it fails with error: –   Microsoft (R) SQL Server Execute Package Utility  Version 11.0.6020.0 for 64-bit  Copyright (C) Microsoft Corporation. All rights reserved.    Started:  2:02:37 … Continue reading

%d bloggers like this: