Thanks for this nice suggestion. Really, this would be worth thinking and applying. Thanks And Regards, Ashish Patel
Use <your database> and then try using EXEC sp_changedbowner 'sa' Thanks And Regards, Ashish Patel
So suppose, take it that i have a Table with 200 million records having a Primary Key with Clustered Index, and on weekly basis i keep adding new...
Do the view created on tables use the indexes applied on those tables. Consider 4 tables having Primary Key with Clustered Indexes, and if a view...
Even frank thanks a lot for the last linkhttp://www.aspfaq.com/etiquette.asp?id=5006 which is for sure very usefull. Ashish Patel (Programmer)...
Sorry Frank and Jatin, i was bit away due to work, but ofcourse i found those link very usefull and they thou made my concepts more clear on the...
Yes, i also agree with you frank that the physical order is not my priority now, as select statement never would give the results depending on how...
Actually, I had a master table and from which i use to create another table consisting with some few records out from that IN the order selected by...
But what happens if i do a select into like, Select Col1, Col2, Col3 into NewTable From OldTable Order By Col1, Col2, Col3 And THEN ADD an identity...
If a new table is created from a select statement, than would the physical order of the data in new table remain the same of select statement. for...
Thanks for your suggestions and replies, Sorry for beig away on this weekend. Well, over night re-indexing is what currently we are doing on this...
I have a huge table with 10-20 million records, with around 20 indexes including Cluster Indexes and Not-Cluster Indexes on multiple columns...
SELECT t2.x,t2.a,t1.b,t1.c,t2.d,t2.e,t2.f into t3 FROM table2 t2 LEFT JOIN table1 t1 on t2.a=t1.a This worked very excellently for me for the...
Definately Sir, I have started using the SQL index tuning and it also recomended me the same approach which Mr. Dave has derived above. I appriciate...
Thanks Mr. Luis, as ur reply also made a very important contribution to increase my knowledge in SQL Server, and hope combining ur's and Mr. Daves...
Thanks Mr. Dave Hilditch for ur reply. I am able to make unique cluster indexes on table 1. Let me try doing this, and i would definately get back to...
Mr. Luis, I am very new to SQL Server, and i dont know its sql basics, as i come from Oracle, but can u please say me what would u suggest if u have...
Sorry forgot to say that there is no index on the table1. -Ashish
I have indexes on some other field in table2 lets say x field of table2 and the index is non-clustered. And yes, this is being done on regular basis,...
I have two tables in MS SQL SERVER, as following 1. Table1 with 1000 Records with three fields a, b and c 2. Table2 with 13+ Million Records with...
Separate names with a comma.
