Jack Corbett (10/23/2009)

---

We had a bit of a scare in my family this afternoon. My 10 year old daughter fell off a rope swing and landed on her head....

Jeffrey Williams-493691 (10/23/2009)

---

fred2002 (10/23/2009)

---

no

i explained it wrong.

first we restricted the size to 300MB

But now due to the errors we allw it to 1.2GB.

MS advise to fix a max size for...

Oh gosh, you're joining and unioning on views. That's potentially the cause of the problem right there.

Looking at the execution plan you've got about 12 different scans, several key lookups...

Oh nuts am I bleeding over again? How come everyone doesn't just upgrade to 2008 and be done with it. It'd sure be...

It really depends on data integrity. If you're dealing with what is essentially unstructured data, then yes VARCHAR(MAX) is the way to go. If you've got a structure, then no,...

Since you're posting this in the 2005 forum, you could use the Date data type. It's only 3 bytes. That's one less than smalldatetime and 5 less than datetime.

There's nothing immediately obvious in the query that would suggest a performance bottleneck. The hard coded values of "0" do beg the question, how selective is that data, are you...

I agree with what everyone else has said, and, I wouldn't discount query tuning. It might be working OK with the set of data in one database and poorly with...

mahesh.vsp (10/23/2009)

---

Hi All,

What is the major difference between index seek and index scan?

I have read few articles where in index seeks yields better performance.

What exactly happens in case of index...

To use the log you'd need to track down a third party tool that allows you to read it. There's no way natively to read from it.

Other options, in addition...

Usually this occurs when the log is trying to grow to accomodate a transaction if the log is in simple recovery. You probably need to monitor the log size much...

I'll be there and at the SSC party.

Yes, absolutely the difference in data types will prevent the indexes from getting used. It's an implicit conversion and they look like magic and therefore free, but it's just a...

sanokistoka (10/22/2009)

---

Have you tried Oracle, which doesn't exhibit, say SELECT/UPDATE deadlocks because of row versioning? Thankfully, there is now row versioning in MSS. The point being is that, yes an...

bitbucket-25253 (10/22/2009)

---

Grant used Live Meeting to make a presentation to the Columbus SQL...