Hi Steve,

hmm - TDE is not SE but EE.

Parikshit Savjani (MSFT): "TDE is Enterprise edition only"

Steve,

I answered all three options correct:

- text/ntext

- XML

- CLR datatypes

but the answer is marked as wrong. In your given solution you mention exactly the same options.

Can you check it?

Best from...

Hi Folks,

There is a mistake in the correct answers. I have informed Steve to fix it.

Correct answers must be:

- the NON UNIQUE Index stats will be updaten

- the UNIQUE Index...

Hallo Hugo,

thank you for this - EXCELLENT - explanation. To be honest; i wasn't at any time so deep into this operator and I really appreciate this deep and detailed...

sknox (8/7/2015)

---

Here's a thought... If this is a table which needs to support a large number of concurrent writes as quickly as possible, why was one option not a memory-optimized...

Luis Cazares (8/6/2015)If identity is ever increasing, how can it create the same fragmentation of a random value?[/Quote]

Hi,

fragmentation on an identity value can surely occur if you have a high...

Hallo Wayne,

your measures are not correct because you didn't run the process:

- for each table separately

- with 200 concurrent Connections

Than you will have a HIGH fragmentation on the IDENTITY table...

Hallo Graham,

as always - it depends 🙂

In my test Environment with 4 cores, 32 GB and SSD the elapsed...

The fragmentation of the Indexes (INT or GUID) is nearby the same...

Hi Patrick,

maybe but this will lead to a wrong answer (as in my case). So - I'm not crazy about the points but the answers are ALL wrong from the...

Hi Steve,

seems to be NONE of the given examples are correct 🙂

USE [mydb]

GO

ALTER DATABASE [mydb]

MODIFY FILE

(

NAME=N'OldName',

NEWNAME=N'NewName_01'

);

GO

I assume that you have forgotten to...

Gosh - failed!

I have to read more carefully the options 🙂

I was focused on the error of the INSERT statement but didn't realize that the result of ERROR_MESSAGE() was asked.

My...

MohamadHamedi (1/7/2015)

---

i have a question.

we know that we stored old data from 20120101 to past.

then when we want to search data,check the order date.

if it is older than 20120101 we...

san1901 (1/6/2015)

---

Just a minor limitation about the CHECK Constraint. The date columns must not have NULLs in them. Otherwise, SQL will go and check both tables.

CHECK constraints reject values =...

Hallo ZZartin,

sorry but I don't understand your "recommendation". What modification do you want to do to the function?