Gail Shaw - I believe this is one is more geared towards performance on a bigger table having millions of records rather than space constraint. As a matter of fact...

ChrisM@Work (12/15/2016)

---

ffarouqi (12/14/2016)

---

Hi all,

I've been looking into this query and trying to see if there is any better way to write or enhance performance on these queries. Client states that...

pietlinden (12/14/2016)

---

Oh, you neglected to mention that it was a vendor database. Key piece of information.

having said that, the only way I can think of helping this situation out is...

pietlinden (12/14/2016)

---

Is there any way you can split this part of the data into a separate column?

convert(nvarchar,keyvalue) like '%11857548%'

Ideally, you'd want the 11857548 value in a column by itself so...

Thanks! but I need something in tsql. Like a conditional logic.

Grant Fritchey (8/30/2016)

---

You have two different delete statements, each one using a different WHERE clause, but both on the same table. So, first up, what other statements are involved with...

Eirikur Eiriksson (7/9/2016)

---

ffarouqi (7/9/2016)

---

Hi Guys,

I am stuck in a situation where the sliding window job is throwing me an error as such. I am not really sure on how to...

Grant Fritchey (7/6/2016)

---

But you are looking for waits. You have a process that is timing out. That means it's running long. Why is it running long? Well, it's not getting...

Grant Fritchey (7/5/2016)

---

ffarouqi (7/5/2016)

---

Grant Fritchey (7/5/2016)

---

I'd want the specifics on the error message.

If it's getting timed out, that means it's firing, so it's not an issue that it's an...

Grant Fritchey (7/5/2016)

---

I'd want the specifics on the error message.

If it's getting timed out, that means it's firing, so it's not an issue that it's an Agent job, or...

Phil Parkin (7/4/2016)

---

ffarouqi (7/4/2016)

---

Phil Parkin (7/4/2016)

---

ffarouqi (7/4/2016)

---

Hi,

I am not sure if this is a unique issue for me or is it a known issue for others as well. Basically, they...