Hey Barry, If you start working with spatial data in 2008, you may find...

Roy Ernest (6/12/2009)

---

I am married... She points out my mistakes when I am home... :hehe:

Grant, Steve Thanks for the input. The Parameter size that is passed through with variable size,...

simsr (6/12/2009)

---

What you're seeing is an artifact of the estimated cost values. SQL Server can't know how long a query is going to take to run, so the estimated cost...

Roy Ernest (6/12/2009)

---

What do you all know about nHibernate? Seems like it has a problem executing SPs. They are good for CRUD I guess.

Isnt Subsonic better than nHibernate? Subsonic...

Sounds like you need a LEFT join. That will return all from A and only those that match from B.

simsr (6/12/2009)

---

Interesting - I just went through this same process myself last week, but I did it a little differently becuase I was concerned about the same thing. Instead of...

Hard to know for sure, but hazarding a guess, your index was defragged, but the statistics were out of date, so rebuilding the index updated the statistics which fixed the...

This part of the code is going to cause problems:

WHERE

p.RegionID = COALESCE(@RegionID, p.RegionID)

AND

p.PriceBracketID = COALESCE(@PriceBracketID, p.PriceBracketID)

If you get index use ata ll on this table,...

In Management Studio, check out View, Template Explorer. Scroll down & find Stored Procedures and the "Create Stored Procedure (New Menu)" script. Edit that and the next time someone...

YAY!

Now if only people will read and follow the advice here.

Well done. Very nicely laid out and explained.

RBarryYoung (6/12/2009)

---

Good catch Bruce. I had suspect some sleight of hand from either the OP or the Client code, but I missed the codegen reference.

Does anyone know of any...

Jeffrey Williams (6/11/2009)

---

Grant Fritchey (6/11/2009)

---

You will see contention between these two processes.

I'd suggest getting the DBCC run first. If there are problems with the database, you want to know prior...

Nope.

This is a side-by-side test between Profiler & server-side traces by Linchi Shea. The difference is not to be sneezed at.

When the Profiler GUI runs, it attaches a memory latch...

You will see contention between these two processes.

I'd suggest getting the DBCC run first. If there are problems with the database, you want to know prior to running backups.

vaxn8r (6/11/2009)

---

Thanx !! I never can get a grip on the whole licensing model of m$, but I believe if we were already licensed for vs2008 we could move...