Thanks for reply

So i have to update statistics regularly for large tables right?

hi kapil

In the link you have mentioned there i found below queries

DECLARE @tbl TABLE

(

id INT,

col XML

)

INSERT INTO @tbl

VALUES

(1,'<name><name1>5</name1></name>'),(2,'<name>6</name>')

DECLARE @id int

SELECT @id = 6

SELECT ...

Hi Lowell

You are correct.If i select in options then it works.

But there is an exception.If i am using "script entire database and all database objects" while generating script then...

Lynn Pettis (5/3/2013)

---

Your database isn't really that big compared to others. Another choice you could make if you have the maintenace window do it is this:

1. Script the database...

Allow null is allowed for these column. I also checked that for which column this difference comes? For about columns with datatype int NULL was replaced with 0. For another...

In edit option there is no option for it.When i checked there was only 3 options Drop and recreate the destination table,Delete rows in destination table,Enable identity insert. So i...

Hi matthew..

i got it

To change the value in a XML column i need to first extract the value as a float and write it back as an int.

Something like this.

update...

Hi Matthew

It worked nice. But can i avoid these scientific notation while saving to xml itself?

I have got answer for my question

Please check this post

this is the query :

SELECT [DesignChanges].* FROM [Checklists].dbo.[DesignChanges]

WHERE

(

Charindex('jyo',[Checklists].dbo.[DesignChanges].[AllotedTo])>0 AND

(

...

Whether any other tweaks available which can help me to remove replication related data from it? The problem is now i need sql server standard to add a publisher to...

Whether i can use selective xml index? Does it available in sql server 2008 r2 express?

It had replication set in it about 6 months back. But now it is removed.

As you said i can add replication once again and remove it.But it is a production...

Ok. But while creating PATH type index is there needed to specify the path which i use?

I don't know much about xml indexing. But for other datatypes there is...

After detaching and attaching the database when i run query nothing returns. So it is solved.

But while running dbcc opentran i am getting output like following.

Transaction information for database 'Reg_test'.

Replicated...