Hi Folks, a general question here for better admin on a database. Have a number of tables, with approx 100 rows that clear down and re-populate every 5 minutes,...

Hmmm... I wonder if the new Cardinality Estimator would actually do a better job at this?

Wow, Patrick.  You totally missed the point.  Ron stated that Gail said something that she didn't actually say and that was the point of contention.

Thank you both for looking at this. Another spanking for me by SQL Server - what else is new? But it's not going to be that much work to...

I assume that the EXISTS operator must be pushing down a row estimate because all it takes is a single match and EXISTS stops executing. So instead of hash...

she then concludes that these results should all but put the nail in the coffin on integers vs naturals keys.  This is NOT a valid conclusion...

It must not like you... I tried the same thing and got no such error.  I'm using FireFox.  You might want to let them know which browser you're using.

Looking at the "Plain" version of the execution plans, it would appear that the IF EXISTS is trivializing the the estimated row counts to <2 in most cases.  That is...

The real underlying problem here is that you're trying to filter on an aggregated (XML concatenation IS a form of aggregation) column, which is never a good idea and is...

The fact that restarting the web server fixed the problem leads me to believe that the web server is the problem.  It could be connection leaks or memory leaks (the...

My recommendation would be not to use those types of trace flags.  Instead, fix the...

Alan, the migration to the "improved" SSC website has broken all of the links in your signature line.

I tried putting the results in to a variable and selecting the datalenght() of that, I can see that the lenght is longer so I assume it does contain...

've had the same bank account for more than 20 years.  I'd hate to have to wait for them to compute a balance every time.

A balance is one of...

This is in the realm of mathematics and not standards. There is no ANSI/ISO standard for structured programming, RDBMS theory, or anything like that. However, our modern view of...