SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• New SSIS Package fails in Sql Agent when it includes a script component

  I'm creating a new SSIS package using VS2022 to target Sql Server 2019 server. I have ended up with…

  Grant McAllister

  9 replies

  10 months, 2 weeks ago

  By: Grant McAllister

• How to speed up this query?

  Hi everyone I have a query that is taking a real long time.  It takes close to 30 minutes to proces…

  water490

  6 replies

  10 months, 3 weeks ago

  By: Ken McKelvey

• Restore Procedure not working

  I created a small procedure that reads the backup file and restores the DB daily. But when I execut…

  Chitown

  7 replies

  10 months, 3 weeks ago

  By: Chitown

• Aggregate Data to New Table

  Hi , I am using webedition of 2019 MSSQL on AWS. I don't have SSAS or other license . I have a big …

  thbaig

  4 replies

  10 months, 3 weeks ago

  By: Phil Parkin

• funny character shows in one hdg name in ssis flat file connector

  hi, i spent some time today in an existing pkg replumbing 5 flat file connectors to new tsv files. …

  stan

  6 replies

  10 months, 3 weeks ago

  By: frederico_fonseca

• how to generalize the LAG function so it keeps looking until a value is found?

  Hi everyone There are situations where a value for a particular day is NULL so I use the previous d…

  water490

  3 replies

  10 months, 3 weeks ago

  By: water490

• Need a list of stored procedures that execute multiple stored procedures

  Hello SSC! I hope you all had a happy and safe holiday! Apologies if this post is confusing... I ha…

  Lord Slaagh

  5 replies

  11 months, 1 week ago

  By: Lord Slaagh

• What is the best index strategy for a table that gets truncated?

  Hi everyone My SSIS package does a bulk insert of csv files into a table called tableA.  The nature…

  water490

  6 replies

  11 months, 2 weeks ago

  By: ScottPletcher

• how can i tell if our db2 driver is ms or ibm or other?

  i see this in the definition of a linked server on our wh sql server that i know is db2 based... @p…

  stan

  1 replies

  11 months, 3 weeks ago

  By: stan

• Best Clustered Index Configuration for Partitioned Multi-Tenant Table with RLS

  I’m working with a SQL Server database that supports a multi-tenant application. We have row-level …

  Jonathan AC Roberts

  20 replies

  11 months, 3 weeks ago

  By: Jonathan AC Roberts

• ssrs order of operation question

  hi i need "sample size" in my report's 4th data region which is a grid with 2 additional full grid …

  stan

  5 replies

  11 months, 3 weeks ago

  By: stan

• How to write this query?

  Hi everyone I have two tables storing stock prices.  Each table comes from a different source so th…

  water490

  6 replies

  11 months, 3 weeks ago

  By: water490

• Linking 2 SQL Databases

  Hi All I am a complete novice so I apologise for any incorrect terminology. What I am trying to do …

  SimonLM

  7 replies

  11 months, 3 weeks ago

  By: Phil Parkin

• cannot read the next data row for dataset x

  Hi, a peer asked me today to help on this ssrs error.   There is a lot going on in this report but …

  stan

  4 replies

  11 months, 4 weeks ago

  By: stan

• Error loading multiple CSV files in SSIS

  Hi everyone I have a bunch of CSV files that I need to bulk insert into a table.  I saw this video …

  water490

  19 replies

  11 months, 4 weeks ago

  By: Phil Parkin