Browse by Tags
» SQL Server 2014 (RSS)
Showing page 1 of 4 (37 total posts)
Today I was
asked to do a pretty easy thing. The task was to add a filestream support to a
table that already stores some documents. The customer wants to keep the data
outside the database because he uses the SQL Server 2014 Express edition.
According to the MSDN page
there is limitation of 10GB that can be stored in this edition and ...
Microsoft has released Cumulative Update #7 for SQL Server 2014. See this blog post for more information.
KB Article: KB #3046038
41 fixes listed publicly at time of publication (47 total)
Build number is 12.0.2495
Relevant for @@VERSION 12.0.2000 through 12.0.2494
Note: This cumulative update is only for RTM - do ...
If you are
tired today maybe you could take your time and spend the whole weekend with the
SQL Server 2014 and Azure?
The new MVA course is ready :) and waiting for you. Just visit the
link http://bit.ly/1CXZT90 and enjoy. Watch out - it's in Polish
SQL Server as IaaS - means SQL Server on ...
Stop me if you've heard this one before.
Microsoft has released Service Pack 1 for SQL Server 2014. However, do not install it if you use the SSIS catalog (SSISDB). From the Release Services team blog:
Notice: The SQL SSIS team has found an issue with SP1 installation if SSIS catalog is present in the SQL Server instance.They are ...
Today Microsoft released a critical, on-demand hotfix for customers using Columnstore indexes in SQL Server 2014. The hotfix addresses a scenario where a batch-mode scan that has gone parallel can deadlock, and the deadlock cannot be resolved automatically.
The hotfix can be downloaded from KB #3048751 and will bump SQL Server to ...
Last week, Microsoft released an on-demand hotfix for SQL Server 2014, which you shgould consider installing if you are using Availability Groups and any of the relevant databases use CLR user-defined types (UDTs). The symptom is described in KB #3042370, and you should get enough info just from the title to convince you to apply it:
Great news today!
At the end of January it was a Connect
that described a possible memory leak on the SQL Server 2014.
The details are as follow:
for type = MEMORYCLERK_SQLQUERYEXEC and sys.dm_os_memory_objects for type ...
Microsoft has released Cumulative Update #6 for SQL Server 2014. This update fixes a few important issues exposed in Cumulative Update #5; see this blog post for some more information about those issues.
KB Article: KB #3031047
64 fixes total (55 fixes listed publicly at time of publication)
Build number is ...
A hotfix has been released for an issue that causes Availability Groups to show as NOT SYNCHRONIZING. The original issue is described in KB #3033492 and in this SQL Server Release Services Team blog post.
The issue was introduced through Cumulative Update #5 for SQL Server 2014 RTM, and through Cumulative Updates #3 and #4 for SQL Server 2012 ...
''The SSIS Catalog is a database and an application.'' - Andy Leonard, circa 2015
If there’s one thing I want you to get from this post, it’s this: The SSIS Catalog is a database and an application. While it’s a pretty cool database and application, it isn’t anything different from the databases and applications you support every day. As ...