Viewing 15 posts - 1,336 through 1,350 (of 2,462 total)
homebrew01 (9/9/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 10, 2010 at 1:58 am
Has the volume of data been increased ? means heavy data will take longer time.
above of all , have you made any kind of changes like, script change, privilege changes...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 10, 2010 at 1:57 am
i am not good while dealing with replication but i guess below script might help you.but read it carefully
use database_name
go
create table shrinkfile(
col1 int,
col2 char(2048)
)
dump tran database_name with no_log
dbcc shrinkfile(logical_name_of_log,...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 8, 2010 at 4:57 am
Manie Verster (9/8/2010)
How much free space should I have in relation to the size of the database file?
it might be anything above initial size + auto growth size(percentage). please...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 8, 2010 at 4:01 am
premkuttan.lakshmanan (9/5/2010)
but still it takes 10 to 20 seconds to give 0...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 7, 2010 at 10:27 pm
Vishal Singh (9/6/2010)
Twinsoft SME (9/3/2010)
Have you try recreating the package?Yes, but the same error appears.
Did you restart the sql agent ? and did you try to execute plan plan...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 7, 2010 at 4:38 am
jamessdb (9/7/2010)
How to Restrict & Reduces The LDF file sizes
What are your backup plan strategies ( in case of log files) ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 7, 2010 at 4:32 am
GilaMonster (9/7/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 7, 2010 at 1:58 am
somaiya.chintan (9/7/2010)
Thanks. I tried this, but there appears to be some syntax error with it. Have never seen this kind of statement before so couldnt fix it somehow.any more suggestions?
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 7, 2010 at 1:41 am
somaiya.chintan (8/25/2010)
DELETE FROM RPF WITH (ROWLOCK)
any specific reason to use ROWLOCK ? ...i think sql server itself decides to use locking mechanism.. i am just curious:-)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 7, 2010 at 1:39 am
GilaMonster (9/7/2010)
Bhuvnesh (9/6/2010)
subbusa2050 (9/6/2010)
** Set @Old_Val = (Select @OC from deleted) tis IS NOT WORKING.
How would you get data from deleted table in case of INSERT trigger. there...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 7, 2010 at 12:49 am
Chan Wai Yin (9/7/2010)
Bhuvnesh (9/6/2010)
What kind of lock ? Do you mean different transactional locks like shared, update locks etc ??
Yes, all kinds of transactional locks like read lock,...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 7, 2010 at 12:28 am
subbusa2050 (9/6/2010)
Ok ok fine. but im not getting the value for the following queryset sqlqry = 'select' + @oc +'from inserted'
exec(sqlqry)
'select' + @oc +'from inserted' will not work...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 6, 2010 at 11:19 pm
prakashdotc (9/2/2010)
when i incorporate this SP in SQL Agent as a nightly build process it's not working and doesn't sends mail
Are you using the correct profile/account name ? i...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 6, 2010 at 11:07 pm
subbusa2050 (9/6/2010)
** Set @Old_Val = (Select @OC from deleted) tis IS NOT WORKING.
How would you get data from deleted table in case of INSERT trigger. there will be...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 6, 2010 at 11:04 pm
Viewing 15 posts - 1,336 through 1,350 (of 2,462 total)