Aaron N. Cutshall (9/22/2016)

---

I got the responses correct except that I also included "Command(s) completed successfully." -- which does flash briefly due to the master table creating successfully (doing them...

When I posted the qotd, all names were lower case. I don't know who capitalized them.

My instance of sqlserver has the binary collation.

Igor Micev (9/21/2016)

---

Carlo Romagnano (9/21/2016)

---

Boh, I don't understand:

The SQL Server 2014 Standard Edition can use up to 16 physical cores. If hyper-threading is enabled on a 16-core server, then there...

Boh, I don't understand:

The SQL Server 2014 Standard Edition can use up to 16 physical cores. If hyper-threading is enabled on a 16-core server, then there are 32 logical processors,...

From BOL:

gareth.davison (9/16/2016)

---

paul.knibbs (9/16/2016)

---

I do wonder why the limit is set at that. Is it just an arbitrary number Microsoft plucked from the air, or is there an actual reason for...

The correct answer is "Depends", if the view returns or not a row:

No row returned: -> The row is not updated and no error is returned.

Row returned: -> No update...

That's true!

SELECT ROUND(0.7 , 0) as a into #a

Here, the table created:

CREATE TABLE dbo.#a1

(

a numeric(1,1) NOT NULL

)

Interesting, thanks!

But, how do I convert it in previous release of sqlserver?

"we attempt to compress the table using this statement: sp_estimate_data_compression_savings ..." is wrong because the sp "sp_estimate_data_compression_savings" just is an "estimate" and it doesn't compress anything!

SPARSE is not a datatype but a property.

So, the correct answer is wrong!

SELECT * FROM sys.types

WHERE is_user_defined='0'

+1

I prefer to use "SET IMPLICIT_TRANSACTIONS ON"

Only one transaction on first I/O and one commit.

SET IMPLICIT_TRANSACTIONS ON

INSERT INTO tbl VALUES

( REPLICATE('a',5000) )

GO 100

COMMIT

GO

print @@trancount

Waiting for commiting all transactions, in reality, the table is empty for the other connections.

TomThomson (7/26/2016)

---

Interesting question, but rather badly put together - it could have been a good question if it had simply included a statement saying that the four statements are executed...