SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Stored Procedure

  Hi Friends, I have a stored proc with 45 tables that are used to store ssn's (All of the tables hav…

  Data Rat

  9 replies

  5 years, 11 months ago

  By: Jonathan AC Roberts

• Case when with a Pivot

  Hello, I'm trying to write a AR aging select query that  uses a case statement to indicate if the i…

  gjoelson 29755

  13 replies

  5 years, 11 months ago

  By: Jeff Moden

• Partitioning table techniques which one is best way?

  Hello All, I am about to do partitioning for my DW tables based on datetime and left range partitio…

  Saravanan_tvr

  6 replies

  5 years, 11 months ago

  By: Saravanan_tvr

• 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, 11 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, 11 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, 11 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, 12 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, 12 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, 12 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, 12 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, 12 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, 12 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

  6 years 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

  6 years 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

  6 years ago

  By: SQL_Surfer