GilaMonster (1/21/2014)

---

LOB_DATA is your varchar(max), nvarchar(max), varbinary(max), XML and a few other data types. They have special storage.

Typically you want to filter for 'in row data' when reindexing because reindexing...

Hi Matt, thanks for the prompt response!

As I'm looking at my environment at large, I'm finding multiple incidents where I've been doubling down on the work to do because...

Hi Vinod,

Again the requirement is also for SQL2000/2005 and preferably in a central manner. Obviously yeah, I could create my own custom collectors (which I probably will), the ideal thing...

Thanks for the responses guys!

sharon - I've used this in the past and at the time it didn't fit the bill; however I'll definitely give it a shot again.

mascot -...

Thanks Lynn. Thus far can't seem to find it, but I'll keep looking!

Agreed; however my thoughts were not clearly articulated as I'm in a fire fighter mode right now ... I plan on returning once I better understand how I blew everything...

Yeah, been actively reading while playing. Not worried about the lack of being able to modify data.

We're a heavy ETL shop, so I would drop the index at time of...

Thanks for the responses, definitely great suggestions and gives me more ideas to work with.

Currently though, thanks to a friend of mine, I began playing with column store indexes and...

So overall, I personally haven't had much experience with using a date table or a date dimension. We're moving forward with some large changes in the near future; however my...

I'm already quite far passed this original thread as I'm exploring many other options for performance; however my original question does still stand that I'm still cloudy on. I posted...

Chris Harshman (3/13/2013)

---

Grant Fritchey (3/13/2013)

---

What I meant was store the Month & Day values as those, either during the insert/update process or as calculated columns. Performing functions on columns in...

Found what I was looking for: http://asstoredprocedures.codeplex.com/

Also, I have been successful with recreating the performance of the original index simply by moving the InvoiceDate to the first position of the index. Typically I have targeted the...

Grant Fritchey (3/13/2013)

---

Without the execution plan to look at details, it's hard to know. Recommended indexes are just suggestions. First, I'd take a look at the SELECT operator to see...

Sorry for the confusion, see attached.

Thanks