Forum Replies Created
Viewing 15 posts - 1,666 through 1,680 (of 2,649 total)
-
Reply To: Recursive CTE vs UNION ALL in a VIEW
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....
-
Reply To: Recursive CTE vs UNION ALL in a VIEW
Mauricio_ wrote:-- 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...
-
Reply To: Recursive CTE vs UNION ALL in a VIEW
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...
-
Reply To: Recursive CTE vs UNION ALL in a VIEW
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
-
Reply To: Recursive CTE vs UNION ALL in a VIEW
Jonathan AC Roberts wrote:I don't quite understand the purpose of this code:
OUTER APPLY (SELECT NR,
... -
Reply To: Looking for recommendation on "cost threshold value"
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...
-
Reply To: number of database files
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...
-
Reply To: Insert Data and read all Foreign Keys/Constraints first
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...
-
Reply To: Incorrect syntax near ‘@P1’., when trying to execute prepared statements frm php
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
-
Reply To: Incorrect syntax near ‘@P1’., when trying to execute prepared statements frm php
did you try
$spSQL = "exec p_1A_insert ( ?, ?, ?, ?, ?, .....
$storedProc = sqlsrv_query( $queryLink, $spSQL, $spParams );
or
$spSQL = "exec p_1A_insert @parametername1 = ?, @parametername2 = ?, ?, ?,...
-
Reply To: Columnstore indexes and compatibility
in 2016 they work fine - I have a DB where most of of the tables have a CCI's and no issues with them.
but in compat 2012 .... test it...
-
Reply To: bouncing emails SQLServerCentral.com
Mike - this is shown on this site - not on any email I get
-
Reply To: How to Insert EventViewer records to SQL Server Table
google for "winevents load to sql server" and you will find a few examples of how to do it
-
Reply To: Zappysys SSIS Send HTML Email Task (FREE)
I do think it is very clear that it is free. And it is the vendor you should be asking in the first place.
-
Reply To: Move SQL Server 2008 DB's to SQL Server 2019
you have the wrong order there
and 2 servers mean 2 different ip's and 2 different names so they can be alive at same time.
keep old server with old name
1 -...
Viewing 15 posts - 1,666 through 1,680 (of 2,649 total)