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 5 years, 11 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, 1 month ago by George Vobr.
• This reply was modified 6 years, 1 month ago by George Vobr.
• This reply was modified 6 years, 1 month ago by George Vobr.

The syntax description in the reference states that header is a logical value indicating whether the file contains the names of the variables as its first line. If missing, the...

USE TestDB;
GO

--Weird question, pleas try this in Results to Text mode:

CREATE TABLE dbo.my_table (my_field INT);
INSERT dbo.my_table VALUES (1),(2),(3),(30),(40),(50);
GO
-- Syntax error in CASE clause!
UPDATE dbo.my_table SET my_field =...

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

Datetimeoffset defines a date that is combined with a time of a day that has time zone awareness and is based on a 24-hour clock.

If you would like to represent...

Bravo Thom, it's a great question with an excellent explanation!

Thanks for this interesting T-SQL question Steve.