Bhuvnesh (5/2/2010)

---

But on the same server, different databases have same query with different results, it means that there should be some different database settings. if not then what else could...

Paul White NZ (4/29/2010)

---

Matt Miller

---

So - if the DB engine doesn't see there being any improvement in rebuilding (say - the index is so small that it will always fit...

Jeff Moden (5/1/2010)

---

Absolutely my bad. Not sure why i was thinking that LEN would be affected by those. What I was thinking of was how much space was...

kinzent (4/29/2010)

---

Matt Miller (#4) (4/29/2010)

---

kinzent (4/29/2010)

---

Index rebuilding is a bit like disk defragmentation: the goal isn't to achieve 100% perfect defragmentation, it's to improve the performance of the index. ...

webrunner (4/29/2010)

---

Minor spelling quibble. I believe the spelling is "shear forces," not "sheer forces."

Thanks for the editorial, though - it really got me thinking again about the construction metaphor for...

One thing that might help: just because the server is a VM doesn't have to mean that it's sharing resources with anything else. Our VM servers are set up...

kinzent (4/29/2010)

---

When we rebuild the index, can SQL Server make the physically and logically order to be corresponding?

And if the logically does not match the physically ,does it mean the...

It's stored roughly in the correct order. Roughly - as in it may not be exactly sorted within the page.

That said, like others have said - the physical order...

Digs (4/28/2010)

---

.."Is the symbol column supposed to be IN the xml snippet, or - outside of the XMl, in the outer table that holds the XML column? It changes how...

Is the symbol column supposed to be IN the xml snippet, or - outside of the XMl, in the outer table that holds the XML column? It changes how...

Let's keep it that way! (not contradicting that is). I will let you get...

Digs (4/28/2010)

---

Sure whatever works..

So I just do

INSERT INTO dbo.DIM_OHLC_Xml

SELECT

@symbol AS Symbol,

@CurrDate AS Currdate,

...

Jeffrey Williams-493691 (4/28/2010)

---

Matt Miller (#4) (4/28/2010)

---

How is len going to be affected by either of those settings?...

How is len going to be affected by either of those settings? I thought about those,...

I have to say, it's interesting to see a contrast being made between "flexible" code and "solid" code. In my mind, the MORE "flexible" your code needs to be,...