Viewing 15 posts - 1,786 through 1,800 (of 2,463 total)
can you post index definition ?
I think TempTraveller table needs better indexing.
April 30, 2010 at 5:23 am
Place a job to update statistics nightly (if you dont have) so that you wont get this kind of problem next time
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...
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...
April 29, 2010 at 8:50 am
You can use NOLOCK hint ( Beware of dirty reads) ,if possible.
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...
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 🙂
April 29, 2010 at 12:27 am
have you changed the Job scheduled timing recently ?
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...
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...
April 28, 2010 at 8:17 am
Better to post table/index defintion and exec plan and get speedy results 😉
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 ?
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...
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...
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
April 27, 2010 at 7:42 am
Viewing 15 posts - 1,786 through 1,800 (of 2,463 total)