How to show #ERROR as Zero or as Nothing in matrix cell when groups and calculated field are based on switch-function in SSRS?
Imagine simple BI task: We have two grouping columns and one calculated field. like select group1, group2, sum(sales) Sum_of_sales from dbo.table1 group by group1, group2 When for some combination of grouping columns there's no ROW in dataset -…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
Exclude empty rows in Report
I have a table in an RDL file. Empty rows create due to the (Finish) field contains in sql query, (Finish) field not used in the main report. Field (Finish) is used as a parameter to go to the subreport, I cannot delete it. How to exclude…
Is there a stored procedure in SQL server that allows you do perform clustering/kmeans clustering?
My boss is giving me a bunch of data to analyze by using clustering/kmeans methods. Is there a stored procedure in SQL server that allows me to do that?? Thanks
which licence MS SQL for a 4 core machine?
Dear, We are a Microsoft ISV partner who deliver a software for the construction industry (.NET solution). In order to ship our solution we use Microsoft SQL Calls which we can buy under out ISV contract at Ingram Micro (see below); However now we…
![](https://techprofile.blob.core.windows.net/images/ctcyKX4BnU-r4fRclNq-Ww.png?8D9AB2)
Azure guest user authentications issues - Excel and PowerBI asking for authentications all the time
Hello, I have an Analysis Service instance running on Azure. Based on this AAS, my users are invited as guest users in my AD tenant. And they are allowed to read the data in AAS through Excel or PowerBI. They have accepted the invitations and created…
Rebuilding indexes on 5TB database
We have a 5TB database. Rebuild index job is taking days to complete. Is there any way to rebuild chunk of indexes?
Sql server 2019
Wanted to migrate SQL 2012 databse of size 60 gb to SQL server 2019 Wanted to know what is the memory required for 60gb database .db server is standalone. As there are more than 20000 users will acces the application daily basis. Db Server is on…
Users that have run a specific metered software program report is blank
Hello This issue is for the Microsoft Endpoint Configuration Manager Software Metering Report Microsoft Endpoint Configuration Manager Version: 1910 Details: I find myself in a unique situation where this software metering report is…
sql server 2016自动备份失败问题
操作步骤: 1、创建用户a,初始密码b; 2、修改密码为c; 3、重新登录用户a,密码c成功; 4、创建自动备份维护计划成功; 5、右键维护计划-执行; 6、执行结果失败:用户名与密码不匹配,账户被锁定; 7、修改用户属性,密码改成初始密码b,并登录验证成功; 8、重新创建自动备份维护计划成功; 9、右键维护计划-执行; 10、执行结果成功; 疑问: 为什么修改密码后创建的自动备份执行失败?而改回初始密码就能执行成功?
What SUBSTR() or IN is faster in Oracle?
Would WHERE SUBSTR(my_field,1,6) = 'search' or WHERE my_field IN ('a','b','c','d','f') be faster in Oracle, or would there be no difference? I cannot create temp tables and haven't got the execution plan. Thank you in advance!
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
How to change MS SQL services password (without locking an account out..?)
Hello ALL We have a very strange situation and I need your advice. We have AG of two servers and...somebody have missed an SQL Server service account password. Nothing critical, test envirounment. We have changed user's password in AD Users and…
![](https://techprofile.blob.core.windows.net/images/_rrUsGA7eEymEaRxluLA6A.png?8D849E)
![](https://techprofile.blob.core.windows.net/images/_rrUsGA7eEymEaRxluLA6A.png?8D849E)
CDC for Oracle by Attunity - license/support
Hi. We need help on questions regarding CDC for Oracle by Attunity (Service/Designer) from Microsoft Do we need to get a license from Microsoft in order to use this product? (we are currently testing the product with the Service/Designer clients) …
Begin tran and row lock
Hi, I'm using begin tran in my code and with this command - I update a row, it locks the whole table, but i want to lock only the updated rows. any idea?
Parallelism when execution cost lower than Cost of parallelism
why is that.? my cost of parallelism is default 5
Trancate table and LOB data
where there are still LOB allocation unit after the table is truncated ?
How to upgrade SQL 2017 Evaluation to Developer
How do I upgrade SQL 2017 Evaluation to Developer? I have installed SQL 2017 evaluation edition and been using it for 188 days while I waited for approval to purchase the developer edition. There is not a SQL product key available to insert.
Rebuild index on a 5TB database
We have 5 TB database and the rebuild index job is taking days to complete. Is there a way to rebuild indexes on chunks of tables/indexes. For eg, rebuild index on first chunk, then on the next chunk and so on. Please let me know
sys.dm_tran_version_store how to check which row from the table
How to check sys.dm_tran_version_store how to check which row from the table the records are originate from which row from the original table ? and from which transaction ?
Containment (Simple) vs Containment (base):
Containment (Simple) vs Containment (base): Containment (Simple): Users query for data that exists. For example, for an equality join between two tables, factor in the predicates selectivity1 in each input histogram, before joining histograms to…
Online rebuild index ABORT_AFTER_WAIT = NONE
ALTER INDEX clidx ON parttable REBUILD WITH (ONLINE=ON (WAIT_AT_LOW_PRIORITY ( MAX_DURATION = 5 minutes ,ABORT_AFTER_WAIT = NONE))) So in this case, the rebuild index will wait for another 5 minutes, if it was first blocked already by…