MsSQL – char and varchar comparison, storage concept
In Microsoft SQL Server, both CHAR and VARCHAR are used to store character string data, but they have some differences in terms of storage and behavior. Now, one important question would be, how these data stored on pages? Each page can stored only 8KB of data, so how changing the length of a varchar column…
Number generator from a min and max value online
Just select a min and max values and start Min: Max: Start Next
Jquery: Common place to modify all the ajax request
A lot of time we have to add some common parameter in request header or need to include some parameter in request body or query string. Jquery gives us the flexibility to the same using ajaxSetup method $.ajaxSetup({ // Define a global before request send beforeSend: function(xhr, settings) { if (settings.contentType) { //Update the query…
Impact on performance for case insensitive table and column name(lower_case_table_names) Mysql
The impact on query performance in the context of case-insensitive table and column names in MySQL is generally minimal. The reason is that MySQL’s query execution engine internally normalizes identifiers (like table and column names) to lowercase on case-insensitive file systems or according to the server’s lower_case_table_names configuration variable. Here are some key points regarding…
Jquery: common place to handle all ajax request errors
A lot of time we write similar kind of code to handle errors of an ajax request. And changing logic at every place could be a challenge. Jquery has method to handle this $.ajaxSetup({ // Define a global error handler error: function (xhr, textStatus, errorThrown) { if (xhr.status === 401) { // Handle unauthorized (e.g.,…
JavaScript map method
Lets see how javascript map method works using some examples, some real world problem, Interview question and lastly there is a task for you 🙂 This is an array method which iterate over the array, map values and then return a new array.  Let’s see the syntax of same Array.map(callbackFunction(currentValue, [index], [arr]); Let’s see…
Change Permalinks in WordPress(SEO friendly)
It is very common task to change permalinks in WordPress and can be done easily through the WordPress dashboard. Here are the steps to change permalinks: Log in to your WordPress Dashboard: Enter your WordPress admin URL in your browser (typically, it’s something like http://yourdomain.com/wp-admin/) and log in. Access Permalinks Settings: Once logged in, go…
C# Tool to download the list of image URLs
If you are looking for a tool or exe which you can use to download the images by URLs then you can try below one https://github.com/ranjit-singh-cc/DownloadImagesByUrl Code wise it pretty much simple – You put all the image URLs in url.txt file, and tool iterate over all those URLs and download it in provided destination…
Some less known features of javascript
JavaScript is a versatile and widely used programming language, and it has some interesting and less known features and quirks. Here are 10 hidden facts and unique aspects of JavaScript(less known features of javascript): These hidden facts and features are just a glimpse of what makes JavaScript both powerful and challenging to work with. Understanding…
- 1
- 2