Jacob Wilkins (5/10/2016)

---

Wayne West (5/10/2016)

---

I found it very interesting reading up on Vardecimal. The systems that I typically use rarely use decimal, much less a large number of such...

The only certainty is that when it comes to predicting the future, there's no certainty. The current plan for my wife and me is that my wife has another...

I found it very interesting reading up on Vardecimal. The systems that I typically use rarely use decimal, much less a large number of such fields that could benefit...

VMs, as Lowell said, are an excellent tool for learning like this. Make one, patch it, install SQL, patch it, then copy the VM so you have a master...

I...

xsevensinzx (5/6/2016)

---

Being no one has mentioned it yet, if you do transfer, note the bandwidth usage if applicable. We had multiple lines and we dedicated a full line/circuit to the...

For my particular application, the audit is stored in its own database. I don't expect a lot of insert volume in my production DB, and both compress very well...

johnwalker10 (5/3/2016)

---

1.Right-click on Database -> select 'Tasks' -> select 'Generate Scripts'

2.Select database objects. Click Next

3.Click Advanced and scroll down to 'Types of Data to script' and choose 'Schema and Data'....

Good points. My biggest table has 66 columns (all the other active tables have a very small column count), but even when I was inserting 600 records through a...

Wow. 4 minutes for an update with an audit? I notice zero delay with Pop Rivett's audit trigger. The big problem with auditing through the front end...

(looks like the newsletter is delayed today)

The key is calibrating the answer to the asker. Explaining what I do to my Mom is different than explaining it to my new...

I do my auditing via Pop Rivett's article on Simple-Talk. It records the before and after values of each field change, one value pair per record. I have...

Yeah, I had a problem in the URL which I thought I'd fixed yesterday, turned out my fix was incomplete. It should now be good. That's what I...

Is this a one-shot import or something that will be recurring? Some people would argue that 150 columns is awfully wide and could benefit from normalization.

Lynn Pettis (4/22/2016)

---

Wayne West (4/22/2016)

---

I have a number of files from 20+ years ago that I'd like to recover that were written in a long-gone word processor, Borland's Sprint. ...