Viewing 15 posts - 526 through 540 (of 920 total)
You can only have one declared primary key for a table, which can enforce uniqueness and build a clustered index that will store the data in order by the primary...
June 15, 2009 at 5:19 pm
So why construct the ID in the first place instead of just using the user id and datetime entered as the columns of a primary key ( or just an...
June 15, 2009 at 4:01 pm
Yes, and your articles do a wonderful job of outlining the necessary structure and processing requirements. Those are far easier to live with than the requirements around keeping multiple...
June 8, 2009 at 5:44 pm
Why not put everyone in the same DB and key everything on customer?
If you have a lot of customers, the management overhead of the design you are proposing becomes pretty...
June 8, 2009 at 4:32 pm
Is there a chance that the full backup procedure does an explicit truncate on the log at some point after the backup is taken? It would invalidate the use...
June 4, 2009 at 9:58 am
What's the name of the database in which the table resides? I'm not familiar with any table in the system databases called "status". If it's not in one of...
May 28, 2009 at 2:20 pm
Can you copy all the data into a staging table first, and then run whatever validations you need to against that data before moving it into the 'real' table?
May 27, 2009 at 4:30 pm
Lynn Pettis (5/27/2009)
May 27, 2009 at 4:13 pm
You don't need no steeenking special keyboard to write APL.
May 7, 2009 at 3:26 pm
I'd encourage you to read the BOL information about the FLOAT data type before you change the table. Pay careful attention to the fact that it is an approximate...
May 6, 2009 at 11:27 am
I got $10 that says he deleted the table and believes he can recreate it from the views.
May 4, 2009 at 3:30 pm
Yes. I saw it 5 times during the next two weeks and saw some new detail I had missed on the times before. Bought the soundtrack as soon...
April 29, 2009 at 3:55 pm
Sorry, I don't know enough about Access itself to help with that.
I do know that some adddtional tuning of queries and indexes may be necessary if performance is not as...
April 27, 2009 at 10:51 am
Please forgive me if this is too elementary, I just don't want to make any assumptions about what you would do as a matter of course.
1. Regression test against the...
April 27, 2009 at 9:48 am
Thread Nine from Outer Space?
or wasn't "thread" the stuff that fell on Pern, destroyed all life it encountered, and was only thwarted by fire breathing dragons?
April 16, 2009 at 1:34 pm
Viewing 15 posts - 526 through 540 (of 920 total)