Viewing 15 posts - 46 through 60 (of 146 total)
I do not believe it is that but will check. Did you experiance any kind of waits.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
September 15, 2010 at 9:02 am
SELECT A.EMPLID, A.NAME, B.G5_BU, D.JOBTITLE, D.NATIONAL_ID, C.OPRID
FROM dbo.PS_PERSONAL_DATA AS A
INNER JOIN dbo.PS_TRAINING AS B
...
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
September 15, 2010 at 8:42 am
I see that the null is when there is no rows in the table. I ran the following and it returned 0 rows.
select i.name,* from sysindexes i join sysobjects o...
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
September 15, 2010 at 8:36 am
stat date is null what does this mean. if this is a problem how do I force stats update? other than what I already ran.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
September 15, 2010 at 8:09 am
this is what I ran for all tables
UPDATE STATISTICS dbo.PS_EOCM_EDUP_TMP7 with fullscan
UPDATE STATISTICS dbo.PS_TL_TA_PAY_TM1 with fullscan
UPDATE STATISTICS dbo.PS_EP_GOAL_LANG with fullscan
UPDATE STATISTICS dbo.PS_GVT_ACCR_LDGR with fullscan
UPDATE STATISTICS dbo.PS_CRSE_SESS_EQUIP with fullscan
UPDATE STATISTICS dbo.PS_SAVINGS_INVEST...
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
September 15, 2010 at 7:37 am
Here is the 2008 plan. I can not save the 2000 plan. How do I get it? Sorry sitting in middle of another crisis aswell
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
September 15, 2010 at 6:48 am
The problem still persists. What I have done after upgrade.
Rebuild all indexes on tables fragmented more than 10%
Updated all stats on all tables with full scan
DBCC UPDATEUSAGE(HRTST)
DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE
I ran...
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
September 15, 2010 at 4:26 am
Hi
I did do a sp_updatestats and index rebuild. This did not change anything. I am running stats update with fullscan. I will post my findings after update and also add...
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
September 15, 2010 at 2:05 am
Hi
I know this is an old post but did anyone find a solution to this. Redoing all views, SPs and other scripts to optimize is crazy. I work with a...
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
September 15, 2010 at 12:22 am
how long does the command run before it gives error?
how are you sharing the file? Normal windows share?
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
July 15, 2010 at 6:01 am
make sure that the account that it runs under in maint has access to the userdb. Try removing GO between use userdb and dbcc commands
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
July 15, 2010 at 5:54 am
The next thing you can try is deleting the maint plan a recreating but do not create plan from remote pc, create the plan by logging on to the server...
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
June 18, 2010 at 5:38 am
Try changing the user the job is running under to 'sa'.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
June 18, 2010 at 12:06 am
There is allot of considerations.
Do you have a where clause and joins. If so post it here so that a index recommendation can be made. In cases like this...
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
April 28, 2010 at 5:46 am
Hi
Anybody have an answer for me.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
April 28, 2010 at 5:42 am
Viewing 15 posts - 46 through 60 (of 146 total)