Hi

Unfortunately, I wasn’t able to open the document containing exec plan, but based on the code, it seems to me that there are quite a few problems with your procedure...

I would probably try to use CTEs, something like:

;WITH cte_TestTable

AS

(

SELECT ROW_NUMBER() OVER (ORDER BY start) AS 'No',* FROM TestTable

)

SELECT a.id,a.Stop as StartTime ,b.StartTime as Stop FROM cte_TestTable a

INNER JOIN cte_TestTable...

Really guessing, but if it happens only on Thursdays and only between 8:30am and 8:40am, could it be that some scheduled job that is running during that time or some...

+ the trigger

What is the trigger doing?

Is it also updating something?

(you mentioned that the table contains trigger.

Is it fired on/after update?)

It was not database that was suspended but a process was suspended.

(Database can be marked as ‘suspected’ not ‘suspended’).

If you carefully read the message that you got you will see...

Hi,

It is impossible to help without more (much more) additional information.

I am assuming that your server is SQL dedicated and that there are no other applications running.

I would recommend basic...

SELECT

(select count (itemmaster.itemid)[Total Books] from itemmaster) as [Total Books],

(Select count (AccNo) [Total Issued Books]from isuueRecev where passint=1) as [Total Issued Books],

(Select count(Accno) [Over Due Books]from isuuerecev where RecevDate<'2011-06-10') as [Overdue...

Hi

You didn't specify what kind of replication you have (or other details),

but from the error is it obvious that it's trying to create a fk constraint on the subscriber side...

Hi,

I had almost exactly the same problem in the past, and the only way I found out to deal with it was to clear old records from subscriber directly.

Filter is...

Hi,

I would guess that it is very likely, but it's difficult to say since you didn't specify how is space organized (which files are sitting where and how much space...

Hi,

Based on the tables you already have, it seems to me that contacts should be two separate tables: one for customers and one for brokers.

Assuming that you out them...

Hi,

Unfortunately, reading trace will not give information about size increase, but can give you information where the increase is coming from (ApplicationName, LoginName,StartTime)

It should look something like:

select * from fn_trace_getinfo(0)

select...

Hi

Have you checked % of usage of your TempDB?

use TempDB

sp_spaceused

Is the database "re-growing" or it was one time growth?(Could be some ill query ran by someone...?)

In addition to running...

Thank you

Thank you, it was exactly what I needed 🙂

Have one more question (and will risk to sound stupid):

I heard/read a few times so far that some people are suggesting, in...