SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Question on SQL Query with NOT condition

  I have a record, in those the three columns where firstname / last name and full name is empty. ID …

  mcfarlandparkway

  2 replies

  1 week, 5 days ago

  By: Steve Collins

• T-SQL Parent Child

  Hi All, I have 5 country grouping tables with PK & FK foriegn key relationships that store mast…

  ringovski

  8 replies

  3 weeks ago

  By: Steve Collins

• Why would using a variable vs Hard Value impact a Query's Performance

  Why would using variables in place of hard coded numbers impact a query's performance?  The below c…

  YSLGuru

  6 replies

  3 weeks, 6 days ago

  By: YSLGuru

• Need help accessing and loading a temp table

  I'm trying to dynamically create a temp table, basing the column names on another table.  It appear…

  Ken at work

  11 replies

  1 month, 2 weeks ago

  By: Ken at work

• How to get result from deleted row

  Hi Guys I have a store proc that delete a row from a and I would like to get the result of the del…

  mashispano

  3 replies

  1 month, 2 weeks ago

  By: Steve Jones - SSC Editor

• create a table with data capture for next 3 years

  Hello, I would like to build a table capturing data starting from 1st day of current year till next…

  anug

  11 replies

  1 month, 2 weeks ago

  By: Johan Bijnens

• Joining against min date only

  This is one of those things very hard (for me)to explain in words. See image below, the requirement…

  darrell.woolaver 91826

  2 replies

  1 month, 3 weeks ago

  By: Jeffrey Williams

• Union where it matches against only one shared column

  Hi folks I have two tables, both with a NAME, START and END fields I'd like to list all of the rows…

  ldanks

  7 replies

  1 month, 3 weeks ago

  By: ldanks

• Where to see how a Partition schema and function is defined

  Please see the below. The dependencies of a table(the table depends on) shows Partition function an…

  jaango123

  2 replies

  2 months ago

  By: Johan Bijnens

• SSIS - ADO Source Datetime Issue

  I'm using an ADO Net Source to extract data and running into an issue with timestamps changing befo…

  RonMexico

  0 replies

  2 months ago

  By: Tav29

• 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) O…

  ray805

  2 replies

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

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

  2 months, 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

  2 months, 2 weeks 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 months, 3 weeks ago

  By: ScottPletcher