Recent content by jconner

I purchased my Universal MSDN from a guy on eBay and have had absolutely no problems with it. I paid $899 for it and then got a &300 rebate for getting it on DVD. The guy I purchased it from had a strong rating and many previous customers, and he set it up for me and everything rocked! I got...

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...

Thanks for the info! That helps a lot...exactly the info I needed! On the last part, about the columns in the where clause needing to be in the same order as the index - I thought the optimizer would hanlde that? I'll look to see if I can confirm what you said about that. Thanks for your help!

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...

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...

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 -...