It has been a long time since SQL Server 2008 R2 got Service Pack Update. Microsoft has finally released SQL Server 2008 R2 service pack 3and its feature pack. SQL Server 2008 R2 SP3 contains fixes to issues reported as well as Hotfix solutions have provided since SQL Server 2008 R2 Service Pack 2 up to and including Cumulative Update 13.
SQL SERVER – Extension of the SQL Server Natively Compiled Stored Procedures
Earlier I wrote a blog post about the Location of Natively Compiled Stored Procedure and Naming Convention. In this blog post, I wrote about location of natively compiled stored procedures.
SQL SERVER – SSMS: Resource Locking and Object Execution Statistics Report
As a DBA or SQL Developer, the amount of time we work with SQL Server Management can never be measured. As a database person, these hidden gems of SQL Server can never be underestimated. With each release the tool improves to give the next set of features. I have seen in multiple blogs where the Product Managers constantly ask for feedbacks and are looking at making enhancements to the tool. If you go to the connect site, the votes for a feature requests decides if they will ever make it into the next release of SSMS. If you get the drift, knowing the statistics on a given request decides how the feature will get added. These statistics and questions gives product team the confidence to people’s request. Similarly, when working with SQL Server objects, it will be useful if we can know how many times a procedure were called and how many CPU, IO cycles were spent. Let’s see Resource Locking and Object Execution Statistics Report.
SQL SERVER – How to Setup Delayed Durability for SQL Server 2014?
Yesterday we discussed about the Basics of Delayed Durability in SQL Server 2014. Today we will learn one more topic about this subject – How to Setup Delayed Durability for SQL Server 2014?
SQL Authority News – Download and Install AdventureWorks 2014 Sample Databases
If you are using SQL Server there are good chances that you are familiar with AdventureWorks. AdventureWorks is a Sample Database shipped with SQL Server and it can be downloaded from GitHub site. AdventureWorks have replaced Northwind and Pubs from the sample database in SQL Server 2005. The Microsoft team keeps updating the sample database as they release new versions. I use the AdventureWorks database for most of my example, as it is easy to use sample database which is accessible for most of the people out there. Let us learn to install AdventureWorks.
SQL SERVER – Introduction to SQL Server 2014 In-Memory OLTP
In SQL Server 2014 Microsoft has introduced a new database engine component called In-Memory OLTP aka project “Hekaton” which is fully integrated into the SQL Server Database Engine. It is optimized for OLTP workloads accessing memory resident data. In-memory OLTP helps us create memory optimized tables which in turn offer significant performance improvement for our typical OLTP workload.
SQL SERVER – SSMS: Top Object and Batch Execution Statistics Reports
The month of June till mid of July has been the fever of sports. First, it was Wimbledon Tennis and then the Soccer fever was all over. There is a huge number of fan followers and it is great to see the level at which people sometimes worship these sports. Being an Indian, I cannot forget to mention the India tour of England later part of July. Following these sports and as the events unfold to the finals, there are a number of ways the statisticians can slice and dice the numbers. Cue from soccer I can surely say there is a team performance against another team and then there is individual member fairs against a particular opponent. Such statistics give us a fair idea to how a team in the past or in the recent past has fared against each other, head-to-head stats during World cup and during other neutral venue games.