Here's a few of the new posts today on the forums. To see more, visit the forums.
|
SQL Server 2016 - Administration |
TLS 1.2 communication problem - I'm trying to get 2 servers to communicate using TLS 1.2. On the calling web sever I have disabled TLS 1.0 and TLS 1.1 - leaving TLS 1.2 enabled. On the SQL Server TLS 1.0, 1.1 and 1.2 are all enabled. I have installed MSOLEDBSQL driver on both servers. The database server is running SQL […] |
Automate loading data to SQL Server 2016 from Oracle DB - Hi SQL Server Mentors, We have a table in SQL Server 2016 that is frequently feeded up with data from an Oracle DB table based on a Query. I do it manually thru SQL Server import and export wizard. However I need to automate it as a batch process or stored procedure. Please advise me […] |
SQL Server 2016 - Development and T-SQL |
How To Re-Insert a Row with Identity Value - I have accidentally deleted a record which originally looked like this: But now looks like the following: As you can see row, 515 13 DriverId has been deleted. I want to re-insert the row with ColumnID 515, however because ColumnID is an Identity value i.e. Auto-Increments I can only enter a row with ColumnID […] |
Administration - SQL Server 2014 |
security related question - Hi All, Have a question regarding database roles in SQL Server. While assigning the database role for a database user, we have roles like db_datareader & db_writer roles. Similarly, we have db_denydatareader & db_denydatawriter roles. My question is, what is the use of these 2 deny roles. If I don't want to a user to […] |
Development - SQL Server 2014 |
Bulk Insert - Only Half the Records - I am having a hard time with this. I am trying to load a *.txt file using BULK INSERT, but no matter what I do, it seems to only load about 50% of the records. Our *.txt file has two rows of "header" data, and one row of "footer / trailer" data. Unfortunately, this is […] |
SQL 2012 - General |
How to get Feature Name and Feature Value separated by $ for table AllData ? - I work on SQL server 2012 I face issue I can't get Feature Name and Feature Value for Table All Data From table Part Attributes Feature Name and Feature Value exist on table Part Attributes full sql structure and query found here https://www.mycompiler.io/view/3LncvaR UPDATE Codes SET Proceed=0 DECLARE @Code VARCHAR(20) DECLARE @ZPID INT DECLARE @Sql […] |
SQL Server 2012 - T-SQL |
Query runs slow sometimes and sometimes runs superfast (2 minutes vs 2 seconds) - This query runs very slow at times and very fast at time. What could cause this behavior? i checked the slowness is coming from auditLog table. Its a big table as it stores audit records. But still cant figure out why its very slow at times. select * from ( SELECT coitem.[ship_site] ,custaddr.[name] ,coitem.[co_num] […] |
SQL Server 2019 - Administration |
Permissions Error Running DTEXEC on SQL Agent job - For "reasons," our corporate office is requiring us to move all our SSIS packages to the SAN share on our servers and call the package with a Command Operating System task. It's incredibly frustrating but we've done it before on SQL 2005, so it's not unknown to us. Unfortunately, SSIS now requires administrator access to […] |
Monitoring system - We are setting up Idera SQL DM system to monitor our SQL Server's. So we have availability group setup for the repositories at database level. Looking for option to see if anyone has done application HA? If yes, could you please shed some light on the application clustering for Idera SQLDM tool. Thanks in Advance! |
SQL Server 2019 - Development |
How to retrieve a number in range that matches another number - Ive got a lookup table with a set of values . this is as follows DROP TABLE IF EXISTS [dbo].[SIData_NTILE_Test_20211012_6months_MainLevelData_TableRecordCounts] CREATE TABLE [dbo].[SIData_NTILE_Test_20211012_6months_MainLevelData_TableRecordCounts]( [ID] [int] NULL, [NumbeOfRecords] [decimal](15, 6) NULL, [NumberOfGroups] [int] NULL, [TimeInterval] [decimal](15, 6) NULL ) ON [PRIMARY] GO INSERT [dbo].[SIData_NTILE_Test_20211012_6months_MainLevelData_TableRecordCounts] ([ID], [NumbeOfRecords], [NumberOfGroups], [TimeInterval]) VALUES (1, CAST(1555201.000000 AS Decimal(15, 6)), 1944, CAST(8000.000000 […] |
SQL Server Job Agent - The workgroup file is missing - Hi firstly im sorry if this is in the wrong place, i couldnt find a ssis forum. I have been working with a mariadb, trying to get the data into sql server. A very long way around it maybe but i found one solution to create a linked table in access and then import the […] |
Azure Data Factory |
Pass a list in a stored procedure in ADF - Hi there i m stuck in how I can pass a list of parameters using the copy data on Adf is it a limitation with the tool ? does anyone know ? my sp is running as exec sp1 @var1 when u declare and save the values in that variable it runs fine any pointers […] |
SSRS 2016 |
SSRS: Possible Transition to PowerBI? - Hello, All: I was wondering if anybody has made a full transition from SSRS (2016) to PowerBI? Are there any difficulties involved with converting SSRS reports to PowerBI? Are there tools that can already do this, or will it be a slog of rebuilding them Report-By-Agonizing-Report (with apologies to Jeff Moden)? Thank you in Advance! […] |
General |
How to learn SQL? - Hi everyone, I would like to learn MySQL, and can anyone share some tutorials with me? I have been googling but I decided to join a community and ask the experts for the advice |
Integration Services |
Help Converting Query For Hierarchical Data - I have a working query within MySQL based on (Managing Hierarchical Data in MySQL - http://mikehillyer.com/articles/managing-hierarchical-data-in-mysql/). The problem I have is that I need to implement the same functionality on another piece of software which uses MSSQL. The two issues I am facing is that it doesn't seem possible to group/order within subqueries in MSSQL, as it […] |