Jacob Wilkins (2/18/2014)

---

When the log is growing, check the log_reuse_wait_desc for the msdb database in sys.databases. That should help narrow things down.

If it shows there's an active transaction, you...

Jeff Moden (2/18/2014)

---

IIRC correctly, there was a bug that cause this behaviour depending on the INITIAL SIZE and GrOWTH SETTINGS of a database in SQL Server 2005. I believe...

langouste

Yeah that can be a bit misleading. The primary filegroup can't...

TomThomson (2/18/2014)

---

Koen Verbeeck (2/18/2014)

---

Hany Helmy (2/18/2014)

---

Just a simple & basic info to share: "if you changed the model database to Read-Only mode; then any newly created database will be in...

Do you have any other reason to believe you have/had a memory issue?

Gary Varga (2/18/2014)

---

paul.knibbs (2/18/2014)

---

SQLRNNR (2/17/2014)

---

That needs to be underscored. No matter the system, there is a weakest...

What is your goal in trying to filter by somebody's First name?

Do you have sample data and table definitions to help solve this problem you are running into?

That needs to be underscored. No matter the system, there is a weakest link. Every network...

FWIW = "For What it's Worth"

If you want to filter for First Name, then you need to use [lev].[stringValue] in your where clause.

Thanks for the question.

Good to hear and glad you have a solution.

Did you have service broker enabled?

It also sounds like maybe somebody had created a table and kept inserting tons of records into it. Find what table is the largest...

try this and see if it works

SELECT *

FROM abc a1

INNER JOIN abc a2

ON a1.id = a2.id

AND a1.enterdate = a2.enterdate+1

AND a1.stat = a2.stat

WHERE a1.stat = 'Live'

AND a1.typo <> a2.typo;