Personally, I wouldn't put the GPX file on there.  I have never looked at those, but I have a feeling that it contains GPS data in there.  People could use...

I agree with TangoVictor on this one - I would be looking to have the business sanitize the data before allowing it to be handled by SSIS.  one user puts...

What I would strongly recommend to get good results on this forum is:

1 - post DDL in a consumable format such as:

CREATE TABLE sample (JSONData NVARCHAR(MAX))

2 -...

I agree with Homebrew01 here - I would do this in a table.  That way the logic is EASY to update in the event your fiscal year changes.  You MAY...

To add to what Jeff said - I got my DBA (Jr. DBA at the time) job with no degree or any certs.  I got some certs after getting the...

My approach was to get certified in the tool I was going to be supporting - Microsoft SQL Server.  I started my training at Ucertify which I liked as it...

I am 99% sure that that is a limitation of HTML.  Can you imagine the headache if you clicked on a single link and 100 web pages popped open you? ...

My opinion - this should be solved at the presentation layer, but you also have some data issues.  First, I'd fix the data issues - your RCLTIM column is a...

If the code is running longer due to waits, I would review which wait is causing the slowest performance of the query and go from there.  If it is something...

• This reply was modified 3 years, 9 months ago by Mr. Brian Gale.

I agree with Grant here - what are you trying to debug with the debugger?

In general, my "debugging" of SQL scripts is to take the UPDATE, INSERT, or DELETE statements...

I was just reviewing the link you provided and it basically tells you what to do, just not in plain terms.  Basically, determine what is causing the latch, then determine...

As a GUESS, I would say that since the problem occurs during busy times on the server, it is LIKELY contention on the log file.  Too many things are writing...

Just to counter-point Ant-Green's suggestion of 2019/2022, I would review what OS version you are on and make sure that the SQL version you upgrade to is supported at the...

I am a little confused about what you are trying to do, but if I understand right, you want to have the report sent out on an email BUT you...

Offhand I don't, BUT I would be cautious of free services.  ANY company that offers a free thing is either losing money on it OR has other ways to make...