SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• automate sql installation in a 2-node windows failover cluster

  Can you recommend best blog or approach or scripts to automate sql installation in a 2-node windows…

  Abhishek

  2 replies

  1 year, 5 months ago

  By: EdVassie

• Does it make a sense to update statistics right after tables truncated?

  Hi all, We have a lengthy process that uses 30 tables, some of them are large. In the beginning we …

  SQL Guy 1

  3 replies

  1 year, 5 months ago

  By: Mr. Brian Gale

• Visualisation options as an alternative to SanKey diagram

  I am building a report to show customer journeys and their arrears levels. I have 8 cohorts based o…

  aaron.reese

  1 replies

  1 year, 5 months ago

  By: aaron.reese

• Difference between equal directly and use SUBSTRING

  Hello, I have a script that was running really long, and I have found why it was running so long, b…

  Martass

  9 replies

  1 year, 5 months ago

  By: Martass

• kind of a sharepoint and ssrs question in 1

  Hi i was asked to help on an odd task today.  One of our divisions keeps safety kpi's in a spreadsh…

  stan

  3 replies

  1 year, 6 months ago

  By: Phil Parkin

• Join to a value that might be in multiple columns

  Greetings, We are trying to develop a reference name for all employees as their ID is different in …

  Paul Stasny

  4 replies

  1 year, 6 months ago

  By: ScottPletcher

• Match the String in a join

  i have Two tables T1 , T2 Create table T1( Activity varchar (100)) Create Table T2 ( Activity varch…

  komal145

  2 replies

  1 year, 6 months ago

  By: Ed B

• Create list of random, mutually exclusive selection(s) from the same table

  The TEMP table '#project_types' has 3 columns: 1) a pk, 2) the 'project_type' unique name, and 3) '…

  Steve Collins

  5 replies

  1 year, 6 months ago

  By: Jeff Moden

• need help with a SQL query

  Hi everyone I am working on a query and I am a bit stuck.  I will explain the logic. Test Data: dro…

  water490

  8 replies

  1 year, 6 months ago

  By: Jonathan AC Roberts

• gut check dba's recommendation to increase log to 200gig

  Hi , log files have always blown my mind.  I'll try to explain simply what prompted this post and t…

  stan

  13 replies

  1 year, 6 months ago

  By: stan

• ssis - same data source's revenue column violates constraints

  Hi, i've babysat our 3am , 12 erp source (one step per source) ssis pkg/subpkgs based sqlagent job …

  stan

  5 replies

  1 year, 6 months ago

  By: Phil Parkin

• how to do this in SQL?

  Hi everyone I am working on a query and I am totally stumped.  I don't even know where to begin.  I…

  water490

  5 replies

  1 year, 6 months ago

  By: water490

• Need Help: Polybase external table on Parquet file stored in Azure StorageV2

  My goal is to create a Polybase external table from a Parquet file located in an Azure storage cont…

  Eric M Russell

  1 replies

  1 year, 6 months ago

  By: Eric M Russell

• Help with reading from JSON array

  Hi all, I am trying to read the following JSON code in SQL Server: declare @json nvarchar(max) set…

  SQL Guy 1

  2 replies

  1 year, 6 months ago

  By: SQL Guy 1

• how to return the min value of a column if a sub-query returns no results

  Hi everyone My query works for most cases.  There is one edge case where it failed and I don't know…

  water490

  13 replies

  1 year, 6 months ago

  By: water490