SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• whats that ssis analyzer product that documents lineage

  hi, a few years ago was at a very large company that bought a software product that documents linea…

  stan

  4 replies

  3 days, 16 hours ago

  By: stan

• Using IFF within a WHERE clause

  I have a WHERE clause I need to add to a list of other WHERE clauses but this one below needs to ev…

  DaveBriCam

  2 replies

  1 weeks, 4 days ago

  By: DaveBriCam

• cons for a dev machine in a different version of sql from our prod server

  hi, im not a dba. For a couple of years our dev sql server has been a 2022 vm std instance with var…

  stan

  11 replies

  2 weeks, 2 days ago

  By: Steve Jones - SSC Editor

• identity increments by 10,000 when it was supposed to be 1

  hi a peer of mine who ive never known to be wrong says a new table he created with pk identity(1,1)…

  stan

  6 replies

  1 months, 1 weeks ago

  By: ratbak

• Unable to restrict permission

  I have 13 restricted views in my EDW DB. 6 of them are created from DB1 7 of them are created from …

  LearningDBA

  3 replies

  1 months, 1 weeks ago

  By: LearningDBA

• non ascii columns in a utf-8 .txt file

  hi, we couldnt get our upstream data source developers to supply what is sometimes chinese and i th…

  stan

  3 replies

  1 months, 2 weeks ago

  By: stan

• Build hierarchy multi-column table on data in 1 column based on string length

  Hi, I need to build a hierachy multi-column table based on data in 1 column where the length of the…

  FL0XN0X

  15 replies

  2 months ago

  By: naumon765

• setting an ssis param dynamicaly when the sql agent job runs

  hi i was hoping for a more elegant way of setting a pkg level param from the sql agent job that run…

  stan

  4 replies

  2 months, 2 weeks ago

  By: stan

• Warning: Could not open global shared memory to communicate with performance DLL

  Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at Update Table, SSIS.P…

  water490

  1 replies

  3 months ago

  By: frederico_fonseca

• that one limitation in replication

  Hi as shown below a replication target requires a primary key.  if we want to replicate from the db…

  stan

  3 replies

  3 months ago

  By: deepeshdhake

• advice as i migrate my winscp based ssis pkg to our prod server

  Hi , i installed winscp on my pc, added it to GAC thru vs (i think a developer script) on my pc as …

  stan

  6 replies

  3 months, 3 weeks ago

  By: stan

• String_agg not working as needed

  I'm trying to get this string_agg to put all the 'comments' into one result field like instead of: …

  DaveBriCam

  10 replies

  3 months, 3 weeks ago

  By: pietlinden

• query to track time spent on individual tasks in SSIS

  Hi everyone I am looking at building a query to determine how much time is being spent on each task…

  water490

  5 replies

  4 months ago

  By: water490

• how to write this query?

  Hi everyone I asked this earlier but the desired outcome is a bit different this time so I am start…

  water490

  2 replies

  4 months, 1 weeks ago

  By: pietlinden

• would it be so terrible to install ssms on a few user desktops?

  Hi, ssms is free here.   I can think of other reasons to do this but i would like to install ssms o…

  stan

  4 replies

  4 months, 2 weeks ago

  By: Jo Pattyn