Technology_AM

This is Amar Gupta, Blogging Technical & personal things, Right now working as a Technical Associate in eTech Acess Marketing Consulting Pvt. Ltd. , in this company Deals Insurance Sector so There many of Use of Technology Like SQL server, .Net Framework, Marketing campaign for advertise Business  purpose.

So personalty i describe here that what i am doing & phasing problem  at the time of development, for reminder or beneficial for other member.

—————————————————————-

Thanks U to All Who  discuss with Me, To Enhancement Technology**

—————————————————————

2 thoughts on “Technology_AM

  1. Hi This is Amar Gupta,
    This is My first Blog in WordPress.com, I M just try to expose what is happening in Sql Server, C#.Net, WCF, LINQ and other using new Technology.

  2. Today working on SQL Server functionality ,With (NoWait) & With (NoLock)

    With (NoLock) :- Produce result in dirty way , and at the time of processing not show any message.

    With (NoWait) :- It is the Standard functionality after NoLock , It is provide a good result or show message , that what happening with that data.
    ————————————–
    For Example: —
    ——————————-
    CREATE TABLE First (ID INT, Col1 VARCHAR(10))
    GO
    INSERT INTO First (ID, Col1)
    VALUES (1, ‘First’)
    GO

    Now open two different connections:

    Connection 1: Run following query

    BEGIN TRAN
    DELETE FROM First
    WHERE ID = 1

    Connection 2: Run following query

    BEGIN TRAN
    SELECT ID, Col1
    FROM First WITH(NOWAIT)
    WHERE ID = 1

    ——————————–

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s