Viewing 15 posts - 1,786 through 1,800 (of 2,462 total)
Place a job to update statistics nightly (if you dont have) so that you wont get this kind of problem next time
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 29, 2010 at 11:54 pm
ricardo_chicas (4/29/2010)
I convert that into a abs(column) = 0 the performance improves greatly, is ok to do that, right?
i dont think so , it wil force sql optimizer...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 29, 2010 at 8:53 am
That error has nothing to do with the batch size... it has everything to do with the column size of your target table. The error is saying that if...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 29, 2010 at 8:50 am
You can use NOLOCK hint ( Beware of dirty reads) ,if possible.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 29, 2010 at 8:42 am
alen teplitsky (4/29/2010)
i ran a test on a non-critical SQL server where i set the parallelism to 1 instead of the default 0.
Just curious why did you set...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 29, 2010 at 8:39 am
ALZDBA (4/29/2010)
did you change the sqlagent service account lately ? (and does that account have the same windows privileges a the previous account ?)
Good Question 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 29, 2010 at 12:27 am
have you changed the Job scheduled timing recently ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 29, 2010 at 12:01 am
chanti2985 (4/28/2010)
tlogbackup-everyday except sundayfull backup-sunday
Not an ideal Backup strategy, Include differentail back up also and change the Tlog backup frequency to One hour. Additionally read the articles related to...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 28, 2010 at 11:59 pm
gupta1282 (4/28/2010)
what would be the reason ? could somebody help regaring this issue ?
So hard to tell , a lot of reasons
1 Disk Slowness
2 taking backup on remote drive.
3...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 28, 2010 at 8:17 am
Better to post table/index defintion and exec plan and get speedy results 😉
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 28, 2010 at 7:59 am
Three things :
1) Are you using sp_send_dbmail ?
2) Did you see any records in EXTERNALEMAILQUEUE table ?
3) Have you checked Sql agent mail log ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 28, 2010 at 7:43 am
Nitin-900948 (4/28/2010)
You can drop the index on this table. Then insert the data and recreate the index. It will reduce the time of index update durig insert.
thats the recommended...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 28, 2010 at 3:19 am
ColdCoffee (4/27/2010)
Bhuvnesh (4/27/2010)
Adding more info.two tables ( [CAMPAIGN] ,CAMPAIGN_CUSTOM_FIELD) exist in one database and other two (CUSTOM_FIELD,LU_CUSTOM_FIELD_TYPE)
in different database
FROM BOL
All base tables referenced by the view must be...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 27, 2010 at 7:51 am
Adding more info.
two tables ( [CAMPAIGN] ,CAMPAIGN_CUSTOM_FIELD) exist in one database and other two (CUSTOM_FIELD,LU_CUSTOM_FIELD_TYPE)
in different database
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 27, 2010 at 7:42 am
THeSqlGuru(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 4:13 am
Viewing 15 posts - 1,786 through 1,800 (of 2,462 total)