Sorry for delay in providing required information, as mentioned by Frank for me it took bit extra time to get details from customer. Also honestly...
Having 2TB OLTP database look strange, but it is reality, one of our customer database having 2 years of data. And because of large data size the...
quote:Originally posted by Madhivanan Refer this http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9391 Madhivanan Failing to plan is...
We have 4-5 tables and those are having around 15-20 indexes few of them may be not in use, but don't know how to find out those. Is there any way...
Logical Unit Number (LUN) http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_asphosting.asp Surendra Kalekar
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
quote:Originally posted by Adriaan Hm, the trick would have to be outside of the trigger ... well, as long as you're doing this with an sp: Create...
Find out whether your all quries are using proper indexs. To avoid the recomilation of your sp use the stapes suggested by ranjit. Surendra...
quote:Originally posted by pallavi Hi Madhivanan the source table is having Equip(companyname, Equipid, Equipcode, Name, Position, group, Model,...
quote:Originally posted by Adriaan Hm that is weird ... create table dbo.test (id INT, txt TEXT) go create trigger tr_updt on dbo.test for update as...
Hi Adriaan, It is inserting record into table eventhough it is not updated. IF @FieldName = 'BDescription' Begin If UPDATE(BDescription) Begin...
We are doing field level auditing on company table. If the field value is updated then we are inserting new row into CompanyTrack table with their...
Sorry for again opening this topic.... Brad, If both the forum#%92s have the same interface software can't you add a feature to show topic of post in...
Hi Surya, Can you post your modified code? Surendra Kalekar
Thanks Surendra Kalekar
Inserting into temp table will not increase the performance. Try to use subquery for those tables which is having less records. or You can try the...
My experience in exporting data from one database to another is totally different. Instead of using SP I will use DTS package. Surendra Kalekar
Let me know if you have experienced any performance/other problems while accepting the text field as input parameter in stored procedure. I have to...
quote:Originally posted by Adriaan You went totally overboard - all the subqueries are faking a JOIN that is missing in the main query. Yes...
mmarovic, Actually we have both one on CompanyID and another is CompanyID, DatePub (but this is in asc order) and we need both for the other sp's....
Separate names with a comma.
