Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2016 - Administration |
SQL server native CDC - Have anyone implemented CDC, and if so, what has been your experience with it? We are considering using this CDC data as the foundation for our ETL process, which will also support our Audit database. We have around 100 tables that we need to put in CDC and then use them in our ETL process. […] |
SQL Server 2016 - Development and T-SQL |
process records in loop - I'm only processing 50,000 records not everything from the Table where there are 250,00 records. What have I done wrong in code Thanks. DECLARE @BatchSize INT = 50000 DECLARE @IdControl INT = 1 DECLARE @Results INT DECLARE @SQLString NVARCHAR(MAX); DECLARE @ParmDefinition NVARCHAR(MAX); WHILE (@Results IS NULL OR @Results > 0) BEGIN print @IdControl print @BatchSize […] |
SQL Server 2019 - Administration |
client_app_name is empty in Extended Events output but present in sp_who2 - I'm tracing activity on one database and would like to include the client_app_name in the output. However, for *some* applications, this information is blank. However, if I run sp_who2 at the same time, I can see the ProgramName column is populated. Is there somewhere else that extended events stores this information or is it just […] |
Restore dbs - The below code works for backup files only from local drives. When replaced with a network path the code just runs through but does not restore any dbs. SET @backup_path='\\ABCD\E$\BackupsTest\' ; - Does not work. Where is it going wrong ? DECLARE @backup_path nvarchar(300); DECLARE @restore_path nvarchar(300); DECLARE @cmd nvarchar(1000); DECLARE @file_list TABLE (backup_file […] |
SQL Server 2019 - Development |
How to check for data loss after rollback - Hello SSC, I am not a DBA,. I have some DBA knowledge, but my education is all programming. I had a production deadlock that took over 30 hours to rollback. I am concerned about data loss, but I have no idea how to troubleshoot this. I have a bunch of logs from the DBA's, so […] |
Sort comma delimited string in column - I have a column that contains comma separated values. I'm trying to figure out how to sort the comma separated values by a certain order. The sort order will be hard coded in the select statement since it does not exist in a table. I've tried using STRING_AGG WITHIN GROUP to sort the values but […] |
SQL Azure - Administration |
Aligning Compatibility Version Strategy - I have joined a new project, where the business uses Azure SQL Hyperscale for production. I have noticed that some Prod environments have compatibility levels set to 150, but some - 140. Same applies to Dev / Test SQL 2022 environments. I have been given a task to come up with a strategy on how […] |
azure synapse analytics - Dears, Hope this message finds you well I did not see in this foruns anything related with synapse, hence, if you don't mind I will add my questions here. Maybe you can help me In my company (for which I was now contracted as IT architect) I can across something which seems unusual to me […] |
Amazon AWS and other cloud vendors |
AWS RDS for SQL Server - Backup to/Restore from s3 - Multiple Account Scenario - Hi All, I need a sanity check, and hoping someone here can provide it.... Environment: Prod Instance - AWS ec2 instance running SQL Server (2022) in "Prod Account" s3 Bucket in "Backups Account" Dev Instance - AWS ec2 instance running SQL Server (2022) in "Dev Account" Use Case: Need to be able to execute weekly […] |
Reporting Services |
Report definition has an invalid target namespace - I'm hoping someone here has encountered this before and was able to fix it. I've got a client with SQL Server 2014, they also use SSRS and asked me to create a new report to get automatically run every week. I created the report on my computer using Report Designer but when they tried to […] |
General |
How to create a baseline using counters to analyze server performance? - I am currently working on creating a baseline for our server, using various counters to analyze performance. The server exclusively hosts SQL Server. Could anyone here share their experiences or methodologies on how to create such a baseline and use it for performance analysis? |
Integration Services |
Query about GAC (Global Assembly Cache) - Hi everyone, So I have a SSIS package that performs some importing/exporting from MySQL database. This SSIS package uses code written in Script Task C#. To make connectivity to MySQL server, I have used MySql.Data Nuget package. When I installed this Nuget package I had to manually add "MySql.Data.dll" file into GAC otherwise there were […] |
SQL Server 2022 - Administration |
Import and Export wizard stuck on Guest user - I'm getting a error when using the Import and Export wizard to copy tables between a remote database and a local database using the Microsoft OLE DB Provider for SQL Server as Data Source. The remote DB uses SQL Server authentication and the local DB uses Windows authentication. Regardless of which database is the Source […] |
SQL Server 2022 - Development |
More fun with Recursive CTEs - Instead of dealing with courses this time, I'm trying to sort out how to model a recipe problem. (It's bread, so it's not crazy complex.) Oh wait, here... have some table definitions: USE [Bakery] GO /* Sorry, this started in Abscess */ CREATE TABLE [dbo].[Ingredient]( [IngredientID] [int] IDENTITY(1,1) NOT NULL, [IngredientName] [varchar](255) NOT NULL, [UnitPrice] […] |
How to compare data in customer table with other customers to find related cust - select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer c where Active='Y' -- About 1.5 Million Records Here in this sql server table, I have customers table, custno is unique id. we are trying to grouping customers and give one ID lets call it groupingID. INSERT INTO customer (Custno, Addr1, […] |