The Dixie Flatline (7/26/2013)

---

SQLRNNR (7/26/2013)

---

crookj (7/26/2013)

---

SQLRNNR (7/26/2013)

---

Revenant (7/26/2013)

---

The Dixie Flatline (7/26/2013)

---

opc.three (7/26/2013)

---

SQLRNNR (7/26/2013)

---

bcsims 90437 (7/26/2013)

---

Daniel Bowlin (7/26/2013)

---

crookj (7/26/2013)

---

SQLRNNR (7/25/2013)

---

The Dixie Flatline (7/25/2013)

---

Georgia...

HildaJ (7/26/2013)

---

I'm not sure if there's a problem, I have not seen this query before and I was inquiring information about it. I see now that updating statistics generates...

Revenant (7/26/2013)

---

SQLRNNR (7/26/2013)

---

I really do think google would be easier if I could do this:

select * from closeby_restaurants where cuisine = 'chinese' and distance_from_home <= 2 miles and deliciousness =...

Do you have an index maintenance routine running on Sundays?

Do you have a very large batch job that runs on Sundays that might possibly create and drop tables?

crookj (7/26/2013)

---

SQLRNNR (7/26/2013)

---

Revenant (7/26/2013)

---

The Dixie Flatline (7/26/2013)

---

opc.three (7/26/2013)

---

SQLRNNR (7/26/2013)

---

bcsims 90437 (7/26/2013)

---

Daniel Bowlin (7/26/2013)

---

crookj (7/26/2013)

---

SQLRNNR (7/25/2013)

---

Don't ever cross them...

The cause for it to not select some tables is likely due to how your code is written.

Please provide the entire code that is generating your update stats so we...

I really do think google would be easier if I could do this:

select * from closeby_restaurants where cuisine = 'chinese' and distance_from_home <= 2 miles and deliciousness = 'awesome' and...

FWIW - I have a Virtual Lab setup on my laptop.

1 DC

2 SAN VMs (freesan, 1 demo and 1 live)

1 Cluster (2 boxes)

2 stand alone sql servers (1 sql 2012...

Thanks for the query

Revenant (7/26/2013)

---

The Dixie Flatline (7/26/2013)

---

opc.three (7/26/2013)

---

SQLRNNR (7/26/2013)

---

bcsims 90437 (7/26/2013)

---

Daniel Bowlin (7/26/2013)

---

crookj (7/26/2013)

---

SQLRNNR (7/25/2013)

---

Don't ever cross them - you...

Jeff Moden (7/26/2013)

---

BWAAA-HAAA!!! I've got tons of hair. I'm just not allowed to show it...

bcsims 90437 (7/26/2013)

---

Daniel Bowlin (7/26/2013)

---

crookj (7/26/2013)

---

SQLRNNR (7/25/2013)

---

Don't ever cross them - you could be in a world of...

dwain.c (7/25/2013)

---

SQLRNNR (7/25/2013)

---

dwain.c (7/25/2013)

---

SQLRNNR (7/25/2013)

---

dwain.c (7/25/2013)

---

Something like this should list out any of the products that fail your audit.

WITH ValidationTables (n, )

SELECT 1, [Key] FROM A

...

dwain.c (7/25/2013)

---

SQLRNNR (7/25/2013)

---

dwain.c (7/25/2013)

---

Something like this should list out any of the products that fail your audit.

WITH ValidationTables (n, )

SELECT 1, [Key] FROM A

...

dwain.c (7/25/2013)

---

Something like this should list out any of the products that fail your audit.

WITH ValidationTables (n, )

SELECT 1, [Key] FROM A

UNION...