Essentially, when you install a second instance of SQL, it's (almost) completely stand-alone. Both instances will have their own TEMPDB, Master, MSDB, and Model databases, each instance will be running...

The problem is that the Tempdb incident has happened a while ago and no one knows any details and I wasn't involved. It has lead to the dedicated instance req...

No restart required. I've done it many times via management studio, memory tab of instance properties. After entering a max value and clicking ok you can see the used memory...

Thank you for your replies.

@Gail: your link supplies the complete answer. Indeed the issue is catch all queries. One of our tools has customizable search forms with search fields. If...

No there are no specific performance issues that trigger the discussion. We have recently been analyzing performance from a broad perspective where we have done some changes mainly concerning indexes...

Thanks for the reply.

I thought that the text of a query was part of the key of a plan. These queries have hardcoded values and show as such via dm_exec_query_text...

I've changed the text to normal font, still getting used to the font sizes.

I did some more research and found some remarks that for the recompile hint the plan is...

I was reluctant to post this since it is quite complex. Query below is the slow one with the recompile hint commented and some comment that would force recompilation of...

The date format I can understand but why would granting sysadmin without changing the language make the query perform better? Is there a date format for the sysadmin role that...

For me Fritchey's book was a good start. In practice I use the nr of reads together with exec plans a lot. Before running a query, set statistics io and...

My goal was to find out if such a conversion would benefit performance enough to consider it. But given the comments my view is that there is not enough reason...

Thanks for your answers and indeed this application was designed on Oracle originally. There are numerous instances of this database around ranging from 10G to 50G (but still growing) so...