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

If you don't include the century, then what is this date?

4/12/49

Assuming this is US (Apr 12), is it 1949 or 2049?

Please also wrap this in a transaction if you're not sure.

select *

from SomeTable

where Auxid = 1219947569

AND Name = 'WALMART T'

and CID = 11987968

begin transaction

Delete from SomeTable

where Auxid = 1219947569

AND...

As mentioned, you cannot restore databases. You could use a copy to move tables, objects, data from one version to the other.

If you are trying to install on the same...

You have the name in the variable you set from the cursor. Use an IF statement to check if it's master and then skip the rest of your loop script.

After crossfit