Viewing 15 posts - 1 through 15 (of 24 total)
can you extract the statement of the @SQL? it's helpful to trace the error.
November 1, 2010 at 3:57 am
pavan_srirangam (10/26/2010)How do I release memory from all caches?I ran out of memory on my server and I see lots of waits waiting on memory.
How do I release memory from all caches?
I ran out of memory on my server and I see lots of waits waiting on memory.
trace your system and find the...
October 26, 2010 at 7:56 pm
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...
October 25, 2010 at 8:07 pm
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...
October 25, 2010 at 7:33 pm
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...
July 28, 2010 at 2:23 am
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...
July 28, 2010 at 2:10 am
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,...
July 15, 2010 at 12:55 am
can try SSIS foreach container to loop the files and load into one table?
July 15, 2010 at 12:44 am
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...
July 14, 2010 at 12:05 am
some solutions become simple and convenient since RANK function(NOW_NUMBER,RANK and DENSE_RANK).
June 21, 2010 at 8:19 pm
Nagesh S-432384 (5/31/2010)
Hope this might help you 🙂
declare @mytable table
insert into @mytable values ('AA')
insert into @mytable values ('BB')
insert into @mytable values ('CC')
declare @potypestring varchar(50)
select @potypestring = isnull(@potypestring...
June 7, 2010 at 9:25 pm
Thanks for giving me so much good methods! I learned more from you:-P
June 1, 2010 at 6:58 pm
No run into such a problem. Just one exception or all the data flow tasks encounter this issus?
May 31, 2010 at 2:28 am
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...
May 31, 2010 at 2:06 am
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.:-)
May 26, 2010 at 11:16 pm