SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Update records based on several common columns

  I have 4 tables (apologies for the formatting of the tables,  I don't know how to better show it) …

  ray805

  2 replies

  2 days, 21 hours ago

  By: ray805

• Eliminate a function by writing out the code is now throwing an error

  /* I'm trying to eliminate (write out) this function 'largest_date', but SQL Server 2016 is telling…

  stevec883

  4 replies

  3 days, 22 hours ago

  By: Phil Parkin

• cte using POWER and Numbers table causes arithmetic overflow

  could someone explain why my cte using a numbers table causes an overflow ? my "numbers" table is e…

  jcdenmark

  10 replies

  1 week ago

  By: jcdenmark

• Log Shipping of Production DBs in OffSite Disconnected Environment

  Hi, We have some Windows Workstations Standalone and in Workgroup, and they all have SCADA applicat…

  Humbl3Lrnr

  12 replies

  1 week, 2 days ago

  By: David Wiseman

• Deadlocks after index rebuild

  We rebuilt a bunch of indexes that had avg_fragmentation_in_percent>30. Now we have 1 job that i…

  btork

  10 replies

  2 weeks, 3 days ago

  By: ScottPletcher

• SSIS (Integration Services) - "External table is not in the expected format"

  Good Afternoon. I have been manually running an SSIS package on an adhoc basis, which populates an …

  Reh23

  3 replies

  2 weeks, 4 days ago

  By: Phil Parkin

• How to efficiently perform search on my DB and Word documents on my server?

  So I'm building a system for a client and they want to have a search functionality for all the data…

  umeshamin

  4 replies

  3 weeks, 1 day ago

  By: suyashkamboj

• How to Obtain Call History of a Stored Procedure/UDF

  I know in the past this wasn't possible but maybe that's changed as SQL Server evolved. Is it possi…

  YSLGuru

  5 replies

  1 month, 1 week ago

  By: YSLGuru

• Data Joining technique help

  Hey All, I'm wondering if there is a different/better way to join the data from these two tables. P…

  Coffee_&_SQL

  2 replies

  1 month, 2 weeks ago

  By: Coffee_&_SQL

• Calculating Numerator and Denominator

  Good evening, I have a rather peculiar issue while trying to calculate Numerator and Denominator fo…

  Reh23

  2 replies

  1 month, 3 weeks ago

  By: drew.allen

• trying to call powershell from TSQL statement

  Hello, trying to call a powershell file I created, locally on the server, but also, made sure since…

  Siten0308

  8 replies

  1 month, 3 weeks ago

  By: Jeff Moden

• Read data from json file

  I am using the following code to read a json file. I can display the keys and coreentitykey info. H…

  don075

  5 replies

  2 months, 1 week ago

  By: Steve Collins

• 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

  2 months, 4 weeks 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, 1 week 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, 2 weeks ago

  By: ScottPletcher