SQL Server 2022 - Development
-
Topics
Started by
Posts
Last post
-
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took a backup of it before procedure is run …
4 replies
-
Create filegroups in partition
I have a table with partition on create_timestamp field. Though we're storing all data in one file …
3 replies
-
Analysis Services Model w/ Direct Query and (Default Veritpaq)
Analysis Services (either the integrated workspace in Power BI or on a SQL Server) lets you interac…
2 replies
-
DB Design Methods
I've read a few posts regarding what we use to design DB models and document them, and I am curious…
5 replies
-
Daily aggregation of Azure Blob Storage by tier (created/tier-change/deleted)
Hello all, I’m looking for advice on how to derive a daily snapshot table from a large fact table i…
2 replies
-
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to run the following quer…
9 replies
-
VS Code, Unresolved References.
Hi all, I just started using VS Code to work with DB projects. I have a work-in-progress DB, meani…
4 replies
By: Tav29
-
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in it... here's an abbreviated ver…
11 replies
-
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it is als…
1 replies
-
best tool for documenting your databases (more design decisions etc)
Any suggestions for a good tool for documenting a database and all the important objects in it? I'm…
6 replies
-
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape product) from both win…
22 replies
-
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in each of the tab…
6 replies
-
connections vs apis
hi , i hear more and more that we have too many connections to our servers. many are sql. many…
14 replies
-
Connecting ERP system E2 and Extract Data , perform Transformation
Hello, May someone please help me how can I pull data from ERP named as E2. E2 is using SQL Server.…
3 replies
-
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3 columns (2 int and 1 bigint) as…
7 replies
Viewing 15 topics - 1 through 15 (of 433 total)
You must be logged in to create new topics.
