Can you give us the error you getting. Also please provide the create table statements for tblEvent and DailyBackorderedSkusSnapshot along with some test data.

I agree with...

My question is why are you in the FULL recovery model in the first place? Is it to be able to have a point-in-time restore? Then you need to leave...

Well with out table structure and data you could use the following:

create table CARS (Model varchar(100), RentalDate datetime);

go

insert CARS

values ('Camry','20120101')

,('Accord', '20120201')

,('Accord', '20120202')

,('Camry','20130101');

go

select DATEPART(year,RentalDate) as RentalYear, DATEPART(month,RentalDate) as RentalMonth, Model,...

Please look at the article in my signature about posting questions on the forum. We will need some table structures and some sample data with an expected output. Once you...

When setting up your service accounts you want to follow the principle of least privilege. Basically this means that you only want to grant the necessary rights to your service...

I use Red Gate SQL Data Compare (10.0) which allows you to compare a snapshot to a database. So you could create a snapshot of the database prior to the...

Good point Jeff. I was simply making a suggestion of which columns should be in the index not intending them to be added necessary in that order, but I should...

Truncate will be the fastest option since it will de-allocate all data pages from the table. How long will it take? It depends on the number of pages and your...

Right click the maintenance plan and select modify. Then find the task that is failing and edit the properties. It should be one of the properties.

Since you are using maintenance plans make sure that the task that is failing has the FailParentOnFailure set to true. I believe that is it set to false by default.

kapil_kk (10/30/2013)

---

janki0430 (10/30/2013)

---

AssembleTrn is table with about 170157 records

when i run this query it will take about more than 1.30 minute

plesae help me in getting recoeds in...

That sort of Upsert logic makes more sense in a stored procedure. Can you create a stored procedure to handle this case? If the @key already exists then...

Verify that the "On Failure" action for the job step that is failing is set to "Quit the job reporting failure".

First off there is no "fool proof" when it...