Hi Experts ,

We have identified the process which has consumes the space in tempdb . The stored procedure uses a lot of temp tables in it . Does storing...

I do  that same thing a lot, myself.  The cool part about that is is that it can be set to...

My guess would be that a document number should be an identifier. Identifiers are always measured on a nominal scale. Therefore, you document number should have been a string...

Jeff - I was reading your article(https://www.red-gate.com/simple-talk/opinion/opinion-pieces/jeff-moden-dba-of-the-day/) and wanted to ask, what are some of the books or resources you felt like are great resouces to master Tsql. I...

Which of these is your question:

"What does the 101 format produce on a date converted to varchar?"

"How do you convert a date to varchar and format it?"

"What is the...

Obviously I agree with that principle, as a general rule. Would you say...

Ok!  Keeping in touch with the original intent of this thread, I've just found the perfect 2nd question to ask people I'm interviewing.  It's a perfect fit for my infamous...

CONVERT is one of the quintessential functions in SQL Server.  Please see the following documentation where you'll also find out what the "101" means... You should bookmark the link if...

Heh... you still might have a problem.  Compression works well but normally...

+1 Billion for that comment!!!

Hey all,

Been a bit since I've been down this road. Clearly I'd assume this is as expected and I'm just old and rusty.

Attached is the execution plan I'm looking...

Will it free the space temporary?

So in production its still happening and we needs a temporary solution for the time being. It will take us some time to fix...

Great question but the answer is actually missing a bit of detail.  If you look at the documentation at the link you've provided, it is sorely lacking in detail for...

No... ISNUMERIC() can help but it must not be considered as any type of "Is...

I did get the table name to work --- will need to play around with it to get the database name, and the index name to be helpful.

In regards...