Viewing 15 posts - 6,976 through 6,990 (of 13,876 total)
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.
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
panneermca35 (6/29/2016)
Dear All,I have saved image as image datatype in database now i want to convert that image as HTML content using sql query. Kindly give me the suggestions.
Can you...
June 29, 2016 at 5:06 am
If you want to have control over the values in your IDENTITY column, I suggest that you don't use an IDENTITY column, or that you consider using SET IDENTITY_INSERT ON...
June 28, 2016 at 5:23 pm
mcfarlandparkway (6/28/2016)
showing object name as delPersons ....I see only this.
Is there any way that they are handling this audit data from some where...
June 28, 2016 at 11:22 am
SQL Search[/url] is free and really useful when you are looking for references to database objects. Maybe it will help you track this down.
June 28, 2016 at 10:42 am
Viewing 15 posts - 6,976 through 6,990 (of 13,876 total)