Hi Faraz,

you can use DBCC IND if you use SQL Server < 2012 or sys.dm_db_database_page_allocation for SQL Server >= 2012.

This will give you a list of allocated pages.

To have a...

+1

I thought beeing in the wrong theater 🙂

gbritton1 (8/27/2014)

---

The question asks, "What happens", yet one of the "correct" answers is that we need to change the variable and replicate lengths. At the risk of being pedantic,...

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.