And also page is not immediately written to the disk. So it might happen that by the time when server has to write the page to the disk there are...

You cannot use CASE and BETWEEN the way you done it. So your first query will not provide a correct result.

If that happened recently then you can try get some information from the default trace. But it won't give you a sql statement which caused it, you will be able...

ALTER TABLE <YourTableName> ADD ID int NOT NULL IDENTITY (1, 1)

ALTER TABLE <YourTableName> ADD CONSTRAINT PK_<YourTableName> PRIMARY KEY (ID)

If you don't know how to write simple SQL queries (SELECT, UPDATE, INSERT, DELETE, CREATE TABLE) then you have 2 options:

1. Learn...

Logged where?

navie22 (9/5/2014)

---

Get date in where condition will also change with each moth like

AND MT.TRANSACTIONDATE BETWEEN DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE())-2, 0) --First day 2 months ago

AND DATEADD(MILLISECOND, - 3, DATEADD(MONTH,...

I assume that you are talking about blocking not dead-locks, because you...

Your client application should take care of formatting.

Abu Dina (8/6/2013)

---

Thanks for this but I've tried to your version and it doesn't seem to work?!

I've changed your code so it uses my sample data but the syntax just...

ALTER DATABASE MC_DB SET MULTI_USER WITH ROLLBACK IMMEDIATE

INSERT INTO DimTable

SELECT ID, Name, StartDate, null as EndDate

FROM

(

...

It's a standard behaviour of an Excel driver + SSIS. There is not much you can do about it. You have to round all the numeric values in SSIS dataflow.

Remove ROLLBACK from the trigger and lower severity of RAISERROR to 10, in this case SSMS won't show any errors, rows will disappear from the UI (but actually they won't...

It's so untrue...

RAISERROR has nothing to do with the transaction.

It's just the way how...