Table Valued Parameters in SQL Server

Table Value Parameters in SQL Server


www.sqlteam.com/article/sql-server-2008-table-valued-parameters

Multiple Insert, update in C# SQL server

Multiple Insert, update in C# SQL server

https://msdn.microsoft.com/en-us/library/aadf8fk2.aspx

Application pools in IIS

Application pools in IIS

An application pool is a group of one or more URLs that are served by a worker process or a set of worker processes. Application pools set boundaries for the applications they contain, which means that any applications that are running outside a given application pool cannot affect the applications in the application pool.

Application pools offer the following benefits:

• Improved server and application performance. You can assign resource-intensive applications to their own application pools so that the performance of other applications does not decrease.
  
• Improved application availability. If an application in one application pool fails, applications in other application pools are not affected.
  
• Improved security. By isolating applications, you reduce the chance that one application will access the resources of another application.

Database currently using by Market leader

Database currently using by Market leader

Google - Bigtable

LinkedIn.com -
Oracle (Relational Database)MySQL (Relational Database

Stack Overflow - SQL Server.

Flickr uses MySQL.

YouTube uses MySQL but they are moving to Google's BigTable.

Myspace uses SQL Server.

Wikipedia uses MySQL.


Facebook.com

Hive (Data warehouse for Hadoop, supports tables and a variant of SQL called hiveQL). Used for "simple summarization jobs, business intelligence and machine learning and many other applications"

Cassandra (Multi-dimensional, distributed key-value store). Currently used for Facebook's private messaging.

POST vs PUT in Rest

POST vs PUT in Rest 

Example :

"POST /books" with a bunch of book information might create a new book, and respond with the new URL identifying that book: "/books/5".

"PUT /books/5" would have to either create a new book with the id of 5, or replace the existing book with ID 5.

In non-resource style, POST can be used for just about anything that has a side effect. One other difference is that PUT should be idempotent - multiple PUTs of the same data to the same URL should be fine, whereas multiple POSTs might create multiple objects or whatever it is your POST action does.

Ajax call in MVC

Ajax call in MVC

The first thing to look at is the key settings options that are available for AJAX requests:

type This is type of HTTP Request and accepts a valid HTTP verb. POST is the option illustrated in this article.
url This is the location of the resource that the request will be made to.
data This is the actual data to be sent as part of the request.
contentType This is the content type of the request you are making. The default is 'application/x-www-form-urlencoded'.
dataType This is the type of data you expect to receive back. Accepted values are text, xml, json, script, html jsonp. If you do not provide a value, jQuery will examine the MIME type of the response and base its decision on that.

Example

< script >
   $( function () {
        $( "button" ).click( function () {
            var car = { Make: 'Audi', Model: 'A4 Avant', Colour: 'Black', Registered: 2013 };
            $.ajax( {
                type: "POST",
                url: "/Receiver",
                data: car,
                datatype: "html",
                success: function ( data ) {
                    $( '#result' ).html( data );
                }
            } );
        });
    } );

< /script >

Setting async false in ajax in MVC

Setting async false in ajax in MVC

Setting async to false means that the statement you are calling has to complete before the next statement in your function can be called. If you set async: true then that statement will begin it's execution and the next statement will be called regardless of whether the async statement has completed yet.




By default async is true in ajax call.