Viewing 13 posts - 1 through 14 (of 14 total)
Yeah it is tricky. I tried a loop to go through each line, and within that loop another loop to go through all lines except the line in loop 1,...
October 4, 2017 at 11:26 pm
It hasn't as yet but no doubt will. It could a few weeks away or a few months, but as soon as it does I'll be using the advice from...
September 25, 2017 at 9:55 pm
One thing I'll add is when we did query for blocks there were none showing so I imagine the two queries you show will return no results.
September 18, 2017 at 5:06 pm
Thanks bmg002. I will definitely be using these queries when it happens again and hopefully we will get to the bottom of it.
I'll make sure to update this discussion...
September 18, 2017 at 5:01 pm
Here are the results from sys.dm_os_latch_stats and wait_stats.
September 17, 2017 at 6:17 pm
Also, there are 250000+ rows.
I am just reading up on some of the suggestions mentioned here to get my head around how some of these things work.
I...
September 17, 2017 at 5:43 pm
There are 5 indices.
USE [Assets_GMSC_Prod]
September 17, 2017 at 5:22 pm
Here are the triggers.
USE [Assets_GMSC_Prod]
September 17, 2017 at 5:05 pm
Ok, here is the table creation script.
CREATE
September 17, 2017 at 4:58 pm
The index scan looks ok, the estimated number of rows is exactly the same count as actual number of rows.
Now when I say it is a Java application, it...
September 14, 2017 at 5:16 pm
Solved. When Java copied the files across the permissions weren't inheriting the folders permission, possibly from a Windows update. I now run a batch file (using icacl) from Java to...
September 8, 2017 at 12:23 am
Hi Ed,
It is using the SQL login, but this login is linked to the Windows login credential.
I haven't had luck using the Windows login in Java, but...
September 6, 2017 at 6:06 pm
Isn't a SQL credential designed to give a SQL login access to folders on a server by linking it to a domain login that does have this access?
With bulk...
September 5, 2017 at 4:40 pm
Viewing 13 posts - 1 through 14 (of 14 total)