SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Issue with the the new Microsoft managed Oracle data source component for SSIS

  During preparation for a large SSIS upgrade project from SSIS 2012 to SSIS 2019 we have identified …

  admin-499013

  5 replies

  3 years, 4 months ago

  By: admin-499013

• How to get the output of SQL Server Activity Monitor using SQL script?

  Hi, I am looking for a SQL query that can give the data present in the "Activity Monitor" like the …

  sekhar

  1 replies

  3 years, 4 months ago

  By: ktflash

• How to split single name with space in sql

  I have  table data with stores like select Name from tblstudent Result will be Southeri,Brettuen I …

  mcfarlandparkway

  2 replies

  3 years, 4 months ago

  By: mcfarlandparkway

• max date order by status

  Hi Expert, i wanted to fetch status and max new date , value data create table test (newdate date,s…

  Shree23

  13 replies

  3 years, 4 months ago

  By: pietlinden

• Using a CASE Statement In A WHERE Clause

  I want to use a case statement in a where clause and I want to use getdate() in conjunction with a …

  RedSoxRay

  4 replies

  3 years, 4 months ago

  By: Jeffrey Williams

• How a batch can get how much CPU it used in SQL Server 2019

  Is there something I can put at the end of a batch to find out how many milliseconds of CPU it used…

  uncager

  13 replies

  3 years, 4 months ago

  By: Michael L John

• OPENJSON unable to parse Portuguese characters

  I'm trying to convert my JSON data into a table format in SQL Server Express 2019. Following are my…

  HugoP

  4 replies

  3 years, 5 months ago

  By: Phil Parkin

• Configurations in visual studio around different environments

  Hi All, Been working with visual studio to produce SSRS reports for a few years and i have some que…

  rogue1009

  1 replies

  3 years, 5 months ago

  By: rogue1009

• Parsing / importing Costco Receipt data

  OMG. I think CostCo doesn't want anyone to do anything with their own purchase data. If you've ever…

  pietlinden

  6 replies

  3 years, 5 months ago

  By: pietlinden

• SQL Query Help

  Hi, Below is my sample data. What I am looking, if "product_descr" has more than one value separate…

  rocky_498

  2 replies

  3 years, 5 months ago

  By: rocky_498

• Common Import format to import data and database schema from various SQL dbs

  Out customers use different SQL databases, like PostgreSQL, SQL Server, MySQL. We need to import da…

  itlk

  3 replies

  3 years, 5 months ago

  By: Jeff Moden

• Calculate the Orientation for given distance and Source Coordinates

  Hi , I do have source coordinates and distance to destination in meters .I need to calculate the De…

  Steve Dell

  2 replies

  3 years, 5 months ago

  By: Grant Fritchey

• transposing date column to rows

  Hello people, I am trying to transpose date column to rows. I am not sure if this can be done for m…

  sidlfc08

  7 replies

  3 years, 5 months ago

  By: Thom A

• Having a case or if statement in where clause on Max Date

  The issue is that I need to select the MAX date when: If the Max Date from my_column is equal to to…

  a_car11

  9 replies

  3 years, 5 months ago

  By: kaj

• SS2019 Running Extremely Slow

  Hi everyone I got a new computer and copied over the DB from my old machine.  I backed up the DB fr…

  water490

  37 replies

  3 years, 5 months ago

  By: water490