I have all the information gathered in the tables, howerver i want to show the row count and size growth based on the each year for specific tables.

Thanks

I am populating all the table information to main table on daily basis based on date time stamp. However, how to create a script to query against the table. Any...

Yes, i did. It will give me the top 10 current running queries. However, i am looking for something like 30 mins before.

Thanks

Ok thanks! This helps, I have created Job and alert me if row count > 0 from sysjobs table.

I have seen in the past if there are any blockings then it should time out right. However, it will show as running for days without failing and doing nothing?

Thanks

Well I would like to find if there is a way to setup some kind of notification when the job is hung? Do we have any workaround like that?

Thanks

It never ends. We restarted the server but no luck?

Thanks so much!

Thanks it worked! So here we are not moving the file to different location.

That means we are just altering the file size with following command.

ALTER DATABASE tempdb MODIFY FILE...

We had unusual growth happened for one bulk operation. Which we may run again. So the tempdb suppose to be 25 GB and it grow to 50 GB. So I...

Do you think it cannot be done with BCP?

Thanks

However, now I am getting memory shortage. When I look memory metrics it looks good. Does it mean it needs more memory? Why I am seeing this notification when I...

Lets consider 2 different tables TABLE A and TABLE B.Now, suppose that there are two different sessions with different activity. Does one of the session will be blocked or timed...

Thanks to everyone!

Thanks!