rishi-445055 (8/25/2014)

---

Hi,

So if we make Code Nullable should not the query become non-sargeable, thereby meaning it does not use the Index ix_CCode, but making the column as Null still uses...

sql-lover (7/5/2014)

I won't waste my time arguing with you. Your statements clearly shows you have zero working experience.[/QUOTE]

OK - you got me 🙂

sql-lover (7/5/2014)Moreover, based on your posts on this...

sql-lover (7/1/2014)

---

utterly rubbish!

There is no difference between Unique Index and Unique Constraint, besides the obvious syntax of course.[/QUOTE]

I don't know your knowledge but such an ignorance of ANSI defintions is...

sql-lover (6/30/2014)

---

We can't tell you, as only you know how your Index, table and data are being accessed. Plus we don't even know your table's schema.

The main advantage of having...

dhaneenja-755935 (7/1/2014)

---

Hi Ben Kubicek,

It's good Article. I have small Q. if...

Hi Joe,

you compare apples with bananas 🙂

In the...

There will be no additional locks when...

This article is one of the more worse ones because it is dealing with recommendations which - concerning the original requirements of the database - are nonsence:

"because if you don’t...

+1 - I was of two minds when I answered the question

I choose Enterprise...

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...