Topics
Started by
Posts
Last post
Background: I have a simple audit log table with over 26 million rows that grows at a rate of 365,0…
1 replies
Hello, i have a large set of data and i need to copy the Path ( folder) for every line, for example…
23 replies
Hi all, I need to calculate average rates across days. I do not have records for all days, but I ne…
16 replies
Ahoi, i have a subquery that my predecessor made and i honestly don't understand why it produces th…
9 replies
We are trying to get the value from DB2 database table via Linked Server in SQL server 2016. The DB…
1 replies
i have an expression @[User::SharePath] +"\\"+ Replace(Replace(Replace(Replace( @[User::Fi…
6 replies
Hi All, My table have 2000000 records and size 60GB .when i take backup it will take time 60 min My…
14 replies
Hello, Does anyone find SSMS v.18 client to have a very slow start? ~30sec. to load and prompt for …
4 replies
Hi, I have an issue with a SSIS package deployed to the catalog. This package includes a For Each c…
4 replies
In the procedure i have date column as datetime2 declare @date datetime2 = null, @CaptureError va…
9 replies
I have an SSIS expression where it appends 20191125155915.xlsx to filename @[User::FilePat…
6 replies
Hello, I have the following queries that I want to group together in one optimized query. I would l…
5 replies
Hi, What to achieve (it is complicated to explain) : Set up a local DB on a SQL 2016 which contains…
1 replies
how to create triggers with delete and update i have a table called dbo.OrderDetail with columns (O…
7 replies
i am struggling with a query to avoid while loop, please guide me if it can be done without a while…
3 replies
Viewing 15 topics - 16 through 30 (of 1,982 total)
You must be logged in to create new topics.