SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• How Can I Speed This Query Up?

  Hi everyone My SQL query is close to 1000 lines with 17 separate calcs (ie sub-queries).  The enti…

  water490

  25 replies

  3 hours, 47 minutes ago

  By: frederico_fonseca

• Not wanting to use a Cursor, but...

  Ok, need someone to talk me off the cursor ledge on this one. I have some train stop data that I ne…

  jwilkerson@valleymetro.org

  10 replies

  17 hours, 57 minutes ago

  By: jwilkerson@valleymetro.org

• Triggers applied to primary and secondary tables causing rollback on primary

  Apologies for the title, I'll explain more clearly. I have two tables and each has a trigger applie…

  andyewx

  5 replies

  1 day, 4 hours ago

  By: andyewx

• puzzeled with "exec sp_cursor 180150007,40,1"

  I've noticed in one of our applications a cursor uses operation 40 and that operation is very slow.…

  Johan Bijnens

  1 replies

  2 days, 20 hours ago

  By: Johan Bijnens

• how to de escalte a isolation level, and are there any implications.

  hi, I have one nested transaction and want to deescalate to outer  transaction's isolation/ or low…

  rajemessage 14195

  8 replies

  3 days, 20 hours ago

  By: Michael L John

• Advanced SQL query help

  Hi, I am looking for some help with two queries using the following table/data. It would be great t…

  sc-w

  7 replies

  6 days, 1 hour ago

  By: sc-w

• MSSQL Service Broker DSQL operation on another database causing Broker failure

  I have established a Service Broker configuration based on Eitan Blumin's excellent example. https:…

  andyewx

  6 replies

  1 week ago

  By: andyewx

• MSSQL STRING_AGG() Conversion failed when converting the varchar value to int.

  Short story, I needed to convert a table insert/update trigger to a Service Broker task. That's not…

  andyewx

  2 replies

  1 week, 1 day ago

  By: andyewx

• Find replace using regular expressions

  I am trying to find an easy way to vertically arrange numerous columns in a select statement using …

  masterelaichi

  11 replies

  1 week, 2 days ago

  By: nickjoseph754

• Extracting multiple fields from one column

      Hello, I have a situation. I am trying to show each  distinct event category, event …

  JeremyU

  4 replies

  1 week, 3 days ago

  By: Jeff Moden

• T-SQL Query Help

  Hello, I am working on one of the SQL Logic, i need help to build core logic to do the rest, below …

  yogi123

  4 replies

  1 week, 3 days ago

  By: pietlinden

• SSIS package configuration connecting to design-time instance

  I have an SSIS package which uses SQL Server Configurations. This uses an expression-based, project…

  Pete Bishop

  1 replies

  1 week, 3 days ago

  By: Pete Bishop

• Encryption insert driving me mad

  Hi all, I'm wondering if someone can help me with this, I have a table (very simple) CREATE TABLE […

  NicHopper

  2 replies

  1 week, 5 days ago

  By: Jonathan AC Roberts

• Query to Insert Data Based on CustomerID from one table to another

  Hello All,  Below is the  my existing table structure from which I need to insert records to a ne…

  pingeli dileep

  7 replies

  1 week, 5 days ago

  By: Kevin Gill

• SSIS Execute Task PowerShell performance after migration from 2016 to 2019

  We recently migrated our SQL platform from a server running SQL 2016 to a new one running SQL 2019.…

  Pete Bishop

  3 replies

  1 week, 6 days ago

  By: Pete Bishop