Perry Whittle (4/21/2010)

---

WhetherIi explained it well or not is anybody's opinion, but then I wasn't aware we were splitting hairs. I just made an observation 😉

Sumanta-1056020 (4/21/2010)

---

Thank you all for the reply.

Anybody knows T-SQL commands to get the data pages for a particular table.

Stefan_G (4/21/2010)

---

select * from dbo.SafeDateAdd(cast('99991231' as datetime),1)

declare @d datetime

set @d=cast('99991231' as datetime)

select * from dbo.SafeDateAdd(@d,1)

Stefan_G (4/21/2010)

---

The only reason I mentioned sysindexes is that it is the easiest way to get the information the OP asked originally asked for.

Stefan_G (4/21/2010)

---

Nice function, the only problem is that this throws an error:

select * from dbo.SafeDateAdd('99991231',1)

Grant Fritchey (4/21/2010)

---

It is a tad costly, but not like the DBCC check.

Stefan_G (4/21/2010)

---

One problem with sys.dm_db_index_physical_stats is that it can take a fair amount of time and resources to run it on a large table.

PaulB-TheOneAndOnly (4/21/2010)

---

...but I'm sure some purist will say you can't have "referential integrity" and "null value" on the same phrase 😉

Ionut Hrubaru (4/21/2010)

---

I just wish it was a bug 🙂

Sumanta-1056020 (4/21/2010)

---

Is there any t-sql commands to get the no. of data pages contained by a particular table and the no. of index pages for a index?

Dohsan (4/21/2010)

---

I was just reading up about possible collation issues using [Aa-Zz] etc, would it make much difference to performance to list them all?

CONSTRAINT CHK_TextCol CHECK (TextCol NOT LIKE '%[^abcedefghijklmnopqrstuvwxyzABCEDEFGHIJKLMNOPQRSTUVWXYZ]%')