All right, everyone. I think now is a good time to back away from this thread. Obviously there's been several misinterpretations of who has posted what and what those posts...

I foresee that question being asked again in the very near future.

😉

Huh. That looks interesting. Thank you. I'll give it a shot.

jasona.work (10/26/2016)

---

Phil Parkin (10/26/2016)

---

HanShi (10/26/2016)

---

The problem is...

Jeff Moden (10/26/2016)

---

Brandie Tarvin (10/25/2016)

---

I don't know if this is true of all dedup technology, but...

<headdesk>

I don't know whether to cry about the problem or sing praise that someone finally got it.

A dev has a ticket to improve a process he wrote. I got involved...

jasona.work (10/25/2016)

---

So this ought to be fun...

Dev asked me to take a look at a view that isn't performing as well as it did on the system it used to...

This fits best in SSRS since you say it's an SSRS post.

Everyone please respond to this link instead of here: http://www.sqlservercentral.com/Forums/Topic1828200-150-1.aspx

If by info you mean data, yes. But there's nothing any of us can do about it.

trangen1 (10/25/2016)

---

what do you mean????? "The code below clears the Local Servers Group completely (be aware of this),"???

can I run it without this clearing of the LSG????

'dir -Recurse | Remove-Item...

I don't know if this is true of all dedup technology, but the stuff we use...

BLandry474 (10/21/2016)

---

My apologies Brandi - you're right - you did say that in your edit. However, you also just addressed constraining the columns entry when I asked a very...

BLandry474 (10/21/2016)

---

My thanks to all who responded, but please, in the future, read the question - I DID NOT say "Users are entering data", what I said was "We get...

Okay. Maybe it was the checks that screwed me up the last time I tried.

Thanks for the verification. I appreciate it.

HanShi (10/21/2016)

---

Eric M Russell (10/20/2016)

---

So, you're saying that the users are entering values that are considered invalid due to their excessive length? You can avoid this by implementing check constraints...