Viewing 15 posts - 1,711 through 1,725 (of 2,701 total)
I really don't understand the amount of people that haven't changed the the Catalog, nor the resistance people give. The actual migration isn't actually that hard, provided you...
February 26, 2020 at 7:41 pm
One idea, using Powershell, would be something like this.
Firstly set up some test objects:
CREATE TABLE dbo.ServerList (ServerID int IDENTITY PRIMARY KEY,
...
February 23, 2020 at 11:03 pm
no need for a loop as far as I can see, but a sub select required to ensure we do get the correct date set
UPDATE A
SET ...
February 21, 2020 at 11:18 pm
what does the output of this query give you on new server and old server?
select name, is_recursive_triggers_on
from sys.databases
where name = 'mydbname'
replace mydbname with correct name
February 19, 2020 at 6:40 pm
you also need to consider what the usage of the view is going to be. if majority of access will use a filter which you stated is faster than the...
February 19, 2020 at 4:14 pm
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
Viewing 15 posts - 1,711 through 1,725 (of 2,701 total)