<div>
first you need to make sure that you have proper indexes on these columns <br />
Product ON igmsi.ISBN, Product.ISBN , Product.Producttype
</div>


first you need to make sure that you have proper indexes on these columns
Product ON igmsi.ISBN, Product.ISBN , Product.Producttype

<div>
Hi there,<br />
<br />
Will indexing be useful if the Product Stock file keeps changing? I receive a new product file in ASCII txt format daily and I generally will truncate the Product Stock table before inserting the new full data.<br />
<br />
I also need some help on how indexing works. Thank you.
</div>


Hi there,

Will indexing be useful if the Product Stock file keeps changing? I receive a new product file in ASCII txt format daily and I generally will truncate the Product Stock table before inserting the new full data.

I also need some help on how indexing works. Thank you.

<div>
Thanks for the advice and direction. I will have to work out the indexing and try it for myself.
</div>


Thanks for the advice and direction. I will have to work out the indexing and try it for myself.

<div>
<div class="content wysiwyg-content">
Hi there,<br />
<br />
I have two major tables:<br />
Product Stock Levels = 2.3m rows<br />
Product = 4.2m rows<br />
<br />
It takes about 2hr 15 mins to run this Stored Procedure below and complete. I need some assistance to how I can improve this update to be shortened? I understand that JOINS can be written as OUTER AND INNER JOIN OR LEFT JOIN. Can anyone help to clarify?<br />
<br />
Thank you.<br />
<br />
UPDATE Product SET<br />
StockLevel = 1,<br />
DisabledFlag = 0,<br />
PriceAmt = CAST(igmsi.PublisherPrice AS MONEY)/100,<br />
DiscountPercent=CASE WHEN PriceAmt&gt;14.90 THEN 20 ELSE 15 END<br />
From Stock_update.dbo.Product_S<wbr />tock_Updat<wbr />e igmsi<br />
JOIN Product ON igmsi.ISBN=Product.ISBN<br />
Where Product.Producttype='Books<wbr />'
</div>
</div>


Hi there,

I have two major tables:
Product Stock Levels = 2.3m rows
Product = 4.2m rows

It takes about 2hr 15 mins to run this Stored Procedure below and complete. I need some assistance to how I can improve this update to be shortened? I understand that JOINS can be written as OUTER AND INNER JOIN OR LEFT JOIN. Can anyone help to clarify?

Thank you.

UPDATE Product SET
StockLevel = 1,
DisabledFlag = 0,
PriceAmt = CAST(igmsi.PublisherPrice AS MONEY)/100,
DiscountPercent=CASE WHEN PriceAmt>14.90 THEN 20 ELSE 15 END
From Stock_update.dbo.Product_Stock_Update igmsi
JOIN Product ON igmsi.ISBN=Product.ISBN
Where Product.Producttype='Books'

How to reduce update time?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.