SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• How to calculate potential IO benefits of changes

  I work on a multi terabyte warehouse database application which typically ingests between 130 and 1…

  Jez-448386

  27 replies

  1 year ago

  By: Jez-448386

• ssis dashboard suddenly missing from reports option under catalog/ssisdb

  hi i rt clicked ssisdb today under integration services catalog , chose reports and didnt see the d…

  stan

  2 replies

  1 year ago

  By: stan

• checking on some restrictions related to functions

  hi i'm helping a friend on his creation of a function.   here are the issues... he's getting an er…

  stan

  1 replies

  1 year ago

  By: frederico_fonseca

• Is there a way to automate odbc configuration so you don't have id and password?

  Is there a way to automate odbc configuration so you don't have id and password? I need to automate…

  hillbillycarl

  2 replies

  1 year ago

  By: hillbillycarl

• Why am I getting a "Incorrect syntax near '@tblName' error message?

  I'm working on a SQL script to delete all old tables starting with the name of "Old_". I'm testing …

  Rod at work

  5 replies

  1 year ago

  By: Jeff Moden

• Execute SSIS generates error "create_execution has too many arguments specified.

  We recently upgraded our Dev server to SQL 2019.  Since upgrading, whenever we run an SSIS package …

  darrin.wilkinson.66

  2 replies

  1 year ago

  By: jorcaraballo@gmail.com

• Lag function on an update not working

  I have a table with odds from sportsbook, and I need to populate a gamedate value that is null . Th…

  Zososql

  3 replies

  1 year ago

  By: Zososql

• can my phone run ssms inside our firewall?

  Hi my phone is now upgraded to allow teams , outlook etc using my work account.   Its a portal more…

  stan

  3 replies

  1 year ago

  By: Mr. Brian Gale

• what have people done for ssrs params needing very precise start and end times

  Hi we run 2019 standard.  one of our mfg locations requires somewhat precise start and end param ti…

  stan

  2 replies

  1 year ago

  By: Jeff Moden

• is netsuite's analytics warehouse (NSAW) a viable alternative to the sql stack?

  Hi our corporate level warehouse currently sits on sql server 2019 standard where some cubes also r…

  stan

  1 replies

  1 year, 1 month ago

  By: stan

• error in both ssis and ssms - something about losing connections - new error

  hi for about 4 or 5 days now, i've been seeing various connections (to our dw server) issues in ssi…

  stan

  11 replies

  1 year, 1 month ago

  By: stan

• UPSERT question for performance and efficiency

  Hello SSC! First, I would like to thank everyone for responding to my posts. It is greatly apprecia…

  Lord Slaagh

  8 replies

  1 year, 1 month ago

  By: Lord Slaagh

• When exporting data from SQL Server to Excel file getting error message.

  I am working with a SSIS package that loads .CSV files from a network drive to the database, proces…

  BradWilk

  5 replies

  1 year, 1 month ago

  By: Phil Parkin

• Compare query results between two databases

  Hi. I would like to compare results of a query to highlight differences in the data between a produ…

  2Tall

  11 replies

  1 year, 1 month ago

  By: Johan Bijnens

• Return string between parentheses

  Hi. I have a column that lists group names. Varying lengths. I want to extract the text between the…

  2Tall

  7 replies

  1 year, 1 month ago

  By: 2Tall