SQL Server Reporting Services 2019 licensing
Hello Can someone please help clarify the below for me. I know SSRS installed separately, My question is, isn´t SQL Server Reporting Service (SSRS) delivered as a part of the SQL Server Standard and Enterprise editions? Or does it require a…
SQL Query Date between not filtering properly
I am querying using my SQL table and trying to form simple date between query. when i am querying, i am not getting properly correct rows. My SQL Column is : DOJ (Datatype is datetime) and sample data is…
Question on Dimension Security in SSAS cubes
Dear Team, Looking for help on below technical knowledge. This question is for MSBI - "SQL Server Analysis Server " Is it possible to create a security for entire dimension in "dimension data" tab of "Roles" window. For…
How to load the data from source when there are two delimiters using SSIS?
Below is my data in source document. The document has two delimiters like tilde(~) and pipe(|).. ~id~|~name~|~gender~|~age~ ~101~|~ABC~|~M~|~28~ ~102~|~DEF~|~F~|~27~ How can I load the data into SQL table Emp? Please look into this and do neeedful Thanks…
Sql join query with total row
Hi , please help create table #temp (LedgerID INT, Amount Decimal(18,3)) insert into #temp (LedgerID,Amount) values (121,100),(121,250),(129,25),(129,200),(158,100),(158,500),(157,250),(157,100),(48625,1000) CREATE TABLE #temp_table ( cid INT, type…
SP execution time varies with different environment
Dev environment is restored with the latest Test. When a SP with same set of parameter is executed against Test as well as Dev, the execution time is differing with both the environments. In Test it takes 1.45 mins, whereas in Dev it is 3.16/3.08…
How to check for tag existence in XML colum
Good day, I have a complex XML stored in a table's column which may or may not contain the following tag <D_STC12_FreeFormMessageText> How can I select all rows containing this tag? Example from one of XMLs: <D_STC12_FreeFormMessageText>H…
Opening sql files opens new instance of SSMS 18.
Hi, I installed SSMS 18.7.1 in my new laptop and every time I open a new .sql file via double click on it, it opens a new SSMS instance. Its very frustrating. I have repaired SSMS and tried to reinstall again but nothing helped! But if someone had…
Change DB owner while it's being used?
Hello I'm trying to change the owner of an active SQL 2014 DB using: ALTER AUTHORIZATION ON DATABASE::[TargetDB] TO LoginNameOwner; When I run it it seems to hang and notice causes Blocking so I cancel above statement. While running above there are…
Queries with EF Core causes 'Cannot continue the execution because the session is in the kill state'
Some EF Core queries are throwing the following error in our code : Cannot continue the execution because the session is in the kill state. Une erreur grave s'est produite pendant la commande actuelle. Les résultats devront être supprimés, le cas…
Export Query Results as CSV WITH Headers
I just need to get my query results out to a CSV file WITH Headers quickly (without going through the whole SSIS process for a one-off job). I thought the option below would do the trick, but I get a CSV WITHOUT Headers. Advice?
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
Sql server Metrics : is 100% CPU percentage is a blocker for all DB operations?
HI All We have observed a case in our database where the CPU perncetage is 100% for quite some time but my application are still able to hit & operate over DB, is 100% CPU usage isnt a blocker for DB operations ?? I see 2 CPU metrics 1) CPU…
Matrix's backgroud color
HI, I NEED A HELP I HAVE A MATRIX, AND I WOULD LIKE TO CHANGE THE BACKGROUND COLOR WHEN THE AGREGATED VALUE IS UNDER THAN 92K. I TRYED TO USER A SIMPLE SWITCH OR IIF (IN TABLIX ITS WORKS FINE), BUT IT CHANGE ALL CELLS IN THE MATRIX... HOW CAN I DO THIS…
update all DB
I want to update the cells with the value "ABCD" to "XYZW" in all tables in the DB.
Steps to use Cyber Ark to manage Data Source Credentials with on Prem Power BI report server
Hello, I am getting mixed results when trying to determine if Power BI report Server can use Cyber ARK PVWA for managing Data Source account passwords. Using PVWA enables Web application to connect to a credential managed Vault to retrieve service…
SCCM Database Replication
Hello, There is link degraded between CAS and Primary. spdiagdrs output shows that some replication groups are under degraded state. Please help to understand this replication and degradation. Share any article to read about the same. How to solve this…
SQL Sever migration - SQL 2014 to 2022
Checking on migration option for SQL Server upgrade from SQL 2014 to SQL 2022. Installing separately 2022 in the same server and move the DBs & setups to the new Server. It is mentioned here, that "System databases can be restored only from…
Help in SQL Conversion query
How I can convert Total column from varchar to numeric to show result in numeric with two decimal using SELECT query. Create table #temp (Num1 numeric (6,2), Num2 numeric (6,2), Num3 numeric (6,2), Num4 numeric (6,2), Total varchar(200)) insert into…
error while installing SQL express edition
Hi everyone, im trying to install the SQL express edition server but getting this error and not sure how to approach, installation error It says Oops installation initialization successful
Is there a way I can tell which account turned off the SQL Server Agent?
I have a little situation that I'm left searching for answers for. Some person or process (I'm being generous as I don't, for one second, believe the culprit is a process) stopped my database server's SQL Server Agent several days back and I'd like to…