SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• 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

  1 replies

  5 hours, 51 minutes ago

  By: Jeff Moden

• 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

  6 replies

  23 hours, 46 minutes 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

  1 day, 4 hours 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

  1 day, 6 hours 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

  1 day, 11 hours 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

  3 days, 3 hours 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

  3 days, 22 hours 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

  4 days, 6 hours 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 days, 1 hour 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 days, 12 hours 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

  1 week, 1 day 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 try…

  tcroninlifepoint

  3 replies

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

  1 week, 4 days ago

  By: Jeff Moden

• Database Deployment Scripts

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

  Mike01

  1 replies

  1 week, 6 days ago

  By: Steve Jones - SSC Editor

• sum of running total from other partition (grouping sets?)

  I need to count the items between one lead row and other, here an example: I have this query: SELEC…

  Baldie47

  15 replies

  2 weeks ago

  By: Baldie47