Topics
Started by
Posts
Last post
I have been tasked with extracting de-deuplicated data from a set of records but also to provide a …
2 replies
Hi Team , I want to partition a vey huge table . It has approximately 2109955648 rows . I am plan…
5 replies
first query : select * from ( select a.beliid, a.Total from Beli a where a.beliid='BL.2111.00627') …
2 replies
By: kaj
My Backup/Restore job is failing - only when the DB is involved in REPL. Looking to see if anyone…
1 replies
Hello comunity, I need to make a query that can retrieve only the last record but with LAST_VALUE(e…
11 replies
By: luissantos
Hello all, I am attempting to install the SSIS package into VS2019 CE. I've tried about four time…
2 replies
hello, I am having a major performance issue , with this part of code which is still blocked on my …
8 replies
Hi I am trying to write a SQL query that returns the number of working days between two dates. Th…
5 replies
By: water490
Data looks like below Status 1 is Active and 2 is Clean For one Student ID we may have one active, …
5 replies
By: Jeff Moden
Hello, I need to dynamically switch the db context to another db and need to create a procedure ins…
6 replies
By: Jeff Moden
Hi everyone I need to construct indexes for two tables. Table 1 - 30 Fields There are about 8 field…
19 replies
Hi everyone I am not sure why the query is taking so long to run. If I run each CTE separately th…
5 replies
By: water490
Migration of simple SPs from 120 to 150 COMPATIBILITY_LEVEL issue. Execution time for the first tim…
17 replies
By: Sal Young
I have a table of data that I need to create a .xml file from in a specific format. CREATE TABLE [d…
1 replies
We have an issue on Azure with inserting data into a physical table . We have done some benchmark t…
7 replies
Viewing 15 topics - 256 through 270 (of 1,563 total)
You must be logged in to create new topics.