No offense but I run reports on 10s of millions of record in subseconds with 10-40 tables in joins on a 2 core 4 GB ram server... not slow...

Also what does the UID filters?? It seems to filter out only on dbo owned objects. I would possibly whack this if you have objects not owned by...

I've never tried this (never used indexed views in prod) but you could try this simple tweak and see if it runs :

WHERE XTYPE = 'V'

If that works...

How much faster is it?

Create table PatientOperations

(PatientId, OperationId, OperationDate (for order by))

Then your query simply becomes

Select * from PatientOperations where Operation IN (Ids 1,2,3,4,5)

Join back to base table(s) to get the rest of the...

lk-681111 (6/28/2011)

---

Thank you for the link! This whole thing makes a lot more sense now. So basically, shrinking the database is what's fragmenting the indexes, and the Rebuild Indexes step...

Binary column are "supposed" to hold binary data, which 99% of the time is used to store a file like a jpeg, pdf or doc file.

So to be able to...

dva2007 (6/28/2011)

---

GSquared,

I hate myself for not thinking this. It is one of the best solution. There must be other alternative where i can Unpivot it and then write the select...

Martin Smith-178018 (6/23/2011)

---

I've been trying to find documentation on the exact page replacement policy myself without much success.

I did find the following quote though which might explain the difference...

if convert(VARCHAR(2000), colname) doesn't work then you need to use the actual application to read it.

It's a text comment put in a varbinary column? Are you sure this is not a blob of some sort like .doc or .pdf?

Why do you need to convert that column to be able to join? I never had that restriction before!

Table design is wrong. You should only have one column meaning operator or whatever that means.

This is precisely why you shouldn't have a table built this way.

Welcome all, in the name of whoever I stole it from on these forums :hehe:.

Sorry but I don't know the originator so I'll just give credits to Bill Gates. :alien::smooooth:

yes