Hallo Hugo,

aaargh - thank you for pointing to that failure.

Hi Steve,

curious. I've selected "no FK" as one and only option but it gave me "failed" 🙂

However - local temptable are valid in the sessein and they can have indexes...

What a nonsence!

Everybody has access to master database by default.

If the...

With respect - I know that preparation of a QoTD can be quite tricky and time consuming but this QoTD has the same problem as the last one; it's dealing...

Good morning Anoo,

Anoo S Pillai (4/1/2014)

@Uwe - Even after going through the question and explanation, Do you still believe that

If the user is member of the db_owner role the...

Toreador (3/31/2014)Some people need to take a deep breath when getting a question wrong rather than immediately posting an angry response about all the points they've somehow had taken away...

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