The key words in that message are "warning" (not "error") and "may" (not "will").

Every plan that uses type conversions, either implicit or explicit, will show that warning. Check where the...

Eirikur Eiriksson (3/29/2016)

---

Quick thought, the first (union) query will use two index seek operators (if the correct indices are in place) while the latter does a single scan. If the...

This result means that at least one transaction in the database is open (neither committed or rolled back), and SQL Server cannot release log records until it knows whether this...

Deep

The error itself is not from SQL Server. But it can be an application error in response to a SQL Server error.

You can use an extended events session to monitor...

Please read http://www.karaszi.com/sqlserver/info_dont_shrink.asp.

As the URL suggests, most of this article is a discussion on why you should be careful before shrinking a data or log file. However, it also explains...

... but beware...

Hi Charmer,

A CROSS JOIN, also known as a Cartesian product, is a join type that has no ON clause. It instructs SQL Server to combine every row from the first...

It is always hard to get started in a career. Many employers ask for real-world job experience, which you can only get by being emplyed. A devil's circle. The only...

The code below will give you today's date, the first day of the current month, and the first day of the two following months. I am sure you can figure...

Sachin Nandanwar (3/25/2016)

---

...WHERE NOT EXISTS (

SELECT EmployeeID

FROM budCrewDetail

WHERE budCrewDetail.Co = JCDET.JCCo

AND budCrewDetail.Project = JCDET.Job

AND budCrewDetail.[Date] = JCDET.ActualDate....

Negation operators like NOT are nonsargable expressions.An index is not useful in nonsargable expressions.SQL...

Mostly: What Grant says: we need execution plans (actual execution plans, posted as sa .sqlplan file attachment) for the fast query as well as for the slow query, plus of...

Poetry

Luis Cazares (3/24/2016)

---

Sean Lange (3/24/2016)

---

ChrisM@Work (3/24/2016)

---

Sean Lange (3/24/2016)

---

--I posted in another thread by accident a couple of days ago--

Thank you Mr. Moden. Another interview cut short with the simple "Name...

GilaMonster (3/24/2016)

---

Grant Fritchey (3/24/2016)

---

Hugo Kornelis (3/23/2016)

---

In almost 20 years of working with SQL Server, I have only once used an index hint in a production query, and that was after...