SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• has anyone seen a custom meta data driven json generator?

  Hi, we might be interested in abstracting the generation of a union all amongst queries that run ov…

  stan

  3 replies

  1 year, 2 months ago

  By: stan

• JOIN with TVP ignoring Index

  I have a table with 35 million rows.  I am querying this table by joining it to a single column TVP…

  planetmatt

  11 replies

  1 year, 2 months ago

  By: planetmatt

• Encryption & Decryption in SQL Server

  Dear All, I have a requirement as below, Export a table/query output in a file with encrypted forma…

  haichells

  2 replies

  1 year, 2 months ago

  By: Perry Whittle

• Is Solution PIVOT?

  Would appreciate some help.  I'm trying to convert the 2-column list which is 2 columns to a flat r…

  texpic

  2 replies

  1 year, 2 months ago

  By: Jeff Moden

• Strange behavior passing a variable in XML.value

  Hi,  anyone would know why as soon as I add a WHERE statement (even WHERE 1 = 1) I would get an err…

  PatLap

  5 replies

  1 year, 2 months ago

  By: PatLap

• Stored Procedure - Error not found when temp table is used in join

  Dear all, what I learned is that Stored Procedures (SP) are not compiled before they are executed t…

  Arthur Kirchner

  12 replies

  1 year, 2 months ago

  By: Phil Parkin

• odbc and netsuite

  hi i just got off the phone with netsuite and we discussed their invoice api.   it occurred to me t…

  stan

  1 replies

  1 year, 2 months ago

  By: Site Owners

• Index Scan instead of index seek

  Hello guys, I have the following query: SELECT COUNT(*) FROM "dbo"."STXL" INNER JOIN "dbo"."STXL_RE…

  Martass

  6 replies

  1 year, 2 months ago

  By: Martass

• is azure an option for multiple instances of dev engine and ssas?

  Hi as you can see at https://www.sqlservercentral.com/forums/topic/test-sql-servers#post-4422832  w…

  stan

  11 replies

  1 year, 2 months ago

  By: Phil Parkin

• extracting cloud based netsuite data from the cloud in ssis

  Hi we are going to need to extract netsuite data from the cloud.  This is by no means big data and …

  stan

  7 replies

  1 year, 2 months ago

  By: stan

• Filtered index prerequisites to be used

  Hello, After few videos and  showing how filtered indexes works, what are the prerequisites to be u…

  Martass

  10 replies

  1 year, 3 months ago

  By: ScottPletcher

• plugging a repo version number into the tabular model

  hi we run 2019 std.  we saw this week that someone hid 3 important columns (2 are calc'd measures) …

  stan

  12 replies

  1 year, 3 months ago

  By: stan

• Excel blobs & BCP extract commands...

  Hi everyone, I have been asked to investigate storing Excel files in Sql Server as a BLOB. These fi…

  jellybean

  10 replies

  1 year, 3 months ago

  By: jellybean

• Monitoring if something is deleted in DB

  Hello, I have long-term task, which came one year ago, and just now I have a little free time to st…

  Martass

  9 replies

  1 year, 3 months ago

  By: Martass

• Help on grouping to sets of rows in my sql data

  Hello I need help on writing this query. This is what i need. I have the following data, which repr…

  Mond

  4 replies

  1 year, 3 months ago

  By: Mond