djj (8/24/2015)

---

GilaMonster (8/24/2015)

---

I think it's in anticipation of my Star Wars RPG tonight. The puny resistance movement will be crushed under the might of the Imperial Army. The Emperor has...

You need Windbg (the windows debugger), the public symbols files for the version of SQL, and a good amount of internals knowledge (windows and SQL)

Welcome to a few thousand pages into a thread which is more a general chat thread than anything else these days.

A negative one usually, due to the lack of statistics.

Could you look at the table and find out? Or would you prefer I guess as to the appropriate data type and give you a query that could throw more...

That's what I suspected. What...

It's preferable to do explicit conversions.

What's the range of values in that column (10? 100? 1000? 100000?), and are there any non-numeric values?

I think it's in anticipation of my Star Wars RPG tonight. The puny resistance movement will be crushed under the might of the Imperial Army. The Emperor has foreseen it!

Any time you're debugging an order problem, put the column that you're ordering by into the select.

select top 100 GroupId, count(HouseId), max([DateCreated])

from House h

group by h.GroupId

order by max([DateCreated]) desc

If you...

Take each column in the query, look at the base table and check the data type. Identify where you're comparing a varchar to a number, or doing any form of...

Check your query, see where you're trying to convert a varchar to a numeric value. See what types are involved.

If you're getting NULL, either labels.BAGSDISP is NULL or parts.ndc is equal to something other than the literal. There's no ELSE clause of the CASE, so if there's no match,...

SSMS 2012 tends to throw odd errors intermittently when connected to a SQL 2014 server. I had ignorable errors show up any time I right-clicked on anything in object explorer.

These would be for when I'm working on client systems.

In no particular order:

SELECT * FROM sys.dm_exec_requests er CROSS APPLY sys.dm_exec_sql_text(er.sql_handle) st;

SELECT TOP(1000) * FROM sys.dm_exec_query_stats qs

CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle)...

Err, what's the question here?