Tip Bank

Question: What are the advantages/disadvantages of putting large binary files (1+ MB) in BLOB columns versus storing them on a file server with a reference such as a directory/file spec

Question: I am trying to write a report that will bring back fiveindividual pieces of data that are stored within the same column in a table. How do I do

Question: Is there a way to send mail with a mouse click? I’m working on a Mac and in Windows. Answer: You can send mail, or do virtually anything else

Question: I want to be able to take an action when a user changes the value of a data field, but not when the value of the field is changed

Question: I’ve got a “new user” question for you. Some of the tables in our databaseshave several columns containing data that’s not used very often. When I’musing ad-hoc queries, it

Question: I have nine offices. I want each office to connect across aWAN and run client/server applications with all datacontained on one central server. However, we are finding the delays

Question: How do I create a column with a row ID that adjusts if a row is deleted?That is, if I had numbers 1,2,3,4,5,6 and I delete record 3, record

Question: Our business is just starting to look at using a relational databasemanagement system. We are currently using computers, but the usershave their own copies of whatever data they need

Question: I need to query a database with outer joins on more thanone table, and am finding that my database doesn’t support it.Is there any way to work around the