SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• housekeeping of millions of records on everyday basis

  Hello!! We are building our system that will be up and running for 24x7 365 days. the data will be …

  saum70

  5 replies

  1 year, 8 months ago

  By: EdVassie

• send csv file or txt file to sftp server

  Hello Can someone help me with code to send file to sftp server please: Here is my code: # SQL Serv…

  juliava

  2 replies

  1 year, 8 months ago

  By: jacksdan

• WHY Follow a LEFT OUTER JOIN with another LEFT OUTER JOIN

  NOTE: The Topic Title probably isn't very good but I wasn't sure how to title this with a limited a…

  YSLGuru

  10 replies

  1 year, 9 months ago

  By: YSLGuru

• Select query for latest records by date

  Hello , I'm trying to retrieve all the records for the most recent date.  I have used Max on the [e…

  gjoelson 29755

  5 replies

  1 year, 9 months ago

  By: gjoelson 29755

• txt file Pipe

  Hello, I need to put data from table to txt file as pipe on certain drive can someone assist me? Th…

  juliava

  8 replies

  1 year, 9 months ago

  By: juliava

• Case statement to insert a new line in query output??

  Hi I need to insert a new line of my output when a condition is met My out looks like ID,Date When …

  jbalbo

  2 replies

  1 year, 9 months ago

  By: jbalbo

• Best Practice for character replacement within Table.Column

  Is there a better/more efficient way to do what the below does? It is  replacing several characters…

  YSLGuru

  14 replies

  1 year, 9 months ago

  By: Jonathan AC Roberts

• SQL runs slow in a union all statement

  Could you please help? My Union all sql query consist of three individual queries that runs quickly…

  Oludare

  9 replies

  1 year, 9 months ago

  By: Jonathan AC Roberts

• The DATETIME data type question

  I know that the DATETIME data type is no longer an ANSI/ISO Standard and I have heard the Microsoft…

  Dennis Jensen

  2 replies

  1 year, 9 months ago

  By: Dennis Jensen

• Convert Old School to current ANSI/ISO SQL Standards

  I have a situation where I ran into an old school query that I want to change into a more standardi…

  Dennis Jensen

  5 replies

  1 year, 9 months ago

  By: Jo Pattyn

• Find the active Group

  Hello All, I have a requirement where I am trying to get the active group number. A groupnum can ha…

  ssc_san

  6 replies

  1 year, 10 months ago

  By: ssc_san

• Unexpected deadlocks in test environment but not in production environment

  We are trying to understand why we are seeing the following occasional deadlock in our test environ…

  zoggling

  15 replies

  1 year, 10 months ago

  By: ScottPletcher

• Delete large number of rows help

  I have a batch process where i have to delete around 75 MIL rows out of 1.3 Billion rows table.  An…

  SQL_Surfer

  6 replies

  1 year, 10 months ago

  By: Stewart "Arturius" Campbell

• Will ALTER TABLE modify a column with the same type or skip it?

  Hello, All Perhaps a silly question, but may significantly impact the business. We have recently fo…

  BOR15K

  6 replies

  1 year, 10 months ago

  By: Jeff Moden

• Can LEAD and LAG skip rows or can we add a where clause?

  Hello, I have a dataset of route data (this is just a single route) like below: CREATE TABLE [dbo].…

  tacy.highland

  7 replies

  1 year, 11 months ago

  By: ScottPletcher