SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• different state on the same error message

  Hello   On nearly all of our servers if I generate a string or binary data would be truncated …

  DamianC

  9 replies

  5 years, 5 months ago

  By: Jeff Moden

• Only one expression can be specified in the select list when the subquery is not

    I am trying to check if a username exists in the table , if the username exits in a table th…

  mnr123

  4 replies

  5 years, 5 months ago

  By: mnr123

• Query help for special condition

  Hi sql gurus, I am currently doing some R&D on MERGE statement and as you know it's little comp…

  sqlenthu 89358

  7 replies

  5 years, 5 months ago

  By: sqlenthu 89358

• Causes for The query processor could not produce a query plan

  SQL Server 2016 (13.0.5598.27) The first version of the below query produces results while the seco…

  YSLGuru

  3 replies

  5 years, 5 months ago

  By: Steve Jones - SSC Editor

• Advantages and Disadvantage using Temp Table or Fisical Table

  Please share your thought about advantages and disadvantages for processing using temp table or pro…

  fransiscuscandra

  9 replies

  5 years, 5 months ago

  By: fransiscuscandra

• Deadlocks when high concurrent connections are running in parallel.

  I have a legacy process where users are performing a task in parallel. The business logic is that e…

  Tava

  4 replies

  5 years, 5 months ago

  By: Jonathan AC Roberts

• Replacing / Removing All Text In Multiple Sets of Characters in SQL

  One of the result fields has multiple html references in it such as in the code below. Currently th…

  mnovosel

  7 replies

  5 years, 5 months ago

  By: Jeff Moden

• Need some help getting info of people logged in, but from the POV of NON-Sysadm

  I modified a proc that returns a result set of all user emails to the application in question, with…

  cFauvel

  12 replies

  5 years, 5 months ago

  By: cFauvel

• Stored Proc slow after switching to Replication?

  Hi First, let me apologize in advance for my ignorance on this... We are in the process of switchin…

  jbalbo

  4 replies

  5 years, 5 months ago

  By: Sue_H

• Temporary turn off Transactional Replication?

  Hi We get a DB that is replicated every 10 seconds or so We are having an speed issue running SP's …

  jbalbo

  1 replies

  5 years, 5 months ago

  By: Sue_H

• Turn multiple rows With Similar IDs to XML

  Hello, I'm trying to convert multiple rows with shared IDs into XML however I am struggling getting…

  sean.smith 80376

  1 replies

  5 years, 5 months ago

  By: sean.smith 80376

• Importing csv file into SQL table

  Looking for something like BULK insert CSV file to SQL table. But BULK insert assumes there is tabl…

  SQL_Surfer

  7 replies

  5 years, 5 months ago

  By: SQL_Surfer

• output with no headers csv

  I have a sql script which runs fine, but I need the output to show  headers in comma delimited tryi…

  tcroninlifepoint

  3 replies

  5 years, 5 months ago

  By: Jonathan AC Roberts

• Filling dates between the status changes

  Hi ,   I have a table with a sample data like this.     CREATE TABLE EMployeeStatus(…

  sql_novice_2007

  10 replies

  5 years, 5 months ago

  By: Jeff Moden

• Database Deployment Scripts

  I am wondering what people are using for automated deployment of database objects.  We are agile, b…

  Mike01

  1 replies

  5 years, 5 months ago

  By: Steve Jones - SSC Editor