SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Slow running proc on SQL 2016 with execution plan

  The stored proc is running very slow on 2016 as compared to 2019. Its doing some common validation …

  marcus

  7 replies

  2 weeks, 2 days ago

  By: marcus

• Performance Impact of Multiple or many triggers on a Table

  Hi All, I have one table in that 10 triggers are there, due to this, it takes more time while inser…

  Bharat21

  2 replies

  2 weeks, 2 days ago

  By: Mr. Brian Gale

• Efficient nested query to query on string and fetch corresponding PK

  Hello, The search text (not exact match) is in excel column and will be passed to sql query to fetc…

  novice

  1 replies

  2 weeks, 3 days ago

  By: Mr. Brian Gale

• In general how do you know which fields to join on between 2 tables?

  I know this is a broad question. I have 2 tables (no primary/foreign keys).  In general, with 2 ta…

  wallywizard

  4 replies

  2 weeks, 4 days ago

  By: gvoshol 73146

• Works from my machine..

  I have an SSIS package that is using Db2 driver to get to db on a mainframe.  I setup a batch file…

  Mike01

  4 replies

  2 weeks, 5 days ago

  By: Mike01

• How to optimise the table performanace (90 lacs records)

  Hi, I have a table with 5000 users along with 6 years of attendance data. If I want to retrieve use…

  sethumail2000

  7 replies

  2 weeks, 5 days ago

  By: drew.allen

• Comparing 2 large tables row by row and date comparision

  We have a functionality where in we need to process a large file containing around 1.5 million rows…

  jignesh209

  3 replies

  3 weeks ago

  By: ChrisM@Work

• Advice on using OPENJSON to parse a nested object array.

  Hi all,  been struggling with this all day and can't seem to parse out a nested value from a JSON …

  mmichaels1970

  4 replies

  3 weeks, 2 days ago

  By: Phil Parkin

• UTC time to EST time

  Hi, The 'TIME_UTC' column is UTC timing. I would like to generate the report for EST timings . But …

  adisql

  5 replies

  3 weeks, 5 days ago

  By: Steve Jones - SSC Editor

• Sort already comma eparted value

  Hi, Please help me sort a comma separated column in the database table .   Create Table #Comma…

  PSB

  7 replies

  3 weeks, 6 days ago

  By: jcelko212 32090

• Import Weather Web-service directly into SQL Server

  Folks, I am looking to try and come up with a way to INSERT the Output from this URL directly into …

  netguykb

  3 replies

  3 weeks, 6 days ago

  By: Phil Parkin

• INSERT INTO SELECT & INSERT INTO

  Hello, I hope someone can help me with a problem I have using SQL Server 2016. I have 2 tables of d…

  tbarnard1993

  4 replies

  4 weeks ago

  By: tbarnard1993

• performance tuning for a subquery

  Hey Guys I have a quick questions regarding a better way to write a query: e2 is a bigger table . I…

  rohitkocharda

  25 replies

  4 weeks ago

  By: Jeffrey Williams

• Query last too long

  Hello,   I have this execution plan and the query last   24 h. How we can improve it? Thanks…

  aureliu

  10 replies

  1 month ago

  By: Jonathan AC Roberts

• How to force MS SQL to select a partition instead of making a full table scan

  Hi all, I am currently designing a datamart layer in MS SQL 2016 Enterprise. My data and thus, the …

  svenflock

  7 replies

  1 month ago

  By: svenflock