Thursday, September 2, 2010

SQL SERVER - Sql Server2000 Vs Sql Server 2005

  1. In 2005 enterprise manager and query analyzer given together, you can also open multiple windows in same enterprise manager.
  2. In 2005 you can create 2(pow(20)-1) databases while in 2000 its 65,535.
  3. 2005 introduced some new data types like ‘xml’.
  4. In 2005 you can store large value and object type by using ‘max’ like varchar(max), nvarchar(max), varbinary(max).
  5. In 2005 you can write try – catch statements in stored procedure.

    NSRI (shortcut to remember) in Sql Server 2005 –

    Notification services enhancement
    Service broker
    Reporting service enhancement
    Integration service enhancement

-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Node | Cluster Vs Worker Threads

Cluster: Multiple processes (scale app across CPU cores) Worker Threads: Multiple threads (handle CPU-heavy work inside one process) Cluster...

  • Web API Facts
    Web Api is REST based service on web works on http or https. REST - Representational State Transfer  Facts  Rest Facts Client-Server model: ...
  • Architecture - .NET Project Architecture Design Framework
    System development steps and phases  Requirement  🧭 Step 1: Understand the Business and Technical Requirements Tools 🧩 Step 2: Choose the ...
  • EF - N+1 Problem
     ✅ What is the N+1 Query Problem? The N+1 problem occurs when your code runs: 1 query to load a list of parent records + N additional q...