Great question, thanks John. Some typo doesn't matter, and the same two answers don't. After all, one correct answer rules out the remaining... Thanks also to Carlo Romagnano for clarifying...

Ref. in the QotD explanation refers to the documentation for Built-in Functions and the open() function not to Input and Output. In...

• This reply was modified 6 years, 1 months ago by George Vobr.
• This reply was modified 6 years, 1 months ago by George Vobr.

Hmmm ... oddly, print (result) in Python v2.7.13 displays the result correctly. No need to add list().

Thanks Steve, for an interesting question. I appreciate the perfect explanation of this topic in a recent article in your "Voice of the DBA" blog. Well done!

In Python Pandas (Python v2.7.13), option #1 works with both { } and [ ].

In addition, option #3 without the Inplace=True parameter will do nothing and the original df will...

• This reply was modified 6 years, 2 months ago by George Vobr.
• This reply was modified 6 years, 2 months ago by George Vobr.
• This reply was modified 6 years, 2 months ago by George Vobr.

I thought I wouldn't touch this question until it's been reviewed, but I couldn't resist.

Clearly, option 3 wouldn't work, since the original column name is "BillingAmount", and not "BillAmount"....

Thanks for this question, Steve. Let me add a link to an interesting article: Does rebuild index update statistics?

Good catch. Yes, > passing.2019[order(-TD.2019),] works like > passing.2019[order(TD.2019, decreasing = TRUE),]. But your code: > passing.2019[order(-TD.2019,] gives a syntax error....

Today I will not answer, I tried to calculate the free space only from sys.database_files as Free_space = max_size - size,

but it is necessary to treat the value max_size -1...

Great question, thanks Steve. In fact, it's a good reminder that striping a backup of SQL Server relational database can significantly reduce the time it takes for this backup to...

• This reply was modified 6 years, 4 months ago by George Vobr.

Thanks Steve for this interesting question. I'm surprised how cute Python is, he doesn't mind square brackets in the right answer ... 🙂

Ah..., my apologies, it is obvious that in the expression '1.77 + 0. test' is the second dot also an decimal point. I had to be blind. I have overlooked...

Hi Carlo, yes you're right. The first dot in constant numeric number in the selected

expression is the decimal point. The second dot is a "virtual AS".

SELECT 1.77+0....

Thanks Thomas for a funny but interesting question, and thanks

Oddvar for the reminder sp_describe_first_result_set.

This clearly shows that if the expression before the dot is data type numeric,

then the expression after...

Thanks for an interesting question. I did not find in the docs a link to DROP EXTERNAL TABLE for Azure SQL Database. This page DROP EXTERNAL...

• This reply was modified 6 years, 6 months ago by George Vobr.
• This reply was modified 6 years, 6 months ago by George Vobr.
• This reply was modified 6 years, 6 months ago by George Vobr.