But i can see lot of logical reads and read-ahead reads here for the PDSPrioritizedPriceListItem table.

How can we reduce this to minimum. Any index suggestion to specially for...

Hi Experts,

I have attached the Query plan ,indexes created on the table and part of the queries which i have a problem ,please help me.

Here is my code

I am not able to retrieve the execution plan as the query itself is not completed.

Please help,I have created this as the SP

IF OBJECT_ID('tempdb..#MissingPAIntelorCP') IS...

OK thank you But i am looking at incremental data refresh,, I mean i have a column date_modified based on that column i need to refresh the data dialy ones.

Thanks,

gAnGa

Thanks for the reply.

I have got a solution to this but adding additional conditional with where clause,it worked out for me.

Thanks.

Ganga

in this query there is a problem now

WITH DirectReports(Employee_ID, Parent_ID, PositionName, Position_ID, Team_ID) AS

(...

NodeiD limiting also didn't worked for me.

Actually another SP is calling this sp inside the cursor so not able to find the exact culprit.

Something can be done here ?

hi

i have used upto 32200 for max recursion but still same error. please suggest me some other method.

Hi All,

this is the query which is causing this error.

CREATE PROCEDURE [dbo].[TotalChargeByPosition] (

@Position_ID int,

@FirstOfMonth datetime,

...

what are all the things we need to check for after the migration,..any query will be helpful.

Hi

I have used for each loop task and configured to loop through the files and its working very fine now.

I have used variable which is pointing to Folder but the...

Hi

Thanks for the link.

As the CSV file has been generated from database the vale "204,015" is stored in this manner only.

Though i am using " " for a single...

Can you please somebody assist me.The above link resolution does 't helped me out.

the systems is having 32 Gb of memory.

I have restarted the service for SQL server,even after restarting sql service instance i am not able to verify the back up.

Could you...

Hi Pradeep,

Yes you said i have initiated the New backup and successfully i have taken backup.

Even after doing the tran log back up i have done the Full backup again...