SQL Server 2005 adds a raft of new features to support XML data storage and manipulation. These features make it easier to persist your XML documents within the database, while providing increased performance over the traditional techniques...
Subscribe to:
Post Comments (Atom)
About Me
- MR. JOYDEEP DAS (MCDBA) for SQL Server/BI and MR. PALASH PAUL for .NET
- This web hosting contains the critical information related to SQL server and .NET. All this information is taken from day to day development life cycle. If you need any critical information related to SQL server or .NET, feel free to mail us at(for All) sqlserver.asp.net@gmail.com For SQL Server and Business Intelligent (BI) das.joydeep2@gmail.com and for .NET palashpaul.net@gamil.com
Popular Posts
-
We have common doubts when to update statistics, before index or after index. To resolve this query we must understand, what is the stati...
-
This article gives you a total overall idea related to collation. It not only contains definition but also contains SQL comparisons an...
-
The isolation level is a very important part of SQL Server. This article gives you a scenario related to isolation level. The problem o...
-
I am a mail form one of my DBA friend to request about: "Please advice that how I can restore the database from backup file plac...
-
The most important thing of a table is defining the primary key; it could be single column based or the composite primary key. In my...
-
SQL Server will reuse space made available when rows are deleted from a table. This occurs automatically without any outside intervention on...
-
In this article I am trying to collects some facts related to temporary table and table variable. So let's start about it. ...
-
Abstract Factory pattern is used to create concrete class instances without specifying the exact class type (i.e. to create instance of a cl... -
In this article we have to learn the covered index. As the name suggest the cover index "COVER" all the columns in the selec...
-
I saw many of the DBA have the wrong concept related to stored procedure. They think that the stored procedures are pre-compiled. I ...
No comments:
Post a Comment