Uwe Ricken (5/24/2013)

---

Hi all,

I'VE GOT IT!!!!!

A few minutes ago i got the mail from Bob - passed...

OMG - can't describe what I feel currently...

What a journey - it took me...

ben.brugman (5/29/2013)

---

I...

You can start from:

select * into dbo.newtable

from dbo.oldtable

if you need new table to be populated with old table data, then you can add required constraints and indexes.

Author should emphasize that it will be one batch. It will be too many wrong answers.

Also, be aware that some indexes exists for maintain constraints - unique indexes. And it could looks like unused...

Here is detail instructions: http://msdn.microsoft.com/en-us/library/ms345408.aspx .

Why you restarted server, I usually use that script for model:

SELECT name, physical_name AS CurrentLocation, state_desc

FROM sys.master_files

WHERE database_id = DB_ID(N'model');

ALTER DATABASE model SET...

Start sql server in minimal configuration and check paths using this script:

SELECT name, physical_name AS CurrentLocation, state_desc

FROM sys.master_files

WHERE database_id = DB_ID(N'model');

I just want to work in the US. I thought that the US is welcome for immigrants, because it is immigrants country. But now I starting understand that it is...

St. Petersburg. May be you could recommend some staff agencies?

I am looking for a job offer. I just created resume on monster.com and applied for...

Correction, Principal do not wait for commit transaction on the mirror. It waits for transaction being recorded in transaction log file on the mirror server. This is common misconception.

Right answer is wrong in this case. Beacause some rows could be returned. This query will prove my words:

while 1=1

begin

CREATE TABLE #TEST

(

FirstDate DATETIME,

LastDate DATETIME2

)

DECLARE @i int

SET @i...

It can vary... You should trust only to official information http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-461 .

Vedran Kesegic (12/10/2012)

---

I just started to learn for MCM certificate. Videos are really inspiring, packed with information and insights, really refreshing.

4 videos watched, 1000 to go 🙂

I hope to be...

Do not forget that you must successfully pass 88-970, after that you will be able to registry for 88-971.

Good luck.