SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• 2 identical tables reads on Table1 PK is 53394 reads on table2 PK 2246847

  Tables have identical structure but different indexes (except) PK and different stats.    all DTA…

  joe.hellst

  2 replies

  3 months, 1 week ago

  By: Jeff Moden

• Script is filling Tempdb

  I have query which is filling TEMPDB I need suggestion how to modify this query to which can minimi…

  Nita Reddy

  3 replies

  3 months, 3 weeks ago

  By: Jonathan AC Roberts

• Trigger After Update to Update the Updated Table

  Okay I can easily see how to update a table field after an Insert but do I use the system Inserted …

  Dennis Jensen

  4 replies

  3 months, 3 weeks ago

  By: ScottPletcher

• Table Delete

  I have a very large table and I'm looking to do a cleanup based upon a non-keyed field. This table …

  Bruin

  21 replies

  3 months, 3 weeks ago

  By: Jeff Moden

• identify consecutive records greater than 1

  Hello I need help identifying all records that have consecutive hours (time in order) of greater th…

  HeftSteady

  5 replies

  3 months, 3 weeks ago

  By: Steve Collins

• Group Delete

  I have 2 tables which I need to cleanup old costkeys, based upon a driver table. The driver table i…

  Bruin

  5 replies

  3 months, 3 weeks ago

  By: Jonathan AC Roberts

• Import data from json file with special characters

  I am using the following script to import data from a json file. This file contains special charact…

  don075

  4 replies

  4 months ago

  By: don075

• Counting values with hysteresis in Report Builder

  Hi, I have a set of data (for instance sine wave) and I need to count, how many times have value re…

  UltraFan47

  2 replies

  4 months, 1 week ago

  By: UltraFan47

• Upgrading SSIS and SSRS from SQL Server 2016

  Hi All, I have plan to upgrade SSIS and SSRS from SQL Server 2016, but do not have idea for the tar…

  Deni Kusdeni

  1 replies

  4 months, 2 weeks ago

  By: Deni Kusdeni

• SQL server help (converting rows to columns)

  I am using the following sql to convert rows into columns for each pid, intdate. This works fine wh…

  don075

  3 replies

  4 months, 2 weeks ago

  By: Jeff Moden

• query help

  I need some help to optimize this query as it runs in many threads in an over night, and it pegs CP…

  Bruin

  13 replies

  4 months, 3 weeks ago

  By: Bruin

• How to merge two tables with unlike fields

  How to merge two tables with unlike fields. I have two table with one unlike field that I need to s…

  landonh

  3 replies

  5 months ago

  By: Phil Parkin

• strange selection for update

  Hi, yesterday I had to update several rows of a table. The rows for update where selected by a sele…

  joerg.kannengiesser

  11 replies

  5 months ago

  By: Jeffrey Williams

• Merge rows in SQL

  I have a table like below ID Ident source val opendate closedate IsActive ------------------…

  Neils

  6 replies

  5 months ago

  By: Ed B

• Review what columns are used

  I have a couple of databases   One would be regarded as the source and another as the destinat…

  DamianC

  2 replies

  5 months ago

  By: DamianC