Sounds like you need to use a scheduled job for this.

Where are you trying to use the stored procedure as a data source and how are you specifying it?

Not necessarily. I would add the following columns to your query: ps.page_count, ps.avg_fragment_size_in_pages.

Well, since we can't see what you see it is a little hard to provide you with any help. How about posting the code for the stored procedure.

mpradeep23 (5/25/2013)

---

Now table as no data in feature table may get 1 million record per day for that case if i change decimal(18,0) to int is that improves the...

You are looking at something like this:

declare @Table1 table(

Col1 char(1),

Col2 int

);

declare @Table2 table(

Col1 char(1)

);

insert into @Table1

values ('A',1),

...

vahid.arr (5/25/2013)

---

i write this query but it give me this error:

All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target...

This doesn't really answer the questions I had posed.

Based solely...

mpradeep23 (5/25/2013)

---

Hi

I have a column of data type decimal(18,0) can i change it to Int

for the above case whether Performance improves if i change

thanks

with...

EasyBoy (5/24/2013)

---

While i am altering a column, getting a message as below.

Can anyone please help? It's urgent.

alter table test alter column AvgCashAndInvestments numeric(19,0) NULL

The statement has been terminated.

Msg 682,...

Not really that I am aware of. You may need to write some t-sql queries to help determine this. You may want to start here: http://msdn.microsoft.com/en-us/library/ms173571.aspx

Duplicate post, please direct all replies here

Please, don't double post, it just fragments any answers you may get and can lead to frustration on the part of those who do...

Interesting. This is the first time I have heard of this. What else is running on your system when this occurs?

Brandie Tarvin (5/24/2013)

---

Just goes to prove that none of us are capable...

Sergiy (5/23/2013)

---

L' Eomot Inversé (5/23/2013)

---

I had some hassle with installing outlook on top of office H&S, which was an office problem not a windows 8 problem. I've been told...