Thanks for the advice Erland! I'm going to look this up.

Having a coding standard that requires NOLOCK is so completely irresponsible. If your team thinks that blocking may be a...

• This reply was modified 4 years, 4 months ago by  Jacob Pressures.
• This reply was modified 4 years, 4 months ago by  Jacob Pressures.

Hi Erland, thanks!

The (nolock) is out of my control. My code won't pass code review if i don't have it. 😀

Both tables have the same items in them. So i...

One the of procs have a loop. One of them just steps through processes.

We are deactivating items and checking criteria for item deactivation.

The issue isn't knowing that the value are....

• This reply was modified 4 years, 5 months ago by  Jacob Pressures.

Thanks Erland,

My problem is that my code has lots of variables. I feel i have to replace my variables with the actual value. That gets messy over time. If i...

I see this article that the debugger is deprecated in v18.

https://dba.stackexchange.com/questions/221349/how-to-add-the-debug-button-to-ssms-v18#:~:text=2%20Answers&text=Debugger%20is%20deprecated%20in%20SSMS18,Studio%20to%20debug%20a%20query.&text=This%20feature%20is%20deprecated%20in%20SSMS%2018%20and%20thus%20no%20longer%20available.

What do you guys use data tools? Is there a viable alternative? Or should i just use debugger...

• This reply was modified 4 years, 5 months ago by  Jacob Pressures.

I have two. I mostly work with v17.9 and ocasionally v18.5.

Thanks!

Thanks Ken!

Thanks Guys!

Thanks guys!

I thought about trying that, but most of the time when i try that, I don't see a difference in the result. So I didn't even try. But what...

Thanks Journeyman,
I was wondering what to do with it. I guess I'll just leave the sql statement there. Even though its meaningless.
Thanks for the info.

If i...

Hi Jeff,

Thanks for the  information. I shared with my team lead.

She said:

We don’t have the ability to take a log...

Thanks!  I found this:

DECLARE@rc INT = 1;

WHILE@rc > 0

BEGIN

  BEGIN TRANSACTION;

AndyCadley,

YOU WERE RIGHT!!!!!
Thanks A million man! I'm getting the error file now! 

But now I don't know why it is producing an error. All my...

AndyCadley and Jeff Moden,

Hey, Thanks guys!

AndyCadley, I'll try to look it up, but why do i need MAX_LENGTH? I'll look it up but I'm just wondering....

Hello guys!  Thanks for the feedback.  My team decided not to use SSIS at this point.

Here is my table that I made to force errors. But it doesn't...

Thanks Alan! That was it. I thought about checking that and when you showed the screen shot I wasn't sure if I did. But I don't remember doing that in...