Viewing 15 posts - 1,666 through 1,680 (of 2,654 total)
if a database belongs to your software you can put as a support condition that your databases are not shrink - it is up to the client to add an...
February 18, 2020 at 8:16 am
looking at the view i wonder if we could do the join to get the sumamt at the very end on the last 2 unions - would need to ensure...
February 18, 2020 at 12:01 am
first thing - your script requires Excel to be installed - if this is on a Server it is not supported, and it most likely breaks Microsoft Licensing. even if...
February 17, 2020 at 9:49 pm
That's an interesting alternative. Right now, as I said before, CTE view performs better if you filter for one of the first 2 columns. However, if you just SELECT...
February 17, 2020 at 4:50 pm
Here is the new plan with first option (UNION ALL SELECT NULL, NULL). What's the purpose of the UNION ALL in this case?
purpose was to try and "materialize"...
February 17, 2020 at 12:13 pm
not necessarily bad - it depends on how many times that spool is created - if just once its fine - if once per each loop then not so good....
February 17, 2020 at 10:12 am
-- option 2
or if the aggreg_nr still does not work then replace all the outer applies with
outer apply (select sum(amt) over (order by nr) from dbo.dbdopsk dop where dop.nr...
February 17, 2020 at 9:37 am
can you also try the second option - and post plans for both first option (with outer apply) and my second - this second should be better than your first...
February 17, 2020 at 9:14 am
ah well.. we just looking at it and thinking of what can be better and not testing as we don't have ddl for the tables.
try the following 2 options
February 17, 2020 at 8:49 am
I don't quite understand the purpose of this code:
OUTER APPLY (SELECT NR,
...
February 16, 2020 at 9:21 pm
you should know better by now that such a basic question without some google investigation is not getting you nowhere fast.
lots of info about that subject already that you should...
February 16, 2020 at 12:05 pm
could you post a link to that book - that used to be something that applied only to tempdb files, and even that is really a myth.
for most cases...
February 14, 2020 at 12:10 pm
first I hope you aren't doing those inserts one by one - if so change it so you work with sets not with a record at the time
in order to...
February 13, 2020 at 12:46 am
have a look at https://www.php.net/manual/en/function.sqlsrv-prepare.php
or https://docs.microsoft.com/en-us/sql/connect/php/sqlsrv-prepare?view=sql-server-ver15
different functions than the one you gave the link for - this may work for you
February 11, 2020 at 8:49 pm
did you try
$spSQL = "exec p_1A_insert ( ?, ?, ?, ?, ?, .....
$storedProc = sqlsrv_query( $queryLink, $spSQL, $spParams );
or
$spSQL = "exec p_1A_insert @parametername1 = ?, @parametername2 = ?, ?, ?,...
February 11, 2020 at 6:15 pm
Viewing 15 posts - 1,666 through 1,680 (of 2,654 total)