Tag Archives: Sql Server 2014 new features

SSIS Error and resolution: 0x80004005, Invalid character value for cast specification

In one of the SSIS packages while reads data from FlatFile and pushes into SQL, I received a strange error Invalid character value for cast specification. The solution is tricky, I had to change RetainNulls Property to True at FlatFile … Continue reading

Posted in SQL Error, SQL Server, SSIS | Tagged , , , , , | Leave a comment

Buffer Pool Extension – New feature in SQL Server 2014

Before diving into Buffer Pool Extension (BPE) details, it is worth taking a look at the Buffer Management to refresh your knowledge. You may find buffer management details @ http://technet.microsoft.com/en-us/library/aa337525(v=sql.105).aspx Buffer Pool Extension (BPE) can use nonvolatile storage devices (Ex: … Continue reading

Posted in SQL, SQL Query, sql2014 | Tagged , , , | Leave a comment

Incremental statistics – New feature in SQL Server 2014

Incremental Statistics is one of the new feature added in SQL Server 2014, let us have a quick look to understand this feature! Statistics is one of the important criteria to be validated during performance analysis as improper statistics directly … Continue reading

Posted in SQL, SQL Query, sql2014 | Tagged , , | Leave a comment