2013-02-24 09:23:31.46 Server Microsoft SQL Server 2012 - 11.0.2100.60 (X64)

Feb 10 2012 19:39:15

Copyright (c) Microsoft Corporation

Enterprise Evaluation Edition (64-bit) on Windows NT 6.2...

As an update things appear to be getting a bit better

Overall summary:

Final result: ...

Thanks,

it really is just to understand the straightforward way they are different. Will get to the complex bits later.

We can assume it is just two developers typing in SQL in...

Ok. Thinking about it the wording was not good.

I do not need to change the compatability level. But is it a good idea to change it to 110 once resteored...

Are my assumptions correct in that a deny would for USerB overrule the access that it had as USerN and as a member of RoleA?

Its mainly the difference between user...

I think I said somewhere before - it is not for reporting / BI. Where I have done data warehouses before I have left the data as is.

Although I...

With hindsight I should have wirded the question differently. I know the recipients of this data will treat '' and NULL in the same way. Other ETL projects where the...

John Mitchell-245523 (1/3/2013)

---

It might be more efficient to do the update in your staging or output table instead of as part of the transformation. You'll need to test to...

Thank you 🙂

I knew there must be a straightforward way

M

I Import the data to a staging table that is an exact coipy of the original data (warts and all). It then goes through a transformation into output tables ready...

1) The 2012 exams will be harder for BI people like myself who have very limited experience of the DBA side. I struggle with some basics and will find 70-462...

I too am on the hunt for hardware for this. My old laptop is XP. Looking at a laptop with Windows 8 and 8 Gig RAM. I think Hyper V...

I hate to say it but as I am getting older I do have to...

70-462 the MS press book is out.

As for the rest - check the MS site for the topics covered in the exam. I have re-used my 2008 books for a...

You may also want to look at 70-433 book which was a similar exam for SQL 2008. Not saying its the same but looking at whats on the MS site...