Output of the select query is

(153148 rows affected)

Thanks a lot GianLuca!

B stands for ?

I read like 'Don't create clustered index on monotonically increasing column' some years back.

In fact, having a Clustered Index...

tonyrogerson-498793 (5/25/2010)

---

I have seen lot of tables with IDENTITY column created with PRIMARY KEY. I am sure we shouldn't create Clustered index/primary key on an IDENTITY column. This is not...

GilaMonster (5/25/2010)

---

There's a big, massive, huge difference between not using an int identity for a primary key...

Grant Fritchey (5/25/2010)

---

Come on Karthik. You've got the name, Joe Celko, and...

what will happen If I delete some rows from the table. wouldn't cause IDENTITY GAP issue? wouldn't waste the datapage space?

Also, let us consider this scenario. Assume the table capture...

can you give me the URL?

I have more than 250 tables in my database. i just want to prepare the list where as the table has primary key only on IDENTITY column.

how?

any other way to pick the egg?

Paul White NZ (5/25/2010)

---

Shame. SQL Server 2008 SP1 CU5 is required to make the OPTION (RECOMPILE) trick fly.

Never mind. Try...

Paul White NZ (5/25/2010)

---

Whatever figure you decide on, remember to send 80% of it to the people on here that have helped you over the last year 😀

More seriously, try...

???

Paul White NZ (5/25/2010)

---

You know the drill...'actual' execution plan, table definitions, indexes, sample data.

By the way, what exact...

Paul White NZ (5/25/2010)

---

Karthik,

The Constant Scan operator is an in-memory...