The stored proc is running very slow on 2016 as compared to 2019. Its doing some common validation …
2 weeks, 2 days ago
I have one table in that 10 triggers are there, due to this, it takes more time while inser…
By: Mr. Brian Gale
The search text (not exact match) is in excel column and will be passed to sql query to fetc…
2 weeks, 3 days ago
I know this is a broad question.
I have 2 tables (no primary/foreign keys). In general, with 2 ta…
2 weeks, 4 days ago
By: gvoshol 73146
I have an SSIS package that is using Db2 driver to get to db on a mainframe. I setup a batch file…
2 weeks, 5 days ago
I have a table with 5000 users along with 6 years of attendance data. If I want to retrieve use…
We have a functionality where in we need to process a large file containing around 1.5 million rows…
3 weeks ago
Hi all, been struggling with this all day and can't seem to parse out a nested value from a JSON …
3 weeks, 2 days ago
By: Phil Parkin
The 'TIME_UTC' column is UTC timing. I would like to generate the report for EST timings .
3 weeks, 5 days ago
By: Steve Jones - SSC Editor
Please help me sort a comma separated column in the database table .
Create Table #Comma…
3 weeks, 6 days ago
By: jcelko212 32090
Folks, I am looking to try and come up with a way to INSERT the Output from this URL directly into …
I hope someone can help me with a problem I have using SQL Server 2016.
I have 2 tables of d…
4 weeks ago
I have a quick questions regarding a better way to write a query:
e2 is a bigger table . I…
By: Jeffrey Williams
I have this execution plan and the query last 24 h. How we can improve it?
1 month ago
By: Jonathan AC Roberts
I am currently designing a datamart layer in MS SQL 2016 Enterprise. My data and thus, the …
Viewing 15 topics - 16 through 30 (of 2,197 total)
You must be logged in to create new topics.