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...

Lins,

I think you misunderstand what Grant meant by cross-database querying.

If you separate out...

jasona.work (10/20/2016)

---

Brandie Tarvin (10/20/2016)

---

jasona.work (10/20/2016)

---

Brandie Tarvin (10/20/2016)

---

I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One is...

Luis Cazares (10/20/2016)

---

mister.magoo (10/20/2016)

---

I was wondering whether all this complexity is worth it...just to run a dtsx? But I'm not a DBA, so I assume this is a small part...

jasona.work (10/20/2016)

---

Brandie Tarvin (10/20/2016)

---

I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One is ~134GB of data,...

jasona.work (10/20/2016)

---

Brandie Tarvin (10/20/2016)

---

On a fun note, my past 24 hours has been taken up by an AG issue which has caused one secondary replica not to synchronize, which caused...

lindsayscott23 (10/20/2016)

---

...our workflow goes like this:

Build in Dev

Unit Test in Dev (this is done by the developers)

Add to appropriate folder in TFS (we have monthly releases and each release folder...