can you extract the statement of the @SQL? it's helpful to trace the error.

trace your system and find the...

Memory is the bottle-neck of your system? sure? if so, can solve the problem by adding more memory.

But, i suggest, firstly, giving your system a whole performance tuning, and find...

First of all, i think you need not shrink the log file IF your db has more active transactions and disk has sufficient space.

When you shrinked the log file and...

The performance of the first one is better than the second.

The query efficiency will be improved largely by adding the appropriate index, but will slower data modification operation, because the...

gul_vu (7/27/2010)

---

Hi every body

We are having different clients in different countries. We were managing one centerlized Database for all of our clients, clients were accessing the database through a web...

GPO (7/14/2010)

---

At the moment, my code looks a bit like this:

exec dbo.usp_my_stored_proc 1, 12, 10000;

exec dbo.usp_my_stored_proc 2, 12, 10000;

exec dbo.usp_my_stored_proc 3, 13, 9000;

exec dbo.usp_my_stored_proc 7, 14,...

can try SSIS foreach container to loop the files and load into one table?

page split will happen when the page is full and also you want to insert data continually.

can set the index fill factor less than 100 to keep some space for...

some solutions become simple and convenient since RANK function(NOW_NUMBER,RANK and DENSE_RANK).

Nagesh S-432384 (5/31/2010)

---

Hope this might help you 🙂

declare @mytable table

(

potype varchar(10)

)

insert into @mytable values ('AA')

insert into @mytable values ('BB')

insert into @mytable values ('CC')

declare @potypestring varchar(50)

select @potypestring = isnull(@potypestring...

Thanks for giving me so much good methods! I learned more from you:-P

No run into such a problem. Just one exception or all the data flow tasks encounter this issus?

Get it, Thank you so much,ColdCoffee:-)

I have a function need to trasnfer the set-based result to a format string. I use the database cursor rotating and processing it one by...

I thinks it will be well preformance using sp_executesql for dynamic sql query. it can reuse the execure plan in cache, so reduce the compile time.:-)