Thanks for your replu. I already resolved the problem like you have resolved, but i am getting the prob while using namespace

RootElement xmlns="http://www.w3org.com/XMLschema.xsd"

ChildElement Value="1"

SubElements

Id 1 /Id

Value A /Value

/SubElements

SubElements

Id 2 /Id

Value B /Value

/SubElements

ChildElement

RootElement

I have xml schema...

SELECTDB_NAME() AS DATABASENAME,

OBJECT_NAME(B.OBJECT_ID) AS TABLENAME,

B.NAME AS INDEXNAME,

B.INDEX_ID

FROMSYS.OBJECTS A

INNER JOIN SYS.INDEXES B ON A.OBJECT_ID = B.OBJECT_ID

WHERENOT EXISTS (SELECT *

FROM SYS.DM_DB_INDEX_USAGE_STATS C

INNER JOIN master.sys.databases...

we cannot decide w/o knowning few factors like how frequently data will be selected, frequency of insert / update, selectivity on columns to be search..

if you are using SQL Server 2005

then type sqlwb in cmd prompt.

after hard practice on SQL serevr 🙂

refer SQL Server DBA Books

hope this wud help you...

CREATE TABLE #test(

IDINT,

TextCHAR(3),

ParentIDINT

)

INSERT#test

SELECT1, 'xyz', NULL UNION

SELECT2, 'pqr', NULL UNION

SELECT3, 'abc', 1 UNION

SELECT4, 'mno', 1 UNION

SELECT5, 'xyz', 3 UNION

SELECT6, 'oop', 3 UNION

SELECT7, 'umn', 2

SELECT...

I would say that change the recovery model to SIMPLE, before that take a full backup of your database and as Mike said decrease the time limit for transaction log...

okay let me explain the criteria,

I have 1 query which contains dynamic where clause. I dn't known which cols will be consider to filer the records, I dn't known the...

I think you have create the union for "Other" countries

when SQL Server 2008 SP 1 launched. 🙂

Hi check this example this will demonstrate how partition helps you to store the data efficiently. Hope this will help you.

http://sqlity.blogspot.com/2008/03/partition-table-example.html

Fulltext indexes are used when we would like to implement wide search, like finding Therasure/Word within the sentence.

E.G: Google Search/ in Job site you search the Job Description, Location,...

There may be the possibilities that table either contains Primary / Identity Field or may not contains any ke, so in that case how do you insert the record ?