SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• how to stop command prompt window from appearing when running PowerShell script?

  Hi everyone I have a PowerShell script that is run by Execute Process Task in SSIS.  Each time I r…

  water490

  3 replies

  4 days, 16 hours ago

  By: Phil Parkin

• 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 natur…

  water490

  6 replies

  4 days, 18 hours 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

  1 week, 1 day 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-leve…

  Jonathan AC Roberts

  20 replies

  1 week, 2 days 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

  2 weeks ago

  By: stan

• does netsuite really hide columns from customers?

  Hi we built a gateway from sql server to netsuite using an oracle competitor's odbc driver. once it…

  stan

  3 replies

  2 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 t…

  water490

  6 replies

  2 weeks, 1 day 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

  2 weeks, 1 day 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 bu…

  stan

  4 replies

  2 weeks, 2 days 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

  2 weeks, 2 days ago

  By: Phil Parkin

• Error converting data type varchar to numeric

  issue resolved. This topic was modified 2 weeks, 4 days ago by  water490.

  water490

  2 replies

  2 weeks, 3 days ago

  By: Jeff Moden

• Two queries or one?

  The setup: 3 tables: core_users, core_roles, and core_user_roles.  core users is the "base" table,…

  Steve Collins

  3 replies

  2 weeks, 3 days ago

  By: Jeff Moden

• Random Execute SQL Task(s) keeps hanging when I try to run it in parallel

  Hi everyone I am trying to implement parallelism in my SSIS package.  There are about 20 SP in tot…

  water490

  3 replies

  3 weeks, 3 days ago

  By: Ed B

• is the ssrs auto refresh without its faults

  Hi, i considered power bi with embedded for this.    Not a big fan of that plumbing. a peer of mi…

  stan

  3 replies

  3 weeks, 3 days ago

  By: stan

• how to force SS to run certain SP in parallel?

  hi everyone I have a SP that is run in SSIS.  That particular SP is basically running a bunch of S…

  water490

  5 replies

  3 weeks, 4 days ago

  By: water490