Topics
Started by
Posts
Last post
Hi, I would love to hear if anyone can tell me why a CAST in a query can "resolve" this performance…
2 replies
Have a table with varbinary(8000) column. When carrying out a select and including this column the …
12 replies
I have two sources , one coming from datalake and another is file. we need to match date to combine…
2 replies
We've got upwards of 40 SSIS solutions all stored in one GIT repository in teams. I thought this w…
6 replies
I have a table called Person with the following schema: CREATE TABLE [People].[Person]( [Id] [sm…
10 replies
Hello SSC, I hope everyone is happy and healthy and ready for spring! I am looking for some alterna…
2 replies
Using VS2019 editor -- developing SSIS Pkg to ingest an Excel XLSX v16.03 file and LOAD into a SQL …
5 replies
Quick one I hope in case I'm heading off in entirely the wrong direction! I've been working on a pr…
6 replies
Recently I upgraded my ssis package from 2016 to 2022, but package format version is showing 8. Is …
2 replies
SQL Server 2022 16.0.4165.4 Windows Server 2022 Datacenter 21H2 20348.2849 Our Extended Stored Proc…
5 replies
By: SKEITA
Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL to parse XML data. This…
3 replies
Hello SSC! I have been tasked with optimizing a stored procedure the imports data from XML to SQL t…
3 replies
Hi everyone, I'm working on optimizing a DELETE query used in a data cleanup process, and I’d like …
1 replies
Hi - Currently, I have this DAX coded in Power BI Ticket Cutoff Status = VAR TimeOnly = TIME(HOUR([…
2 replies
Hi, Need this DAX covert SQL T-SQL. Ticket Cutoff Status = VAR TimeOnly = TIME(HOUR([Remedy Submitt…
2 replies
Viewing 15 topics - 16 through 30 (of 374 total)
You must be logged in to create new topics.
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy