Some space you need to reclaim from the drive where mSDB resides ( and i suspect that all sys databases will on same drive) try to gain space...

aeri_q (10/17/2013)

---

it returns 3 rows for a specific table of my database.

But when i wrote stored procedure using the same query it inserted the first row in my table....

YOu cant do that if the data (table/index ) sitting on that...

and do you have tlog back scheduled ? because if transaction log has not been backed up recently, backup might be what is preventing log truncation

Read about "Index fragmentation" OR you can more elaborative about this question here to get some specific

What is the recovery model ?

Good question

and thanks SqlNaive for sharing the info about how to check value in XML plan

aeri_q (10/17/2013)

---

but it reads only one row, the first one.

How can i get able to read all the rows and insert them in table , with the help...

Any specific reason ?

One thing i can say here is .. it will be protective approach.

create a new column with new dimension...

...

navakanth_yenreddy (10/16/2013)

---

Hi

I need small clarification on your query. These transactions are hitting from the application to database ?

I have my requirement as below, could you please check it...

Here i dont think you need to use any parapmeter with Stored Proc.

see below code

create proc p

as

select 1 union select 2

declare @t table (id int )

insert...

This could be reason.

ALTEAST...

L' Eomot Inversé (10/16/2013)

---

Bhuvnesh (10/16/2013)

---

But I made the wrong selection . beacuse i was thinking (and this was my understanding ..earlier) that once the commit has been fired, the following...