HI FOLKS

ill go back and check the index's being used on both to ensure both the same (its the exact same query using exact same front end application) only the...

guys, thanks so much for the replies and detail given. time for me to renew some knowledge (Busy IT Manager/Jack of all trades/Master of none issue)

think i eventually got my...

• This reply was modified 4 months, 2 weeks ago by  dopydb.

hi folks

really appreciate the feedback here guys, although i am now in a state of, what the hell do i do now - which is no bad thing, lets revise...

• This reply was modified 4 months, 3 weeks ago by  dopydb.

EXECUTE [dbo].[IndexOptimize]
@Databases = 'Kinetic,Doclink2,ESCDB',
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationLevel1 = 5,
@FragmentationLevel2 = 30,
@SortInTempdb = 'Y',
@UpdateStatistics = 'ALL',
@FillFactor = 90,
@OnlyModifiedStatistics = 'Y',
@LogToTable = 'Y'

Jeff

look at my reply above , thats a five day window!

the scripts i use for indexing are just the standard ola hallengren scripts

And as i said, normal erp sql activity...

hi Brian

my query is more - why is no space ever being being used beyond 50mb? it has the most transactions/sec

below shows past 5 days, top chart is space used,...

now i am confused - the query i have seems to have the correct offset using

[_TIMESTAMP] at time zone 'GMT Standard Time' AT TIME ZONE 'UTC' as _Timestamp_1

data

7615 UNI.S7.ROBOT.EFFICIENCY_DAY 0...

hi Jeff

the data is datetime as below, data sample attached

we have lots of these views for various sensors, so i just want to ensure i can write this view that...

hey ya, started working on the obvious - what ratbak said, just haven't had time to finish

so basing it on the logic that

SELECT substring(current_utc_offset,2,2) FROM sys.time_zone_info WHERE NAME = 'GMT...

thanks folks for input

no never checkpointed,

i guess my main question is, could these sleeping transactions cause me performance issues?

hi Grant

in 4 days we have built up over 500 of these transactions that sleep/open again

is that normal?

mal

great stuff Des, perfect

mr

meant to say length is variable such as CL-318-AA-1.233

so i cant use SUBSTRING(REVERSE(part),5,2)

got sql updated with all patches etc and it worked 100% perfect!

cheers all for feedback

mal

i am using the below command as advised on the link, but having no luck at all!

BACKUP DATABASE [ShopFloorDataSystemE10Live]
TO URL = 'https://name.blob.core.windows.net/sql/test1.bak' 
WITH CREDENTIAL = 'az' 
,COMPRESSION...