https://www.microsoft.com/en/server-cloud/products/sql-server/purchasing.aspx and click the "Read the SQL Server 2016 Licensing datasheet" link. (or http://download.microsoft.com/download/F/D/5/FD5E5C28-6973-4273-8737-D69AA3BEA243/SQL_Server_2016_Licensing_Datasheet_EN_US.pdf, though no guarantees it won't move.)

The 2012 and 2014 licensing guides had similar wording, though they're...

First result on google.

https://www.microsoft.com/en/server-cloud/products/sql-server-editions/sql-server-express.aspx

Be careful...

Sean Lange (6/1/2016)

---

Brandie Tarvin (6/1/2016)

---

I am having the worst time today reaching the forums via Internet Explorer. It just hangs and hangs.

Anyway, has anyone heard about the latest data...

Err, SQL doesn't have a built in way to 'lock' a database, so it must be something that you've built. Can you explain how you 'lock' databases?

paolobianchi (5/31/2016)

---

But the question is: if i buy license for 4 core and install SQL Server on this server with 8 core, simply SQL Server does not use every core...

You're declaring the variable outside of the dynamic SQL, hence it's out of scope inside the dynamic SQL.

Since it's intended to be an output parameter, you'll need to use sp_executeSQL...

Brandie Tarvin (5/31/2016)

---

jasona.work (5/31/2016)

---

And a good morning to you as well!

I feel I have made a...

Well, it was.

Though the first one wasn't really a study area:

Do you have experience in MS...

Interesting set of interview questions.

What were your answers?

No.

The passwords aren't encrypted. They're hashed and cryptographic hashes are one-way processes. You cannot extract the plain-text password from the hash.

The way diff backups work:

Any change made to a page results in a bit being set to 1 in the differential change map for the extent that contains the page....

A copy-only backup won't affect the size of differentials.

What else happened around the same time? Index rebuilds?

Brandie Tarvin (5/27/2016)

---

So, since we have such an international cohort here, what holidays are coming up this weekend / Monday in YOUR country? Because I'm curious what their official names...

Have you tried read committed snapshot? Won't help with deletes blocking inserts, but will help with reads.

And have you checked the indexing to make sure it supports the queries? Poor...