Bill Talada (11/13/2015)

---

I could be wrong but I'm pretty sure there is no nesting of schemas...so there is no such thing as a sub-schema. And I think setting a...

I have separate instances for Prod/Dev etc. due to differences in underlying hardware, installed tools, etc. I use databases and schemas in my instance to separate functionality and as security...

I suspect the author intended the first one to be a trap but accidentally added coffee in front of bean which made it a valid row. As written, the answer...

Part of the problem is the common misconceptions about what a data model is. The comments have touched on some of the uses but miss the big picture. So often...

The formula for should be 42/purple but remember to carry the 2 🙂

I have settled on using prefixes for the elements most likely to cause problems, e.g. DEV_EDW_SQL and PROD_EDW_SQL for our development and production Enterprise Data Warehouse SQL servers, and DEV_EDW_SSAS_BLD,...

Out of 200, all but 1 and that's only because the P2V failed.

TomThomson (4/2/2015)

---

it can't be the answer to...

Actually, it's a trick question. As soon as the monkey picks up his foot to kick he falls over because he can't balance on his peg.

Should have told me that before I just did it. The files are gone.

Deleting the database does allow getting rid of the database files even when the database is offline.

Very nice. By using LEFT JOIN rather than INNER, the example also returns the unmatched rows.

DELETE FROM #Target WHERE Item = 'Fig';

GO

INSERT INTO #Source

...

I got it right but for a different reasoning. Since the HumanResources schema wasn't specified, the synonym would be created for the non-existant dbo.Employee table and the query would fail...

Maybe I'm missing something. To test I executed the first component to create the SP. I looked in SSMS and saw the incorrectly named SP. I then ran the sp_rename,...

I think the point value was appropriate, not due to the difficulty of the question, but rather the value of knowing the basics well. Knowing some arcane bit of trivia...