Viewing 15 posts - 46 through 60 (of 1,221 total)
Jacob Wilkins (5/10/2016)
Wayne West (5/10/2016)
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
May 10, 2016 at 11:57 am
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...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
May 10, 2016 at 9:24 am
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...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
May 10, 2016 at 8:45 am
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...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
May 6, 2016 at 12:38 pm
SQLRNNR (5/6/2016)
Oy vey, I missed the choose 2 somehow. Oh well. Otherwise, it is a straight forward question and I must have missed all the commotion about it being wrong.
I...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
May 6, 2016 at 12:24 pm
xsevensinzx (5/6/2016)
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
May 6, 2016 at 11:06 am
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...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
May 5, 2016 at 1:51 pm
johnwalker10 (5/3/2016)
2.Select database objects. Click Next
3.Click Advanced and scroll down to 'Types of Data to script' and choose 'Schema and Data'....
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
May 5, 2016 at 9:32 am
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...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
May 5, 2016 at 8:35 am
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...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
May 4, 2016 at 9:54 am
(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...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
May 3, 2016 at 9:02 am
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...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
April 28, 2016 at 4:22 pm
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...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
April 26, 2016 at 7:56 am
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.
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
April 25, 2016 at 11:26 am
Lynn Pettis (4/22/2016)
Wayne West (4/22/2016)
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
April 25, 2016 at 8:15 am
Viewing 15 posts - 46 through 60 (of 1,221 total)