SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• 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 …

  stan

  13 replies

  1 week, 3 days 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 week, 3 days 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. …

  water490

  5 replies

  2 weeks 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

  2 weeks, 1 day 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

  2 weeks, 2 days 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 kno…

  water490

  13 replies

  2 weeks, 2 days ago

  By: water490

• Query wont use any index - Cannot understand why

  Hello, I am new to the forum. I am using MSSQL at work. Quick information what we do, later what is…

  Martass

  20 replies

  2 weeks, 2 days ago

  By: Jeff Moden

• Running a New Query and it is Giving me an error that I cannot find in the data

  Can someone help me debug this problem. It starts of running fine, but then it stops and gives the …

  markemoss80918

  5 replies

  2 weeks, 5 days ago

  By: Jeff Moden

• Arithmetic overflow error converting numeric to data type numeric.

  hi everyone I am not sure why I am getting this message.  Is someone able to help me figure this o…

  water490

  2 replies

  3 weeks ago

  By: water490

• ssrs seems to be mostly ignoring my bottom border color on 2 tablix cells

  Hi, I have this code for the bottom border of 2 cells in my tablix.  In most of my testing thus fa…

  stan

  1 replies

  3 weeks, 1 day ago

  By: stan

• can i query roles and users from my various tabular databases

  hi we've begun recording apps x roles at my company.  Currently the apps are erp's but i think rol…

  stan

  8 replies

  3 weeks, 1 day ago

  By: stan

• is there an ssrs feature that plays nice with tablix's and just one footer?

  Hi i inherited some multi document (eg print all invoices in the invoice number from and to paramet…

  stan

  1 replies

  3 weeks, 6 days ago

  By: stan

• create XML

  Hello.. I want to create an XML file with the below structure. I have all the elements in respectiv…

  vineet1234

  3 replies

  3 weeks, 6 days ago

  By: Phil Parkin

• EXEC (@SQL) AT QASERVERNAME; Fails with read-only database error.

  All, Need a linked server guru.   Trying the following in a stored procedure: SET @SQL = 'DROP TA…

  sgmunson

  10 replies

  4 weeks ago

  By: sgmunson

• blank page appears after every printed page in subreport

  Hi, i'm getting a blank page after every printed page of my invoices in both rendering and pdf expo…

  stan

  5 replies

  4 weeks ago

  By: stan