English Boards > Support

Workperiod Report Error

<< < (2/2)

emre:
You'll expand Tables > dbo.TicketItems > Indexes node to display existing indexes for TicketItems table..

emre:
... and nothing to worry about printjobdata. It holds how many times a print job executed.

evail:
only "PK__TicketItems__0000000000000146" is there within the indexes.

emre:
CREATE NONCLUSTERED INDEX IDX_TicketItems_All ON TicketItems (TicketId) INCLUDE (Id,MenuItemId,MenuItemName,PortionName,Price,CurrencyCode,Quantity,PortionCount,Locked,Voided,ReasonId,Gifted,OrderNumber,CreatingUserId,CreatedDateTime,ModifiedUserId,ModifiedDateTime,PriceTag,Tag,DepartmentId,VatRate,VatAmount,VatTemplateId,VatIncluded)

CREATE NONCLUSTERED INDEX IDX_TicketItemProperties_All ON TicketItemProperties (TicketItemId) INCLUDE (Id,Name,PropertyPrice_CurrencyCode,PropertyPrice_Amount,PropertyGroupId,Quantity,MenuItemId,PortionName,CalculateWithParentPrice,VatAmount)

CREATE NONCLUSTERED INDEX IDX_Payments_All ON Payments (Ticket_Id) INCLUDE (Id,Amount,Date,PaymentType,UserId,DepartmentId)

You can use these three sql scripts to create missing indexes.

Normally we create them automatically but since SQL Compact does not support nonclustered indexes people who switches from SDF to SQL should check if they exists or not.


AS ALWAYS DON'T FORGET BACKUPS :)

evail:
Works Great!
Thanks Emre,
Keep up the good work.

As for backups i use this little software called SQLBackupAndFTP.
it takes automatic backup everyday.

Thanks again

Navigation

[0] Message Index

[*] Previous page