Here's a few of the new posts today on the forums. To see more, visit the forums.
|
| SQL Server 2017 - Administration |
| user mapping error - Hi All, We have recently migrated SQL 2012 EE to SQL 2017. We are on Microsoft SQL Server 2017 (RTM-CU22) 14.0.3356.20 (X64) EE. Using SSMS, I have logged into SQL 2017 instance as a sysadmin role member and when I go to a specific login -> right click --> Properties -> User Mapping , I […] |
| SQL Server 2017 - Development |
| Using hierarchyID - Hell community, This is my first to try to use hierarchyID, but on my example above my column PATH return always NULL. What i am doing wrong !?? CREATE TABLE #tbl( ID int, ParentId INT, Name VARCHAR(30), [path] hierarchyid null ); --DROP TABLE #tbl INSERT INTO #tbl VALUES (1, Null, 'Corporate_HQ',null), (2, 1, 'South_Region',null), (3, […] |
| SQL Server 2016 - Administration |
| Simple Recovery Model - Active VLFs cannot be truncated - Hi everyone, I am facing a strange situation. I've got 99% of VLFs active and ckeckpoint is not working. No open transactions/long-running transactions. Is there any chance log is holding active VLFs by mistake? Is there any rare situation sql server considers VLFs are active? Some details: SELECT [name] AS 'Database Name', COUNT(li.database_id) AS 'VLF […] |
| Backup time not reducing even after DB size went down 300 GB - Backup time is almost same and did not reduce after the database size went down by 300 GB. What could be the reason? Thanks in advance. |
| Mirroring Automatic Failover?.. - Hello, We are receiving the below Error message in Mirroring and principal server is failovering automatically to Mirror Server. Database mirroring connection error 4 'The connection was closed by the remote end, or an error occurred while receiving data: '64(The specified network name is no longer available.)'' Database mirroring connection error 4 '10054(An existing connection […] |
| Replaced deprecated types (text, ntext) with Varchar(max) and NVarchar(max) ! - in 500 tables, on thousands of columns in all databases on entire server, I have replaced deprecated datatypes (text, ntext) with Varchar(max) and NVarchar(max). To detect them and to generate modification scripts, PLEASE HELP YOURSELVES to my and Victor's attached new SP named asp_Get_DeprecatedDatatypes_Columns_withgeneratedmodifyDDL /*Usage examples-are-in-comments-header, you can compile and run it in any database […] |
| Development - SQL Server 2014 |
| Query performance with ROW_NUMBER function - Hello All, Could any of you please let me know why the row_number paging function is having a performance issue when using the "WHERE results.ROWNUMBER BETWEEN 1 AND 50" clause (takes more than 2 mins), but runs in 5 secs when i comment the where clause which will return the entire result set. I see […] |
| SQL Server 2019 - Administration |
| multisubnet configuration - Good morning all , I am in an alwayson multisubnet configuration, the listen and configured with 3 IP addresses in the configuration of my application I am unable to set the value multisubnet failover = true it is an installation script where there is only icon to put the name of the server and the […] |
| client server encryption - Good morning all , how can I check if SSL encryption is enabled on my SQL server, I only have SSMS access on server I have no RDP access on the server I cannot access the service configuration manager to see if this option enabled my problem comes during the installation phase of the application […] |
| Sql server does not go above 50% CPU - Hi everyone, I have this issue: in a single complex processing performed in a virtual machine with 4 virtual processors and 4 sockets, the CPU never manages to exceed 50% thus doubling the previous runtime when it was performed on a physical server. Is it possible that there is a limit imposed by SQL server […] |
| SQL Server 2019 - Development |
| How to rank the records - I am trying to figure how to create rank column in my query with the below logic. I need to group by item category and then rank them by ordbo. Any help appreciated |
| IDENTITY only allowed on one table at a time? - I am trying to insert some sample data into my database. I ran the INSERT INTO Statements and got the following messages: /* ***************************** * Data Entry Statements for * * Project ACES * * Version 1.1.0 * * Written By: Russell Wright* * Updated by: Russell Wright* * Created: 11/20/2020 * * Updated: 11/20/2020 […] |
| Reporting Services |
| tablix hierarchy - Hello, I would like to have the below requirement in the tablix to call each sub-report for every Code but I am unable to do this. Any suggestions please? Thank you Requirement : Code --> Tablix is grouped on this field Title_1 --> Title as the header for the following subreport subreport_1 --> Detailed row […] |
| Unable to delete older report - Hallo All, Couldn't able to remove the older report folder , tried possible ways though giving an error stating with below message. Please help me out here. Thank You. An error occurred within the report server database. this may be due to a connection failure, timeout or low dis condition within the database. |
| Analysis Services |
| Table.NestedJoin in Azure Analysis Services - We have an M/Power Query query in Power BI that uses Table.NestedJoin. However, we get errors when we try to use that same command in Azure Analysis Services. Does this command even work in AAS? I don't see any examples of it working properly. Is there a workaround? |
