AAARGH - I'm a scatterbrain.

You are right - it should be 2 not 4!

To early in...

Hi Rishi,

a good (the best) starting point is "SQL Server Internals" from Kalen Delaney. On Page 309 you find a pretty cool explanation of the row structure. Furthermore you will...

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