Upcoming End of Day support for Microsoft SQL Server Products


Download latest and up-to-date list of SQL Server versions and its support dates. Click here to download (CSV file)

It is always important to know what versions of SQL Server running in our environment to keep the business healthy and  to avoid unintended issues such as security risks, system failure, performance issues and etc.  Keeping the server up-to-date will give the best solution to business for complex customer problems.

This is the list of the end of mainstream support for SQL Server 2008 and SQL Server 2008 R2

pic1

So, go check the system and update or upgrade the old versions.

Thanks for reading.

SQL Server 2008 R2 SP2 CU #13 – Final Update


Cumulative Update (CU) #13 has been released for SQL Server 2008 R2 SP2. It is the final update for this version because the mainstream support ends on July 8, 2014.

Following are the fix for the BI services in CU #13

Analysis Services

  1. FIX: Memory leak occurs during Process Update on a dimension in SSAS 2008 R2
  2. FIX: Incorrect result and exception occur when you use MDX query to do session cube grouping in SSAS 2008 R2

Full list of CU downloads for SQL Server 2008 R2 SP2

CU#13 KB Article
CU#12 KB Article
CU#11 KB Article
CU#10 KB Article
CU#9 KB Article
CU#8 KB Article
CU#7 KB Article
CU#6 KB Article
CU#5 KB Article
CU#4 KB Article
CU#3 KB Article
CU#2 KB Article
CU#1 KB Article

Categories: Hotfix Tags: ,

Hotfixes for SQL Server 2014 RTM – Cumulative Update 2


Microsoft released Cumulative Update 2 for SQL Server 2014 RTM. This blog post contains hot-fix details for BI (SSIS, DQS, SSAS, SSRS), In-Memeory OLTP, SQL Server Performance topics.

Integration Services

  1. FIX: The execution of SSIS package takes a long time when you cannot enable garbage collector server mode in SSIS 2012 or SSIS 2014
  2. FIX: Errors when you use export/import data wizard to move data in SQL Server
  3. FIX: The execution of an SSIS package that is stored in MSDB is slower than it is stored on the file system
  4. FIX: SSIS 2012 or SSIS 2014 XML validator only outputs “TRUE” or “FALSE” when you perform XML validation
  5. FIX: Error when you add a custom connection manager in SSIS 2014 Designer

Data Quality Services (DQS)

  1. FIX: Error when you execute DQS stored procedure [internal_core].[RestoreDQDatabases] in SQL Server
  2. FIX: Error when you use DQS Cleansing component with large batch in an SSIS 2012 or SSIS 2014 package

Analysis Services

  1. FIX: Totals are wrong after you filter on a pivot table item and remove the filter in SSAS 2012 or SSAS 2014
  2. FIX: SSAS instance crashes when you perform writeback action by using the role with cell security defined
  3. FIX: The execution of an MDX query in SSAS 2012 or SSAS 2014 is much slower than it is in SSAS 2008 R2
  4. FIX: Access violation occurs when running a Process Recalc on a tabular table in SSAS 2012 or SSAS 2014
  5. FIX: Data models do not load after you run a PowerPivot scheduled data refresh job when you work with SQL Server 2014
  6. FIX: You cannot create a power view report against a UDM cube in SSAS 2014
  7. FIX: Poor performance when you use DAX functions on a String or Boolean column in SSAS 2014
  8. Can now disable checking whether dimension and partition data originate from the same data source when you run a ROLAP query in SQL Server 2014

Reporting Services

  1. FIX: “SQL Server performance counters are disabled” when you move the SQL Server resource in SQL Server 2014

In-Memory OLTP

  1. FIX: Error in checking master database after you bind a memory-optimized database to a resource pool in SQL Server 2014
  2. FIX: Sys.indexes returns incorrect value for indexes in SQL Server 2014

SQL performance

  1. FIX: Intense query compilation workload does not scale with growing number of cores on NUMA hardware and results in CPU saturation in SQL Server
  2. FIX: Assertion failure when you execute a query specifying TOP N and ORDER BY in SQL Server
  3. FIX: Incorrect results when you run queries that contain UNION operator by using parallel query plan in SQL Server
  4. FIX: An access violation occurs when you execute update query on a table that has a DML trigger in SQL Server
  5. FIX: Poor cardinality estimation when the ascending key column is branded as stationary in SQL Server
  6. FIX: Metadata corruption occurs when you update index statistics with INCREMENTAL=ON in SQL Server 2014

Download now

Categories: Hotfix Tags: , ,

DBF Viewer and Converter – Utility Software


DBF is a database file format and it is one of the oldest and successful data storage in the past and present. This blog post is just to introduce a utility software called MyDBFViewer. This is used to view dbf files and convert it to CSV format with simple button clicks. Please download and use this software and share your feedback in the comment section.

Sample screen of the software:

pic1

Software Manual:

Step 1: Select a DBF file using Select file button or type the file path in the text box.

Step 2: Click Browse Data button to load the data on the screen.

Step 3: Click Export to CSV button for exporting data to CSV file. To perform this step you have to complete Step 2.

DBF file used in this demo is available here.

Note: Please download and rename the file MyDBFViewer.pdf to MyDBFViewer.exe

Categories: Tools Tags: , , ,

Fix Index Data loss issue – SQL Server 2012


This is a hotfix from Microsoft  for SQL Server 2012 to prevent the data loss while building cluster index.

Microsoft provided two options to solve this problem

1. Work around –  run the online index build in serial mode (DOP = 1).

2. ResolutionKB article –  Hotfix Download here

Categories: SQL Server

SQL Server Data Sampling or Limiting Result-set


We may need a limited result set of a huge dataset .  Because, we may need to apply some statistical model with different sample data to check the output in various conditions or simply for testing the application or may be for other purpose. In these scenarios, we need to use the sampling commands available in SQL Server. Eventually, It will save some  time and resources.

Below given methods can be used to fetch limited number of rows from a result set.

In this blog post we are going to learn TableSample clause.

TABLESAMPLE

Table sample clause limits the number of rows returned from a table. We can specify the sampling data in row count or in percentage value. So, it will return only the specified number of rows instead all records.

But, we cannot use this with the following DML and DDL statements.

DML statements- Derived tables, Tables from linked servers, and Tables derived from table-valued functions, Rowset functions and OPENXML.

DDL statements – View and  Inline table-valued function.

 Syntax

TABLESAMPLE [SYSTEM] (sample_number [ PERCENT | ROWS ] ) [ REPEATABLE (repeat_seed) ]

SYSTEM is an ANSI SQL implementation and it is the only sampling method available in SQL Server. TABLESAMPLE SYSTEM returns an approximate percentage of rows and generates a random value for each physical 8-KB page in the table. It returns all the rows on approximately based on that calculation.

The REPEATABLE option causes a selected sample to be returned again with the given seed value. It returns the same output  as long as the table has no changes affect by DML commands or table maintenance operation (such as index rebuild, backup and etc).

Examples

Database used for the example is AdventureWorks2012

1. In this example SQL query we get a sample of  x percent in n rows. I am going to execute the following statements twice.

SELECT FirstName, LastName FROM Person.Person TABLESAMPLE (10 PERCENT) ;

Output: No. of Rows after execution 1 and 2 are 1550 and 1755 respectively.

2. In this example SQL query we are going to use option repeatable.

SELECT FirstName, LastName FROM Person.Person TABLESAMPLE (10 PERCENT)    REPEATABLE (205) ;

3. In this example we are going to use rows option.

SELECT FirstName, LastName FROM Person.Person TABLESAMPLE (100 ROWS) ;

4. In this method we are going to use NewID() guid generating function to get randomized rows.  But, it consumes some time for processing. So, use it with caution.

Select top 5 percent * from Person.Person order by newid()

There are other ways to work with large table using RAND(), newid() and Binary_Checksum() functions. Please read this article for more information.

Categories: SQL Server Tags: ,

Hotfixes for SQL Server 2012 Business Intelligence Services


Microsoft released Cumulative Update 10 for SQL Server 2012 SP1 today. This hot-fix release contains more fixes for Business Intelligence related components. Below given are BI related hotfixes for Integration Services, Data Quality Services, Analysis Services, Reporting Services

Integration Services

  1. You cannot change the Run64BitRuntime property of an Integration Services project by using the SQL Server Data Tools in SQL Server 2012 or SQL Server 2014
  2. FIX: The execution of SSIS package takes a long time when you cannot enable garbage collector server mode in SSIS 2012
  3. FIX: Errors when you use export/import data wizard to move data after apply CU2 for SQL Server 2008 R2 SP2 or in SQL Server 2012
  4. FIX: “Query Timeout Expired” when you preview a command of an SSIS package in SSDT 2012
  5. FIX: The execution of an SSIS 2012 package that is stored in MSDB is slower than it is stored on the file system
  6. FIX: SSIS 2012 XML validator only outputs “TRUE” or “FALSE” when you perform XML validation

Data Quality Services

  1. FIX: Attributes sort incorrectly after using the Attribute Properties function in SQL Server 2012 MDS Add-in for Excel
  2. FIX: Error when you execute DQS stored procedure [internal_core].[RestoreDQDatabases] in SQL Server 2012
  3. FIX: Error when you use DQS Cleansing Component with large batch in an SSIS 2012 package
  4. FIX: Incorrect DBA reference of business rules after you upgrade SQL Server 2008 R2 MDS to SQL Server 2012 MDS

Analysis Services

  1. FIX: Totals are wrong after you filter on a pivot table item and remove the filter in SSAS 2012
  2. FIX: SSAS instance crashes when you perform writeback action by using the role with cell security defined
  3. FIX: The execution of an MDX query in SSAS 2012 is much slower than it is SSAS 2008 R2
  4. Incorrect folder when deploying PowerPivot solutions through CA
  5. FIX: Access violation occurs when running a Process Recalc on a tabular table in SSAS 2012
  6. FIX: Sub-total of calculated measure is incorrect (non-filtered) when you execute MDX query in SSAS 2012
  7. FIX: Performance regression when you operate on a string or Boolean column by using DAX functions in SQL Server 2012
  8. FIX: An exception and access violation occur when you run an MDX calculation in SSAS 2012

Reporting Services

  1. FIX: Excel rendering extension produces corrupted files when rendering a NaN or Infinity value in SSRS 2012
  2. FIX: Data-driven subscription can’t be created when the driving query takes longer than 30 seconds to execute in SQL Server 2012
  3. FIX: Keyboard keys do not work for Report Viewer 2012 in a Windows Forms application
  4. FIX: “Parameter missing value” error when you use a drillthrough report in SharePoint in SSRS 2012

Complete list of hotfixes are given here. Please test the hotfixes before applying to production environment.

Follow

Get every new post delivered to your Inbox.

Join 315 other followers

%d bloggers like this: