Here's a few of the new posts today on the forums. To see more, visit the forums.
|
SQL Server 2017 - Administration |
java.sql.SQLException: Cannot create PoolableConnectionFactory - Application team get this error once application server undergoes reboot and this gets fixed when they do application cache load. Any ideas on this error. java.sql.SQLException: Cannot create PoolableConnectionFactory The TCP/IP connection to the host has failed. Error: "null. Verify the connection properties. Make sure that an instance of SQL Server is running on […] |
Join Only Option - Always On - Hi all Hopefully a fairly simple question to start things off after a long time absence I have a requirement to add another node to a current Always On system but the change window to do the work is short so I was thinking to save time I could manually restore the databases to […] |
SQL Server 2016 - Administration |
Intermittent sqlmail success - troubleshooting - Microsoft SQL Server 2016 (SP2-GDR) (KB4583460) - 13.0.5103.6 (X64) SQLMail Account configured with SSL checked and Basic Authentication account to smtp.office365.com Suddenly last week emails stopped working. First we thought it was TLS version configuration issue but after I set it up as a scheduled task running every minute I realized the email works SOMETIMES. […] |
SQL Server 2016 - Development and T-SQL |
Execute SQL Task error (SSIS) - I am getting this for a simple SQL statement: [Execute SQL Task] Error: Executing the query "" failed with the following error: "". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. update payments1 set [LineItem Amount] = replace([LineItem Amount],'$(','-') It does not […] |
Restart SSA in a job? - Hi, I have a job that rebuilds indexes after a refresh of a replicated report DB. The issue is sometime I need to restart the SQL Server Agent to get it to start. Is there a command I can use to first restart it? Thanks |
T-SQL help - I need help to write the T-SQL with scenario that if room got multiple room_cd and flagged with M and F then room_type will be flagged with majority of M or F like in 106, with room 1 got 1 to 3 room_cd and flagged with both M and F , but there are 2 […] |
SQL 2012 - General |
what this constrain meaning ? - I work on sql server 2012 i see constrain but i don't know what is meaning ALTER TABLE [Parts].[TradeCodes] ADD CONSTRAINT [UC_PartCode] UNIQUE NONCLUSTERED ( [PartID] ASC, [CodeTypeID] ASC, [PartLevel] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] […] |
How to get feature key and feature value separated $ based on part id ? - I work on sql server 2012 i need to get featurekey and feature value separated $ Based on partid but i don't know how o do that by select sql query ? expected result as below sample data create table #PartsFeature ( PartId int, Featurekey nvarchar(200), FeatureValue nvarchar(200), ) insert into #PartsFeature(PartId,Featurekey,FeatureValue) values (1550,'Botato','Yellow'), […] |
SQL Server 2012 - T-SQL |
Update table FirstName & LastName from Email addresses - I have a table with three fields, FirstName, LastName and EmailAddress. The EmailAddress field is already populated and follows a 100% consistent format e.g.: John.Dunne@MallWins.com, Lisa.Franklin@MallWins.com, Mary.Renaldo@MallWins.com, etc. I need to write an update query that will populate the FirstName and the LastName as one batch. I tried this to do just the FirstName and it gives […] |
SQL Server 2019 - Administration |
SQL Instance Aliases - Urgent assistance needed please - I have a migration problem. I cannot get my SQL Server instance aliases to work remotely. I've set up aliases before, and I've double-checked everything. The assigned ports are open, the protocol has been updated with the correct port, the aliases are set up in both spots on the config manager, browser is running, TCP […] |
Error connecting using AlwaysON Listener - Dear Friends, I have a 2-node Read-Scale Always ON Availability Group to which I added a Listener. Though no issues during the creation of the Listener , the connection to the instance using the Listener is not possible. Just can't get through. Wondering if it has to do with the Name Resolution , or it […] |
Setting Up SQL Server 2019 for Optimal Performance - Hi I have a very large database (600GB) that I am looking at creating. I will be running finance data analytic algorithms. I am considering AI algorithms too as the second project once the main one (data analytics) is completed. The AI will also be finance related. I have not decided if I should go […] |
SQL Server 2019 - Development |
OK, I still think like a programmer -- is there a better way to do this? - My SQL tools tell me this invokes an inefficient step with an index scan. I am treating this as a learning exercise since it's not really a problem, but I have code written by others (vendors) that I see this a lot and I'd like to be able to suggest fixes. The query plan is […] |
From the sys.sql_modules (linked.db.schema.vw_xxx) seperate column - Hi All, Im working an a issue and have some thinks I would like to fix it. At moment I need the definition of a all views, im jusing the follwoing query to find the definition (SYNTAX): SELECT definition, uses_ansi_nulls, uses_quoted_identifier, is_schema_bound FROM sys.sql_modules WHERE object_id = object_id( 'view' ); All the views is a […] |
Analysis Services |
SSAS partitions delete - .prt files not deleting - I have an unusual problem with an existing cube. When I delete a partition using SSMS or xmla the partition deletes from the cube successfully in SSMS. However, the physical files are not deleting from the server. Does anyone know why this is happening and how to correct it? thanks Jason |