Glad it's working and thanks for posting what worked for you.

Jeff Moden (4/20/2015)

---

bdenning (4/20/2015)

---

I started to read this article and didn't get past the first paragraph. Why technical people resort to street language to express themselves is beyond me....

The issues are that a lot of the differences may or may not matter depending on how you use the platform. For example, backup compression. Will you run backups (or...

Part of the issue is that the code you alter isn't the object. The object is compiled by SQL Server.

What you really need to do is get all the object...

RonKyle (4/20/2015)

---

...

But the number crunching belongs somewhere else. I have seen first-hand the improvements in performance that comes from moving business logic into the middle tier, and in...

If you want to remove the parens, I'd use the code that's listed above. If you need more reformatting, you might use CHARINDEX/PATINDEX to find them and then SUBTRING things...

Yet Another DBA (4/17/2015)

---

Steve Jones - SSC Editor (4/16/2015)

---

... I've been most wary, and worried, when the changes were out of my control, and I had no chance to review...

That's a good one. I'll submit it and see if we can get this implemented.

It's hard to tell exactly what you are doing or working with. Please look this over for posting help: http://www.sqlservercentral.com/articles/Best+Practices/61537/

What you should do is mock a table and post the...

http://radar.oreilly.com/2015/04/rebooting-a-1970s-satellite-with-modern-software-and-hardware.html

Eric M Russell (4/15/2015)

---

With Remote Desktop, it doesn't matter whether you're doing data analysis or development, it's just a screen scrape of a remote VM session. About the only thing...

Interesting deck from Martin Fowler: http://martinfowler.com/articles/schemaless/

A good reason to have SQL Prompt and just ignore what the formatting is in a VCS.

Eric M Russell (4/15/2015)

---

Walking around with your organization's production data, financial spreadsheets, or work email on your laptop is dumb in an age where VPN is an option and wifi...

Are the updates to a row in batch (lots of rows) or singletons? If it's the latter, I wouldn't worry here. There could be page splitting, but it's relatively few....