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 bkrike 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: *

  • Users: jconner
  • Content: Threads
  • Order by date
  1. jconner

    Calling an executable from code

    Hey guys...sorry for the newbie question here, but I'm wanting to execute the BCP command utility (bcp.exe) from code (VB.NET). The app allows the user to plug in the command line switches and then needs to call the executable. I'll build the command line string with all the switches, but I...
  2. jconner

    Covering indexes question

    If I have an index on 3 columns, and a user submits a query that uses only one of the columns, will SQL Server use the 3 column index or would you have to have an index on the single column alone? We use a lot of covering indexes, but occasionally get queries that use one or two of the columns...
  3. jconner

    How should columns be ordered for performance?

    Is there any particular way that you should order the columns in your tables to enhance performance? I'm guessing that indexed columns should be first, but other than that does it really matter? I was under the impression that SQL Server stored the data it's own way (fixed length data first...
  4. jconner

    Does table order in joins with WHERE clause matter?

    We have a situation where several tables are being joined together...with a few constraints on the query...and I was wondering whether or not the order in which the tables are joined mattered as far as the where clause is concerned. In other words, if I'm joining TABLE_A - TABLE B - TABLE C -...

Part and Inventory Search

Back
Top