Recently, I worked on optimizing a Store Procedure. Previously the SP took 24 seconds to execute for one single response. Now it takes only 0.01 second


We can use a user-defined table type to declare table-valued parameters for stored procedures, functions or in a batch. However, we cannot alter/modify the type once it is created. As per Microsoft

In the restriction section, it says: ‘The user-defined table type definition cannot be modified after it is created’.

But sometimes we need to modify or alter the user defined types.



Very recent in one of our project we came to a need to manage custom stored procedures in entity framework in a convenient way so that we do not manage them manually for any modification. Moreover, we wanted to reduce the deployment hassle. We were using the code first approach and our intention was to deploy them automatically using the entity framework Migration. Here are my findings after google search and study.

This article shows how to automate the process of transforming the configuration file like App.config, Web.config file when we deploy it to the different destination environments like Dev, Stg, Prod. Most applications have settings in the App.config or Web.config file that must be different when the application is deployed. Automating the process of making these changes saves us from having to do them manually every time we deploy, which would be tedious and error prone.

| Mastering Selenium Testing Tools [Video] | Mastering Selenium Testing Tools [Video] | Test the look, feel, and performance of web applications across different web browsers using Selenium for a flawless user experience

git ci -m "Fix interface issues"

| CountIt! a simple Chrome extension that may help you. | CountIt! a simple Chrome extension that may help you. | This is a simple chrome extension which may help you to quickly determine the number of words and characters contained in any phrase along with the string match. You can download it from the chrome...

JS generators which you should be familiar with. | Abhi Jain's .NET Blog: JavaScript Generators | Abhi Jain's .NET Blog: JavaScript Generators | This is a blog where I try to describe the lessons that I learn on my journey on .NET. My aim here is to spread the knowledge that I gain which will help all of us to be a better developer. In this blog I will explain the books, other articles as well as my own experiences which I go through everyda…

Koans are available all most all of the programming languages. I just shared the Python, you will find the others in Github as well. | gregmalcolm/python_koans | gregmalcolm/python_koans | python_koans - Python Koans - Learn Python through TDD

Also do check the first part if you are into functional programming. | Intro to Functional Programming Concepts in JS, part 2 | Intro to Functional Programming Concepts in JS, part 2 | This blog post is part 2 of a multi-part series. In part 1, we introduced the functional library Ramda, and the concepts of composition, pointfree style, and functors through the simplest of …

Subscribe to Front page feed