2014

Restart Computer Failure issue during SQL Server 2008 uninstall

Problem: Last night i was uninstalling SQL Server 2008 from my machine and got stuck with an issue “Restart Computer Failure”. I tried several time but after goggling, i got the solution and now sharing with you all Solution : Start Regedit Go to the key “HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager” Delete “PendingFileRenameOperations” entry and try again

Restart Computer Failure issue during SQL Server 2008 uninstall Read More »

New features in SQL Server 2014 (In Database Engine)

New features added in SQL 2014 (Headings only) Below are the enhancement points list : Database Engine Feature Enhancements o    Memory-Optimized Tables o    SQL Server Data Files in Windows Azure o    Host a SQL Server Database in a Windows Azure Virtual Machine o    Backup and Restore Enhancements o    New Design for Cardinality Estimation o    Delayed Durability

New features in SQL Server 2014 (In Database Engine) Read More »

Convert a comma separated list into table

In this post, we are going to learn “how we can convert a comma separated list into a table using a recursive CTE”. Below is the code: Why OPTION MAXRECURSION? Hint OPTION(MAXRECURSION 32767) is a query hint which instructs to compiler to iterate 32767 times. Default, max recursion of a loop in SQL is 100 and in case we

Convert a comma separated list into table Read More »

Set Width of gridview columns dynamically when AutoGenerateColumns is true

Introduction I faced a lot of problems when I asked to set the width of a gridview dynamically, that is the property AutoGenerateColumns set to AutoGenerateColumns=”true” and the gridview was directly bounded from a dataset in code behind. Thus, we don’t have bound fields to set the width of columns individually. I tried a lot

Set Width of gridview columns dynamically when AutoGenerateColumns is true Read More »

Avoid Use of While Loops to get a Comma Seperated list of rows

Problem Detail In the morning at your workplace, your manager or any colleague comes to you and asks to get the list of all the dates in a comma separated list. Now the first and the quickest way of getting the output which will knock us is using a loop to get the list. In

Avoid Use of While Loops to get a Comma Seperated list of rows Read More »