I had more time on Sunday, but I didn't believe I'd spend nearly half a day with it. I will try to explain this using the examples below, which I...

• This reply was modified 4 years, 1 month ago by  George Vobr.
• This reply was modified 4 years, 1 month ago by  George Vobr.

Thanks for this question Steve. Today's Qotd could not be done quickly at breakfast with morning coffee. It was necessary to study DOCS well, you could "slip" in the recently...

# Python v2.7.13 code:

str = "this is string example.";

print str

print "str.capitalize() : ", str.capitalize()

print "str.title() : ", str.title()

$python main.py

#...

• This reply was modified 4 years, 1 month ago by  George Vobr.

Scary but interesting question, thanks Grant. At first I thought that all possible answers could be considered correct. After a moment of despair, I found a hint for the right...

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 4 years, 3 months ago by  George Vobr.
• This reply was modified 4 years, 3 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 4 years, 4 months ago by  George Vobr.
• This reply was modified 4 years, 4 months ago by  George Vobr.
• This reply was modified 4 years, 4 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 4 years, 6 months ago by  George Vobr.