InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 22:46:52 GMT20http://www.sqlservercentral.com/Forums/Topic986853-146-1.aspxI am not disputing that. I agree that people have to learn the trade and pointing them to that is great. I was mearly stating that most developers will post a question when really stuck, and wording I found is mostly the problem. The forums is absolutely fantastic, I was just reading that and I thought wow, if you look at the other two posts it was actually to a link and the other some sort of useful syntax layout. Anyways don't wanna get tied up in this, was more a personal comment than anything else.Fri, 06 Jul 2012 03:06:26 GMTjaco-1011483http://www.sqlservercentral.com/Forums/Topic986853-146-1.aspxYou wont be able to create a clustered index on them two columns as your primary key is already clustered.You would first need to drop your primary key and re-create it as a nonclustered primary key which will then allow you to create a clustered index on the other two fields.@Jaco-1011483While I totally appreciate your comments, but how is us giving the OP the solution helping the OP learn the trade?If the OP had come and said,[i]Hi I have read such and such a page in BOL but I cant seem to figure it out please could you help me with X Y Z[/i]Then the OP might of got a different responce, there are plenty of good articles on this site and by using a search engine of your choice, all we ask is that you help us to help you, we will point you to BOL for the basics like this as its better to do it yourself than for us to give you a solution which you maynot understand, in which case how does that help the OP or us.Fri, 06 Jul 2012 02:57:18 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic986853-146-1.aspxI find this absolutely amazing that people will tell you on a forum, that you should read the online books, I fully agree that peeps should put little effort in in solving their issues but if they went throught the trouble of posting a question here:a. try answer it, b. link it to an answer that helped you, but dont give comment as to read the books. PLEASE.Fri, 06 Jul 2012 02:14:36 GMTjaco-1011483http://www.sqlservercentral.com/Forums/Topic986853-146-1.aspxPlease try this. This is just a basic definitionUse <Db_name>GoCREATE CLUSTERED INDEX CIX_Job_Id_Property_idON [dbo].[Valuation_Common]( job_id, property_id);GO Thank You,Best Regards,SQLBuddyThu, 16 Sep 2010 10:51:04 GMTsqlbuddy123http://www.sqlservercentral.com/Forums/Topic986853-146-1.aspxI think that [url=http://www.lmgtfy.com/?q=create+index][u]this link[/u][/url] will tell you pretty much everything you need to know to create indexes.Wed, 15 Sep 2010 23:40:09 GMTWayneShttp://www.sqlservercentral.com/Forums/Topic986853-146-1.aspxI recommend you do a little reading in Books On Line, or Google this as there are a lot of examples on how to do this.CheersLeoWed, 15 Sep 2010 20:33:21 GMTLeo.Millerhttp://www.sqlservercentral.com/Forums/Topic986853-146-1.aspxHi I have a Table (Below) where i need to create indexes (non-unique,clustered) on columns job_id,property_id can some one help me in doing so ,Thanks in advance :)CREATE TABLE [dbo].[Valuation_Common]( [Valuation_common_id] [int] NOT NULL, [job_id] [int] NOT NULL, [property_id] [varchar](20) NULL, [external_value_id] [int] NULL, [internal_value_id] [int] NULL, [external_value_date] [datetime] NULL, [external_value_quick_sale] [money] NULL, [external_value_normal] [money] NULL, [external_value_repaired] [money] NULL, [estimated_repair_amount] [money] NULL, [mkt_time] [int] NULL, [order_date] [datetime] NULL, [order_uid] [varchar](20) NULL, [due_date] [datetime] NULL, [receive_date] [datetime] NULL, [fee] [money] NULL, [property_condition] [int] NULL, [footage] [int] NULL, [age] [int] NULL, [valuation_type] [varchar](5) NULL, [Stated_Val] [money] NULL, [ext_val_delay_code] [varchar](5) NULL, [external_prop_class] [varchar](2) NULL,PRIMARY KEY CLUSTERED ( [Valuation_common_id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]Wed, 15 Sep 2010 20:12:18 GMTRamSteve