James Lean (3/31/2014)The script doesn't mention anything about the creation of king_login, so it is implied that this login already exists. In that case, we cannot assume that it...

Hi,

the question and it's given answer is nonsence. You talk in your "solution" about the sysadmin role!

But in your script you add the user to the db_owner role.

If the user...

Unfortunately - yes 🙁

I saw the mentioned QOTD...

vvkp@hotmail.com (10/24/2008)

---

I have a table (670 million rows) with 200gb on 272 GB drive with clustered index (PK) and another nonclustered index .

I am trying to move the table to...

jayant-479472 (10/16/2008)

---

I think my question is little confusing, let me make it more clear

If we have a table with cluster index then by simply recreating the clustered index on different...

Dear Vedran,

best congrats from me to you - Mr. SQL Master 🙂

Wellcome to the club!

Hi folks,

there will be NO MCM /MCSM/MCA program anymore! I've got that email (excerpt) tonight form Microsoft:

"We are contacting you to let you know we are making a change to...

Hallo Vedran,

I'm wondering why you didn't use BOL.

That was a valid option for each candidate...

However - I'm crossing fingers that you've passed.

It's near finish line - in January the MCM...

Hi Vedran,

crossing fingers and hope you'll pass.

Hard work but a good preparation and good technical environment may help 🙂

Keep us updated, Uwe

SimonLiew (7/25/2013)My advice is not to benchmark how many people passed in their first attempt. Everyone's different. Passing an exam doesn't mean you're superior, failing the exam doesn't mean you're...

Vedran Kesegic (7/19/2013)

---

Just found out: I passed the knowlege exam - from the first attempt! Learning and experimenting night and day for 6 months payed off.

Now, the terrifying lab exam...

The answer isn't correct because "it depends"!

I answered it correct but only because of the standard settings for the session parameter [CONCAT_NULL_YIELDS_NULL].

SET CONCAT_NULL_YIELDS_NULL OFF;

GO

SELECT session_id, concat_null_yields_null FROM sys.dm_exec_sessions WHERE session_id...

Gail, if it is easier for you to come to Germany let me know.

I will take care of a quiet and separate room with a 16 Mbit internet connection for...

Hi Vedran,

go for it! I'm crossing fingers you've passed.

Keep us informed.

Thank you all for your wishes - feeling quite good after the stress 🙂

@evgeny

I really would like to come because it seems to be a quite good program.

Unfortunately this weekend...