Jeffrey Williams (6/2/2009)

---

Gail, I really don't want to argue this point - but I am having a small problem here. I have a query where I use this construct...

TheSQLGuru (6/2/2009)

---

Interesting. You also get a seek if you simply hard code values for coalesce (and I presume isnull) such as this example. It avoids having to hit...

I feel like I'm talking to a brick wall here.

http://www.sqlservercentral.com/Forums/FindPost727250.aspx

Why do people keep defending that query form even in the face of evidence that it performs terribly?

Could be bad estimates. Haven't checked exec plans in detail. Check that the statistics are up to date (maybe do an update with full scan). If not, go with the...

Yes.

It does not (and cannot) use indexes properly. Table scans are not much fun on million+ row tables.

Parameter sniffing?

http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic727464-19-1.aspx

Holger, does this query return anything? If so, try a drop statistics with the name returned and see if that fixes the problem. Absolutely no promises.

select object_name(object_id), name, stats_id from...

Only the connection that created them can drop them or query them.

See if you can query sys.dm_db_index_physical_stats for all the tables in TempDB. That might give you the page...

Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

I've got bad memories of a very arrogant American couple that I ran into (not literally) in Grahamstown while I was a student there. They were finding fault with everything,...

I have a lot, lot more rows - 962662. Not due to MS. I padded out my copy of AW last year for my PASS presentation. Query time differences weren't...

Parameters in sp_executesql are only allowed in the places they're allowed in normal SQL. If you want the table name to be a variable, you'll have to concatenate that value...

That's not a particularly good idea. There's a fair bit of stuff in master that's specific to the machine it was built on. Taking...

Are you trying to restore a master database from a different server?