No , i have hundreds of XML files of the same structure that i need to parse.

So , using the XML source adaptor , i generated the XSD file Hbeds.xsd.

When...

No, not at all.

My point is that with Hbeds.xsd i dont get an output of Occupancy, whereas with Hbeds1.xsd i do.

Its not double counting...

Its telling you that to do the insert command it has done 58k reads.

Also it is telling you that the total amount of reads for the "exec...

Anyone fancy mind-dumping there entire sql knowledge into a few threads :rolleyes:

http://www.sqlservercentral.com/Forums/Topic916801-1292-1.aspx

http://www.sqlservercentral.com/Forums/Topic916751-1292-1.aspx

Please keep to one thread...

http://www.sqlservercentral.com/Forums/Topic916801-1292-1.aspx

Same answer though

Those are BIG BIG questions and really outside of the scope of supported that can be provided on an on-line forum such as this.

Read all the books that you can...

Try both methods over say 1 million rows.

I would suspect , though i...

Try this link

http://www.brentozar.com/archive/2010/03/fusion-io-iodrive-review-fusionio/

there is no inverse of dateName.

I would use a table to do this.

It could be referencing the first view because its using a cached plan (use DBCC FREEPROCCACHE to clear the cache, note that this is not advisable in a live environment)...

Why would you want to ?

The optimizer has done its job and found that using the view will give a good plan.

Better , in terms of performance , shouldn't enter into it as the do different things

GROUP by is for use by aggregate functions.

Ie

Select id,sum(costs)

from yourtab

group by...

[b

The acutal question is whether we need to includ ID column in all non clustered indexes?

second question is do we need to separate each non-clustered index or keep multiple columns...

Try sp_msforeachtable and sp_msforeachdb

http://www.sqlservercurry.com/2009/04/8-common-uses-of-undocumented-stored.html

Not really, using a CTE is the only single statement way to traverse a hierarchy.

If you want to limit your self to X levels , you can simply left join...