Here's a few of the new posts today on the forums. To see more, visit the forums.
|
| SQL Server 2017 - Development |
| Which command will using to delete all rows from table truncate or delete ? - I work on sql server 2017 i need to delete all rows from table student_course but i don't know use delete from student_course or truncate table student_course table student_course studentid pk courseid pk table student table studentid pk table courses courseid pk --------------------------------------------- student_course table have relation with courses table and student table so which […] |
| Query nested JSON data - table structure create table dbo.commodityIndex(sucess varchar(10), [timestamp] varchar(100), [date] date, base varchar(10), rates decimal(10,2), unit varchar(10) ) JSON data is as follows: How do I query the nested piece in rates? declare @json1 VARCHAR(MAX); set @json1 = '{"success": true, "timestamp": 1650998580, "date": "2022-04-26", "base": "USD", "rates": {"USD": 1, "XAG": 0.042738743354897, "XAU": 0.0005276742457391, "XPD": 0.00047847992351816, "XPT": […] |
| SQL Server 2016 - Development and T-SQL |
| query execution plan differ when run as a single query vs. in a sp - I have a SQL statement with a single int parameter. When i run it as a query, it uses index seek from both tables in the join and took seconds to finish. But if I put the same query in a stored procedure, and pass in the same parameter value 38176, it uses index scans […] |
| SQL Server 2012 - T-SQL |
| My calculation with a CASE statement isn\'t working - I'm scratching my head over this. I'm sure it's something simple, but I'm stumped. I have the following T-SQL: DECLARE @MAX_naam AS varchar(MAX) = (SELECT SUBSTRING(MAX(naam),LEN(MAX(naam))-1,LEN(MAX(naam))) FROM incident); -- = 22 DECLARE @maxnaam_length AS int = LEN(@MAX_naam); DECLARE @num_zeroes AS int = 5 - @maxnaam_length; DECLARE @zeroes AS varchar = CASE WHEN @num_zeroes = 0 […] |
| SQL Server 2019 - Administration |
| What are the tools available to replicate an SQL server, including a third party - In sqlserver we have replication which basically syncs our data between two disconnected database over the internet. so pls tell me what are the other tools availabel in the market like amazon sync and azure data sync etc etc. |
| Regarding Heterogeneous Database Replication - Team - Is Heterogeneous Database Replication still supported in SQL server? I am specifically looking for Publishing data To and From SQL server and SQL Anywhere(Sybase). if you have a good references, let me know. Thanks. |
| SQL Server 2019 - Development |
| Is it correct that MS SQL automatically retrieves data to optimize the "SELECT" - Hello, Is it correct that MS SQL automatically retrieves data to optimize the "SELECT" statements? Example: If I have a table with 1 million records and I run SELECT for the first 1000 records, then for the next 1000 records and so on.... Is it right that MS SQL recognizes the pattern and preprocesses the […] |
| SQL Azure - Development |
| Is this right approach to implement nested Transaction - Hello Everyone, I am using Microsoft SQL Azure (RTM) - 12.0.2000.8. I have a store procedure as below. ALTER PROC [dbo].[usp_SAP_to_IC] -- exec [dbo].[usp_transfer_on_premise_project_data_to_cp_database_IC_12] AS BEGIN TRY BEGIN TRANSACTION; EXEC [dbo].[usp_transfer_on_premise_project_data_to_cp_database_IC_12] EXEC [dbo].[usp_transfer_on_premise_project_data_to_cp_database_IC_10] EXEC [dbo].[usp_transfer_on_premise_project_data_to_cp_database_IC_7] COMMIT TRANSACTION; END TRY BEGIN CATCH INSERT INTO ExceptionLog ( ErrorLine, ErrorMessage, ErrorNumber, ErrorProcedure, ErrorSeverity, ErrorState, DateErrorRaised) VALUES (Error_Line(), Error_Message(), […] |
| Does "Azure SQL Managed Instance" support publication distribution of transactio - Hi, I want to implement transactional replication on a database which should be on "Azure SQL Managed Instance", where entry will be done. And the subscriber which will be read only and will be "on premises" (that is with our site offices) |
| SQL Azure - Administration |
| in Azure SQL Managed Instance do we get sql server or we have to purchase and in - I am using aws rds where we get a sql server we have to just restore our database and we are good to go. pls tell me the the Azure SQL Managed Instance also works same for the above case.ss |
| Amazon AWS and other cloud vendors |
| does aws rds supports pulication and distribution of sqlserver replicaltion - hi, i wanted to implement transactional replication or mearge replication on aws rds , but one artical said they only allow subscription , is it true, that is can i make publication and distribution on aws rds in any way? like if i make publication on rds and distribution on aws windows server. q2) is […] |
| What is the best way to execute ~100 I/O bound scripts? - As the title suggests I am looking into ways of executing a lot of scripts as fast as possible. This is something I’ve never done before so not entirely sure how to approach it just yet. Originally, I thought of setting up a cloud formation template with the same number of instances as there are […] |
| General Cloud Computing Questions |
| host to client redirect - We are running a hybrid datacenter in MS Azure and on-prem. The users connect to the session hosts by MS Remote Desktop Services. The hosts are running Windows Server 2019. We need a way to redirect requests to open some file type on the loacl client. For example links should be opend with the brwoser […] |
| Reporting Services |
| Adding a table with dynamic rows - I have a need to have a table in SSRS based off of a field in the dataset. There is a field (fquantity) that has a numeric value say 50. but the dataset only has 3 records in it. I need to create a table with say 5 columns and 50 rows. Fquantity will change […] |
| Integration Services |
| How to Cast Big Int column to datetime2 or Varchar - I have SSIS Package , in the source query i am using parameters to pull data greater than from that date. Process is here. step 1 - Created Variable StdDate with datatype String. Step 2 - execute sql task to get the date column with datetime2(7) datatype from control table. Sample value looks like 2022-04-26 […] |
