SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• 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

  5 years, 9 months 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

  5 years, 10 months ago

  By: Jonathan AC Roberts

• Script error

  I am trying to monitor the sql services on couple of instances and found the following script onlin…

  sizal0234

  2 replies

  5 years, 10 months ago

  By: Mr. Brian Gale

• SQL account for restoring database

  I have a script that restores a database and runs some post-restoring actions, mostly fixing the da…

  Eliyahu

  3 replies

  5 years, 10 months ago

  By: Eliyahu

• Format string to send as email body

  Hi,I have a StoredProc who sends an email.Here is the code that build the string: DECLARE &nbs…

  Dominic Gagné

  3 replies

  5 years, 10 months ago

  By: madhugundapaneni

• Merge not updating in explicit transaction

  We have the following code in a stored procedure which has a merge statement and an update statemen…

  sadie

  3 replies

  5 years, 10 months ago

  By: Steve Collins

• High sensitivity of SQL server 2016 to statistics ?

  Hello all, we have recently upgraded from MS SQL 2012 SP3 to MS SQL 2016 SP2 (standard), we use com…

  martinreiser

  24 replies

  5 years, 10 months ago

  By: Jeff Moden

• Encryption table and saving in 2016

  Hi, How would you encrypt data from multiple tables and save in a temp tables using a script (tsql)…

  sizal0234

  2 replies

  5 years, 10 months ago

  By: sizal0234

• CTE left join not giving me correct result

  Hello, Why is the Left Join with a CTE giving me wrong results? I want to know which Emails are not…

  datsun

  5 replies

  5 years, 10 months ago

  By: Steve Jones - SSC Editor

• Query optimisation

  Hi all   I've got a query that has to update a table containing several million records. I've …

  richardmgreen1

  5 replies

  5 years, 10 months ago

  By: ScottPletcher

• stored procedure insert into a table -parameter containing the name of the table

  Hi, I have 10 tables each with 2 columns (Id- identity, Name_xxxx) The name of the second column is…

  AntonyO

  9 replies

  5 years, 10 months ago

  By: Steve Collins

• SSIS and temp tables

  hi folks i have a stored procedure that i want to run within an SSIS data flow package (sql 2016, v…

  dopydb

  4 replies

  5 years, 10 months ago

  By: dmbaker

• Strange Attachment Corruption for Database Mail

  I wrote a SPROC to email some data. CSV file, single data string column. Between 100KB and 5MB in s…

  planetmatt

  7 replies

  5 years, 10 months ago

  By: Mr. Brian Gale

• Script to list all backup files starting from the latest full backup

  Hi, I am trying to write a query to list all backup files starting from the latest full backup, fol…

  Roust_m

  1 replies

  5 years, 10 months ago

  By: John Mitchell-245523

• Self join / row_number() partition number generation based multiple status

  Thanks in Advance:) Whenever there is a change in Status or Comment for name_id then we need to con…

  ravisankar

  6 replies

  5 years, 10 months ago

  By: Steve Collins