danke

thanks for the link!

sorry if this is the wrong forum to post this in...please direct me to the correct one if I'm in error fairly new to c# asp.net web development...want to know if anyone has a couple of url links that i can go to, to download some free web site templates for c#...i don't really have a css design eye...if they are also seo friendly, that's a bonus too. thanks

maybe in need 2 go back to the basics...can anyone give me a link or two of a basic tutorial that talks about optimization...i always put indexes on Where or Order By fields if I am doing joins on the Where, and if I think the tables are going to have a huge number of records. also, a simple tutorial link about the Query Optimizer and how to use it would be great too. Thanks!

I am not joining on the BookTitle field...I just wasn't sure if Count needed BookTitle to be Indexed when it aggregates the count command. I will leave BookTitle un-indexed, thanks!

really gives us novices a great place to post our beginner questions: SELECT COUNT(BookTitle) FROM Book WHERE IsFiction = 1; I am Indexing the IsFiction field, but not sure if I should be Indexing the BookTitle field too? Any expert thoughts? Thanks again!

KEWL, i learned something new, that foreign keys automatically get indexed for me.

CREATE TABLE [PreferenceType] ( [PreferenceTypeId] [BIGINT] IDENTITY (1,1) NOT NULL, [LongName] [NVARCHAR](500), [ShortName] [NVARCHAR](250) ); CREATE TABLE [Table2] ( [Table2Id] [BIGINT] IDENTITY (1,1) NOT NULL, [PreferenceTypeId] [INT] ) Given the Preference Lookup table above, if I do an Inner Join to Table2 on the PreferenceTypeId field, I should index like this: CREATE INDEX [PreferenceTypeId_Idx] ON [Table2]([PreferenceTypeId]); <--- good? But I shouldn't index like this: CREATE INDEX [PreferenceTypeId2_Idx] ON [PreferenceType]([PreferenceTypeId]); <--- bad? because Primary Key fields should already be indexed, correct?

multi language benefit, but space cost...got it, thanks!

Sorry in advanced for a duplicate question or a really basic question, but is nvarchar better than varchar? Is there an advantage for nvarchar? I've always just used varchar. Thanks!

That makes sense. Good info, ty.

Thank you. Just double checking.

If I do something like: Update Field1=something1, Field2=something2 Where Field3=123; I always index Field3, but I'm not sure if I need to index Field1 and Field2 too? Thanks!

55 is excluded because it has a link of 4 and 5...and 77 is excluded because it has a link of 4 in it. Table1 --------------- Field1 -Field2 3 -55 3 -55 4 -55 5 -55 3 -66 3 -66 3 -77 4 -77 3 -88 Table2 --------------- Field1 -Field2 3 -9 4 -10 5 -11

Thank you, but I don't want to hard code the 66 and 88 as those values I constantly changing. I just wanted those records as they don't have other linking fields of the 4 and 5 for example.

This is probably easy...I am just brain dead...I am using Ms Sql 2008, and given the following two tables: Table1 --------------- Field1 Field2 3 55 3 55 4 55 5 55 3 66 3 66 3 77 4 77 3 88 Table2 --------------- Field1 Field2 3 9 4 10 5 11 Table1 and Table2 are linked together by the Field1's...I get a parameter passed in like "9" for Table2's Field2...how do I return all of the records from Table1 of just the 66's and the one record of 88?

clarification for #2: yes that's exactly what I want to do. I don't think it's possible though, just not sure. on point #1, I don't think that works as I have tried that already, but if you get it to work, I'd love to see some code examples. Thanks!

Hey I wanted to pose a couple of newbie questions. Sorry in advanced if they have already been asked in this forum, and thanks in advanced for those who volunteer or otherwise answer these types of questions. I know how the answer people can sometimes feel like their answers and efforts aren't appreciated by dummies, and can get jaded as a result. Anyway, here are my questions: 1. I have a design or achitecture question. I want users to upload files to a shared mapped file drive, call it the "z:" drive where they can upload images or videos. I already have the code that will upload the images and such. But now I want serve those images or videos without physically moving/copying them to my server directory...I can't figure out how to do that as the absolute or relative path. Can anyone help me by providing a download url that has sample code that can do this? or point me in the right direction with some tutorial urls of what I'm looking for? 2. Last question (do I need to post this in a separate post? - that's not the question :)). I would like have one .aspx affect a different .aspx page for seo reasons. Is there any way to do it programmatically? So I don't have to keep changing the page and then republishing to the web server? If so, any tutorials with sample code to do so? Thanks!