Thanks jeff that was helpfull

Thanks Lowell. I exceuted your query and found some of the column name not preceding with dm_...... . So is that OK?

Thanks Lowell........

Roland Alexander STL (10/10/2012)

---

You must drop the existing constraint and create the new constraint. Also, if the PK is the clustering key as well, you should drop or disable any...

Ok. Thanks antony.

so if that is logical then what is physical?

Please pardon me if i am wrong but isn't the query plan generated just when we press the execute button, if yes then that means every time plan is generated...

Hi Gila,

Further into MSDN i found out the defination execution_count it is given as "Number of times that the plan has been executed since it was last compiled." So could...

Thanks man 🙂

In msdn i was looking for sys.dm_exec_query_stats in that there is a column name 'statement_start_offset' . Explanation of it is given as '.....the starting position of the query that...

Hi GilaMonster,

Then what does that hex-codes specifies. Any good resource where i can get the information about the DMV. I mean good resource so do not suggest MSDN 🙂

A is int, B is int and C is int in database

This thing might not make more sense :unsure: but yes the values of a,b and c are decimal. I cannot post the values because that is a large data .As...

Jason-299789 (9/28/2012)

---

Ok, you will need to go through and redefine the Excel column widths and datatypes to match the destination table.

this is done when you are on the Select...

Jason-299789 (9/28/2012)

---

The problem with exporting to excel is that the text is assumed to be varchar/nvarchar 255, as excel doenst hold the original field lengths.

Why not just cut out the...