Viewing 15 posts - 1,801 through 1,815 (of 2,462 total)
yatish.patil (4/27/2010)
we need this to be done on last day of every month.
Do you have triggers with it ? if not then go for simple INSERT statement ( better...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 27, 2010 at 3:50 am
Grant Fritchey (4/26/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 27, 2010 at 3:24 am
we need to insert more than 60,000 rows every months
this is not a heavy data migration , you can go with either batch appraoch(i posted above) or T-sql. do...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 27, 2010 at 3:23 am
i think you should opt batch process , move data chunk wise ( says 5000 records on every execution ) and you can schedule this process in daily running job...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 26, 2010 at 9:18 am
chrisph (4/26/2010)
Thanks Lynn. Anyway to automate this or do you do it manually? We have many servers and databases.
EXEC master..xp_CMDShell 'XCOPY d:\srvr1\MSSQL.1\MSSQL\Backup \\fs01\Backup\DBA02\srvr1\FINAL2\FULL /d/c/v/y'
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 26, 2010 at 9:00 am
i would suggest, rather playing with log/data files, spend some time to understand the log architecture how they grow how they work ; when/why they behave good or bad ?...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 26, 2010 at 8:42 am
thava (4/24/2010)
Recently i have some query which pickup the same result set :unsure: :unsure: :unsure:
i want to know which one is the best one and...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 25, 2010 at 4:02 am
you can opt for C2 auditing although it is resource consuming as it's capturing all the database activity hence need to use only when high security is concern.
Some of...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 25, 2010 at 3:12 am
Simple, if you are migratng/creating new databases , better transfer those logins and reset all passwords. 😉
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 25, 2010 at 2:26 am
Chirag Roy (4/22/2010)
Can you run a manual checkpoint in the context of the affected database and see if you continue to see the locking behaviour?
just to see behaviour, i...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 25, 2010 at 2:02 am
chanti2985 (4/24/2010)
we are getting same alers.can anyone tell me the reason.
How do you get those alerts , sql server jobs ,or any sql tool or any third party...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 25, 2010 at 1:41 am
Jeff Moden (4/24/2010)
Bhuvnesh (4/24/2010)
Jeff Moden (4/23/2010)
Also, is there a chance that WWW and WWW1 are actually views.
Why do you think that it could be view ? because of "Select...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 24, 2010 at 11:17 pm
ColdCoffee (4/24/2010)
Me born in , une fois par le territoire français (once a french territory) PONDICHERRY, in INDIA! 😉
And now working in chennai (again in INDIA) for one...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 24, 2010 at 11:15 pm
striker-baba (4/23/2010)
My plan is to put the database in simple recovery mode and then shrink the log file.
Why do you want to put it in SIMPLE just for truncating...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 24, 2010 at 10:13 am
varshachyk (4/24/2010)
" failed with the following error: "The transaction log for database 'connect_prod' is full.
it clearly showed the problem .What have you done for it ?
Resolution:
When the transaction logs...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 24, 2010 at 10:09 am
Viewing 15 posts - 1,801 through 1,815 (of 2,462 total)