Viewing 15 posts - 736 through 750 (of 2,661 total)
SSRS in Azure Sql - not possible - Microsoft want the clients to migrate SSRS to their PowerBI Premium platform. Cheaper to just get a VM for SSRS for this...
October 25, 2022 at 8:22 pm
they didn't understand the question or the question was badly put.
a Azure VM is like any other VM on prem - it allows everything you use on prem. so a...
October 25, 2022 at 5:33 pm
one of your possible issues is that @DT is a datetime - if this contains anything other than the date only your query will fail as you are comparing it...
October 23, 2022 at 11:11 am
Will shrinking the filegroup this way cause fragmentation issues? I just want to know the safest way to do it.
Thank you.
yes - and that is WHY I said to...
October 21, 2022 at 4:45 pm
shrink as you see on your image. and rebuild indexes afterwards of tables that are on that filegroup.
October 21, 2022 at 4:14 pm
that means bad data somewhere - so try
select field..
from tbl
where try_convert(decimal(18, 4), field) is null
to identify the "bad" data
October 20, 2022 at 8:56 pm
change OrigWeight /2000 to OrigWeight /2000.0
October 20, 2022 at 7:03 pm
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
Viewing 15 posts - 736 through 750 (of 2,661 total)