Viewing 15 posts - 736 through 750 (of 2,654 total)
Thank you for your response, but I am looking for a query that searches all stored procedures for the '##' sign. I can't manually check all of them we...
October 20, 2022 at 6:58 pm
you likely missing a step on your initial setup of the catalog - or you aren't using parameters on your packages correctly.
have a look at https://www.sqlservercentral.com/steps/ssis-catalog-environments-step-20-of-the-stairway-to-integration-services - step by step...
October 19, 2022 at 9:42 pm
There are a number of restrictions and possible gotchas with filtered indexes. In theory they are great, in practice they can be difficult.
would you care to explain...
October 18, 2022 at 8:05 pm
There are a number of restrictions and possible gotchas with filtered indexes. In theory they are great, in practice they can be difficult.
would you care to explain exactly which...
October 18, 2022 at 6:10 pm
can you post the table DDL (including indexes/PK) and explain the process of inserting and updating this table BEFORE you try to do the update above.
what you say above looks...
October 18, 2022 at 7:37 am
your inner query has a column (status) that is not on the group by - so you need to build your query differently
on this particular case and because you are...
October 17, 2022 at 6:21 am
and in addition to what Ant said make sure you have ALL of your replication setup scripted so you can re-apply it easily
October 16, 2022 at 8:07 am
better not to have them with passwords - any sensitive data for connection strings should be on config files (or config environments on SSIS catalog) - if on files they...
October 14, 2022 at 10:43 am
first question is why username/password (unsecure) and not windows authentication.
Second - unless you add the users to the database no one will have access to those db's - so that...
October 14, 2022 at 10:37 am
you don't state what is the application running on the VM that is trying to connect to the server - but assuming it uses standard connection strings and that you...
October 11, 2022 at 2:52 pm
you are as suspected running on a VM machine - while your config may be ok for your workload you should monitor your usage to see if you need more...
October 10, 2022 at 2:40 pm
as I've shown you on the other thread you have a construct that calculates the values you need.
you then use those calculated values on the main query.
pseudo...
October 10, 2022 at 10:24 am
use the same outer/cross apply construct you were given on your other thread
that is one of the good cases for it - define the values to use on the apply...
October 10, 2022 at 9:57 am
even if you don't have the buttons you can use the tags as I mentioned.
October 10, 2022 at 7:47 am
using cross/outer apply means that you can then use the new columns elsewhere as I did - making the code cleaner.
so on your own example with your concat ",CONCAT(DD, '-',...
October 10, 2022 at 7:39 am
Viewing 15 posts - 736 through 750 (of 2,654 total)