The "good answer" is false if "the clustered and nonclustered indexes are disabled". It is working only when a clustered or non-clustered index is disabled...

I know that an old question...

I have done the bad choice and that's a good question as I have learnt many things.

So thank you for the Creator of this QotD , for Hugo who is...

Easy question as I remembered a session from a senior member of the french support ( who created SQL Server Nexus ) 2 years ago. But I was not sure...

Thanks for this easy question.

Thanks for this easy question.

I was able to reply correctly only because I have followed a session about SQL Server Azure.

A little difference : the speaker warned us during a...

Revenant (6/8/2015)

---

mhynds (6/8/2015)

---

Now that's a comment I'm interested in. When a database is in an unhealthy state, the 'icon' is gray. Geeze, if you disable an index maybe...

Good question.

Last month , I have done some tests to compare both versions 2008 R2 and 2014 and I have some problems.

2008 R2 accepts to script everything even disabled indexes...

timwell (6/5/2015)

---

Of course we have to assume that neither username nor gender are "a computed column, a UDT column, a spatial data type column, or a hierarchyID data type column"...

Ed Wagner (6/3/2015)

---

I found this to be very interesting because it got me thinking of the age-old argument of formatting the data in the database versus on the client-side. ...

Nice question but an easy one.

When I installed my SQL Server 2012 Express , I have discovered this way to format a number in the BOL and I have tested...

Thanks for your explanation that I think to have understood. But I am a slow man , so I think I will need some time to assimilate what you have...

Hugo Kornelis (5/28/2015)

---

Okay, I am going to contest this one. I know that Books Online says that "Aggregate" can be "a logical operator or a physical operator". But who has...

Thanks for this easy question. But it remembers me an interview in 2010 where I have not been able to give the good solution ( the sysadmin permission was too...

I have chosen AGGREGATE only as I have remembered a session in the SQL Server Days near Paris where the speaker told us that this operator was appearing when MIN...

Good question. I has chosen the 1st choice only because I found 25 and I have read 25th May = Memorial Day only on last week.

If I have...