Viewing 15 posts - 6,976 through 6,990 (of 13,876 total)
If no one is prepared to hang around late & diagnose this while it's happening, the obvious alternative is to collect as much logging information as you can & then...
July 5, 2016 at 5:51 am
ffarouqi (7/4/2016)
Phil Parkin (7/4/2016)
ffarouqi (7/4/2016)
I am not sure if this is a unique issue for me or is it a known issue for others as well. Basically, they have an...
July 4, 2016 at 12:33 pm
ffarouqi (7/4/2016)
I am not sure if this is a unique issue for me or is it a known issue for others as well. Basically, they have an SSIS package which...
July 4, 2016 at 11:03 am
I suggest that you focus on the string splitter now.
As far as I remember, query plans do not return accurate results for UDFs.
June 30, 2016 at 10:59 am
Creating an index on (paramname, value) in @lists is worth a test – should remove those table scans.
June 30, 2016 at 9:41 am
The most obvious improvement you can make is to replace your string splitter with one which does not contain loops and has been highly optimised.
Have a read here[/url] for such...
June 30, 2016 at 9:31 am
Beatrix Kiddo (6/30/2016)
BWFC (6/30/2016)
What I think I find most annoying is the fact that the money that is made in London, could...
June 30, 2016 at 9:24 am
Beatrix Kiddo (6/30/2016)
The UK government directs funding disproportionately to the south east, and the rest of the union can go hang as far as the bureaucrats in Whitehall are concerned.
The...
June 30, 2016 at 7:09 am
Brandie Tarvin (6/29/2016)
TomThomson (6/29/2016)
Brandie Tarvin (6/29/2016)
tindog (6/29/2016)
Now Wales are after independence from England to 'safeguard' their future...despite the fact that they also voted in favour of Brexit :w00t:
Being part Welsh...
June 29, 2016 at 1:08 pm
Go into SQL Server Configuration Manager and make sure that TCP/IP is enabled under SQL Server Network Configuration / Protocols ...
June 29, 2016 at 1:07 pm
Eric M Russell (6/29/2016)
Phil Parkin (6/28/2016)
Eric M Russell (6/28/2016)
June 29, 2016 at 8:38 am
We don't know your table structure or your data, making this rather challenging.
Perhaps you could use Profiler to find out what query, or queries, Navision is executing and compare those...
June 29, 2016 at 6:50 am
zouzou (6/29/2016)
The errors that i have originally mentioned are staying the same, although i have narrowed down to only...
June 29, 2016 at 5:41 am
Beatrix Kiddo (6/29/2016)
June 29, 2016 at 5:36 am
Viewing 15 posts - 6,976 through 6,990 (of 13,876 total)