Thanks for this article!

I have one question based on creating the sample data. I got this warning when I ran the code:

Warning! The maximum...

Thanks for this question. I guessed SELF meant the user executing the procedure, so I learned something today.

- webrunner

FYI as a follow-up:

I ran sp_Blitz and found that this seems to be what's going on:

Whenever SQL Server needs to wait while it’s executing queries, it...

TheSQLGuru (1/10/2017)

---

1) Unless you have very little active data in that large database, 8GB on the server and 4GB for SQL Server is WAY too low.

2) checkdb can cause...

Thanks again for the helpful info.

The server currently has 8 GB of RAM, SQL set to 2 GB min and 4 GB max. Given that we have one database on...

Thank you, John,

On the page you referenced, I found the sys.dm_exec_query_memory_grants DMV description and queried it. These are the results for the DBCC CHECKDB statement that...

dietztm (1/3/2017)

---

jay-h (1/3/2017)

---

dietztm (1/3/2017)

---

jay-h (1/3/2017)

---

dietztm (1/3/2017)

---

...

I do believe that as a nation we need a strong and secure safety net and affordable education, so people aren't forced into jobs they...

Well, just some food for thought in this thread:

Japanese white-collar workers are already being replaced by artificial intelligence

http://qz.com/875491/japanese-white-collar-workers-are-already-being-replaced-by-artificial-intelligence/%5B/url%5D

- webrunner

Jacob Wilkins (12/12/2016)

---

It's just a warning, and shouldn't prevent the login in question from actually creating the table.

Further, as far as I've seen it's just a quirk of SSMS when...

ZZartin (12/8/2016)

---

Don't bother trying to fight with a power hungry network admin. Make it known immediately to your supervisor that you are unable to do your job in an...

+1 I want to read it, too!!

Yikes.

Just want to add an updated note that...

Sergiy (11/1/2016)

---

webrunner (11/1/2016)

---

But is there any way to capture such a query as its tempdb log space usage crosses certain thresholds (such as 50% of the available tempdb log space)...