Why? That's what the LIKE operator is there for, refusing to use the...

Tune the queries, optimise the indexes or add more hardware.

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Trigger on the table?

Extended events session or server-side trace.

The only thing compatibility mode affects is how the parser and query processor handle certain T-SQL constructs. It doesn't change the database in any way

Smash, it would be really useful if we could see the execution plan of that query, plus any other queries that run frequently against the table. Since we have little...

So you recommend an index on two columns but say that...

Incorrect. See my and Keith's posts above.

Bar a few odd memory leaks I've seen in the past, there's not much that would have me regularly restarting SQL at all.

How often were you monitoring?

Sure that's the best index? A non-covering index that only supports the where clause.

Most installation sets contain all editions. The edition that installs depends on the key that you use during set up. Some installations have the key embedded. To see which you...

Sanjay Thakur-488205 (10/23/2013)

---

Kindly advice the same How to remove/ Delete Transaction Log from SQL Server 2008 R2. as previously we are using SQL Server 2000 Detach database and remove log...

Could you be more specific? Handling what about TempDB?

It's not memory pressure in SQL Server that you have (well, you know you have that already). Something else, outside of SQL, is apparently taking large amounts of memory, so...