Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nickcherryjiggz

    Limited By Ports

    I'm currently working on an exercise for a class whose focus is on network storage. The assignment's problem is clear to me, but don't know where to start as far as solutions. If someone could lead me in the right direction and perhaps suggest a technology that might be appropriate for the...
  2. nickcherryjiggz

    Evenly distribute layers, but take into consideration their sizes...

    I know how to distribute a group of layers evenly (link them all together, then press one of the 3 distribute evenly buttons), but I don't always know how to get the result I'm looking for. For example, how would I go about distributing a group of layers (say, 5 or 6 words that will be links on...
  3. nickcherryjiggz

    Hotel Reservation DB Structure

    I was just looking over this site: http://www.tizag.com/mysqlTutorial/mysql-index.php So, aside from optimizing queries, the indexing is as easy as adding something like this, "INDEX (employeeID)" at the creation of the table?
  4. nickcherryjiggz

    Hotel Reservation DB Structure

    I've done some research on optimizing mysql queries (and yes, r937, mysql is what I am using), and I think it's starting to sink in a little bit. I read about an example of indexing surname and firstname, which makes sense to me. I'm having some trouble applying the logic to this particular case...
  5. nickcherryjiggz

    Hotel Reservation DB Structure

    Thanks for the fast response, r937. What exactly do you mean by indexing my foreign keys? RoomNum and CustNum are both integers, and with Date, I'm not exactly sure how I would go about doing that. Or are you just talking about queries with that comment? Sorry if this is a dumb question.
  6. nickcherryjiggz

    Hotel Reservation DB Structure

    Hello there, I'm pretty rusty with SQL (though I never had a great deal of experience to begin with), and I'm having a lot of trouble with slow search speeds of my database. I was hoping someone could tell me what I'm doing wrong as far as the schema goes. The main function of this database...

Part and Inventory Search

Back
Top