Without an order by, are you sure you are getting the proper value?  This looks like a bug waiting to happen.

Can more than one of the 5 selects return a...

When an identity column is created on a published table, look at the generated code.  It will include the NOT FOR REPLICATION clause.

You do not want the column to be...

Also, free space is not a bad thing.

This may be a bit off topic, but what information do these tools provide to you that makes them worth the cost?  I've owned (inherited mostly) various monitoring tools over...

Yeah, if you read about...

Got an email from Degreed.com giving me recommendations for virtual training and … well, apparently there are urgent SQL courses I need to take today and ...

Well, what do...

This is the best line, I'll make sure I skip over any of your questions.  Glad you got it 'resolved'

Doing it with create scripts and DDL and all the...

Making some assumptions based upon experience, I'm guessing that the first query using like '%string%' is the original code that's been in place for a long time?

If so, have you...

No, just no.  This sounds like a bad idea.

Curious, what datatype has exceeded the values?

We have a logging table that does this every few years, but because we keep the...

For the best practices who should be installing SQL Patches? I see in most of the organization it is installed by Windows team using SCCM and DBAs have no...

aw... am I not following the rules? WTF man!

Doing it with create scripts and DDL and all the bullshit you want would take way too much time! I'm NOT...

• This reply was modified 3 years, 9 months ago by Michael L John.

Re-boot your computer. That is a local resource issue

You can write a stored procedure to check the money limit, then set up SQL Mail and use sp_send_dbmail  to generate the email based on the limit.

Then use a...

Of course it must vs taking locks.

"and use snapshot isolation."  MEGA-HUGE overhead.  SI should only...

Of course it must vs taking locks.

"and use snapshot isolation."  MEGA-HUGE overhead.  SI should only be used when truly...