create procedure p_name(@id int, @name varchar(50)

as

if @name is not null

select * from tableA where ID = @id and name = @name

else

select * from tableA where ID = @id

go

Simply, when the backup agent job makes the backups it makes them from the master database context (for example) and not changing the contexts for each of the databases.

So...

In this case multiple rows are not returned in sub-queries because of the fact EmployeeID is PK of the table. All queries will work.

Very nice question, I had to examine all the instances i work on to check your answer is correct.

Thanks

Hi

The question had been placed here, but I cannot find it right now.

Here is the connect issue - https://connect.microsoft.com/SQLServer/feedback/details/273348/trailing-comma-allowed-in-create-table

You can add one comma "," in the end, but not more,...

TomThomson (9/22/2016)

---

Igor Micev (9/22/2016)

---

TomThomson (9/22/2016)

---

Interesting question.

There is a rather odd statement in the explanation: "Hyperthreading does not affect licensing limits". That's not correct. Hyperthreading doess affect licensing limits...

TomThomson (9/22/2016)

---

Interesting question.

There is a rather odd statement in the explanation: "Hyperthreading does not affect licensing limits". That's not correct. Hyperthreading doess affect licensing limits on a virtual...

The correct answer is 24 logical processors. Sorry for the mistake.

Hi,

Hyper-threading has nothing in relation with the licensing. You're paying per core always.

Hyper-threading...

Steve Jones - SSC Editor (9/21/2016)

---

Apologies for the wrong checkbox. I thought I had set this correctly, but I may have clicked the wrong answer item.

Points have been awarded back...

Carlo Romagnano (9/21/2016)

---

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,...

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 are 32...

You don't have to guess, it clearly states "You have a...

Gregory Hart (9/6/2016)

---

The above claim would only work in a logical proof if you identified that NULL= NULL ....

The Dixie Flatline (9/6/2016)

---

Gregory, you are arguing semantics based on *your* definition of null. We are telling you how SQL works. Further argument is pointless here...