It is because of your aggregate function (SUM).  Once you put in an aggregate function, you NEED to group by all non-aggregate columns that are in use.  Otherwise SQL has...

Another thought is it could be parameter sniffing problem too.  If user A passes in 'hello' as a parameter and user B passes in 'world', it could be that the...

That is a good point Grant and Fredrico.  Optimizing a 2 ms query that is run once per year is wasted effort.  Optimizing it when it is run 100's of...

As ratbak noted - Cursors are slow.  Cursors work on a row by row basis rather than on the set of data.  The more rows you have, the slower the...

I am just thinking if you have Python in SQL Server (can't remember if 2012 had that or not, but thinking it MAY have been a newer version that first...

To add to what Grant said, is there a reason you NEED that to be dynamic SQL?  Quick look through it I don't see any reason for that to be...

Maybe I'm a bit unfamiliar with that level of XML, but to me that looks like it is XML that is expected to be read by a specific tool (svg?).

From...

Pretty sure you are going to be looking at parsing the XML to get the signature.  You can do this with TSQL (which is where i would start).  Once you...

I am sure there are a lot of ways, but my approach is to check each individually.

Perfmon will tell you quite nicely how much CPU  SQL Server is using compared...

I think this falls under an "it depends" scenario.  If the users are logging in with a generic account and that is all the information that SQL Server has, then...

Try changing the SQL Server Agent startup type to "automatic (delayed start)" to make it start after SQL Server.

I personally have never needed to do that, but I have with...

I personally don't know MySQL, but I think it really depends.  To change the order of the columns, you change the order of them in your SELECT.  For example, if...

I like Jeff's approach here, but my preference when moving large amounts of data from table A to table B on a different database is to do it outside of...

I do not know of any forum similar to this for MySQL.  I do not use MySQL myself.

But I think your query for the most part should translate between the...

The worst part about the tools is licensing.  That is such a pain in the butt.  MSDN (visual studio subscription I think is the new name) is a GREAT example...