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, 6 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...

Spot on Jeff... I never think to check the profile before replying...

Seeing something like "gemini support team" in the profile then seeing a question posted that doesn't seem to make...

My opinion - I would NOT have modified any upgrade related scripts or any scripts created and provided by Microsoft.

I would follow the same advice that I gave originally:

I would...

My opinion - that is hard to say on a forum post as we have no access to your data or your data structures.  My question to you would be...

I don't think there is enough to go on based on what you wrote.  Plus, what you wrote does not look like TSQL; it looks more like .NET.

So, if you...

My opinion - before making a linked server, find your bottleneck.  If the bottleneck is the network, the linked server is not going to make things any faster.  It will...