Viewing 15 posts - 1 through 15 (of 208 total)
thanks folks for input
no never checkpointed,
i guess my main question is, could these sleeping transactions cause me performance issues?
April 27, 2022 at 6:10 pm
hi Grant
in 4 days we have built up over 500 of these transactions that sleep/open again
is that normal?
mal
April 27, 2022 at 1:46 pm
great stuff Des, perfect
mr
February 1, 2022 at 12:51 pm
meant to say length is variable such as CL-318-AA-1.233
so i cant use SUBSTRING(REVERSE(part),5,2)
February 1, 2022 at 10:11 am
got sql updated with all patches etc and it worked 100% perfect!
cheers all for feedback
mal
December 14, 2021 at 1:58 pm
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...
November 29, 2021 at 8:54 am
hi Jeffrey
yea i did see this, but with updates to 2014 the backup to url option is now in 2014
i did try using straight up sql script as the link...
November 25, 2021 at 4:48 pm
thanks for input folks
the reporting isn't time critical down to seconds or even a few minutes behind but the budget for sql Ent probably wont exist right now, working of...
July 15, 2021 at 3:19 pm
yes sub reports i am having some luck with now (been really restricted in what i can do due to fixed datasources etc from an ERP)
just needed to take the...
June 28, 2021 at 3:59 pm
hi Jeffrey
no unfortunately all i have access to is predefined data definitions from the software i am reporting on, it does not even allow me to see the code behind...
June 3, 2021 at 7:09 am
so the 31450 figure (now 213677) is possibly the total rows of data returned via the index?
June 3, 2021 at 7:04 am
hi folks
yes i agree, would be much cleaner split into separate fields in sql, but i am working with a reporting solution that actually takes the address fields (all of...
June 2, 2021 at 7:37 am
cheers Eirkur! just testing some theory !
October 9, 2020 at 11:54 am
hi Phil
yes this works perfectly
i had quite a few columns so i basically wrote the result set into a table, scripted the table as a Create table and tagged the...
May 7, 2020 at 12:45 pm
thanks Eddie, pretty sure it will be fine with some work, just wanted to hear if the community had good/bad experiences
September 2, 2019 at 1:50 pm
Viewing 15 posts - 1 through 15 (of 208 total)