Install SQL Server 2016 Service Pack 2 (SP2) and Cumulative Update 11 (CU11) Builds

How to Install SQL Server 2016 Service Pack 2 (SP2) and Cumulative Update 11 (CU11) Builds

Microsoft usually releases SP’s and CU’s to fix hundreds of bugs after the initial releases of the SQL Server 2016 RTM, and they have also has been adding a significant number of product improvements and new features after the RTM release. So, in my opinion each SQL Server SP’s and CU’s are very important hotfixes...Continue reading

split delimited string column into a table rows

How to split delimited string column into a table rows in SQL Server Instance

One of the challenges that always comes up when dealing with data captured through the apps is parsing multi-value fields. Many apps have “check all that apply” checkboxes, and the data from those type of questions often logged as a single delimited (mostly comma) field value. For example, the values from a sections of check...Continue reading

last modified date of stored procedures

How to determine the last modified date of stored procedures in SQL Server Instance

When working in SQL Server Instance, we frequently need information on when a stored procedure was last modified in SQL server.  Fortunately, finding the last modified date of stored procedures in SQL server using meta data tables is quite easy. We can do this by query SQL Server’s meta data tables, which store information about an object’s...Continue reading

Scroll to top