More undocumented fun: DBCC IND, DBCC PAGE, and off-row columns

re: More undocumented fun: DBCC IND, DBCC PAGE, and off-row columns

Yaniv F — Fri, 10 Dec 2010 15:56:09 GMT

Yes it is working . dbccpagetest = your database name . Please change it to get it working/

DBCC IND ('dbccpagetest', 'rowoverflowtest', 1); , Please

re: More undocumented fun: DBCC IND, DBCC PAGE, and off-row columns

ILIAD — Wed, 15 Jul 2009 16:17:16 GMT

Sorry its working fine

good its very usefull to me

re: More undocumented fun: DBCC IND, DBCC PAGE, and off-row columns

ILIAD — Wed, 15 Jul 2009 16:13:00 GMT

DBCC IND ('dbccpagetest', 'rowoverflowtest', 1);

its not working ...

Geek City: Nonclustered Index Keys

Other Blogs we recommend (SSQA.net) — Wed, 16 Apr 2008 19:45:34 GMT

I recently received a question about the storage of nonclustered index keys. I am assuming you are aware

Geek City: Nonclustered Index Keys

Kalen Delaney — Mon, 17 Mar 2008 05:00:54 GMT

I recently received a question about the storage of nonclustered index keys. I am assuming you are aware

Geek City: Nonclustered Index Keys

Kalen Delaney — Mon, 17 Mar 2008 04:53:18 GMT

I recently received a question about the storage of nonclustered index keys. I am assuming you are aware

re: More undocumented fun: DBCC IND, DBCC PAGE, and off-row columns

Harman Sahni — Wed, 24 Oct 2007 00:50:23 GMT

Paul,

I've been following your posts for sometime now and must appreciate they are simply awesome!

One of my clients recently asked me to analyze deadlocks. In the process I saw DBCC Page showing indid 0 for data pages that were part of a clustered index (in fact the table had just 1 index which was clustered). I thought may be indid for leaf-level pages of clustered indexes are shown as 0 to identify them as actual data pages and not index pages and hence also would have a page type 1 attributed.

Q1. Am I correct in my understanding above? If not, what else could be the the reason?

Q2. (on a seperate note) Do non-leaf level pages have clustering key or RID information as well, just like leaf level pages? If the answer is no, how does the read-ahead mechanism internally work. In fact it would be best if you could give some examples as well.

Geek City: Detecting Overflowing Columns

Kalen Delaney — Tue, 09 Oct 2007 22:27:45 GMT

SQL Server 2005 allows rows to include variable length columns which do not actually fit in the maximum

What is a page split? What happens? Why does it happen? Why worry?

Tony Rogerson's ramblings on SQL Server — Thu, 28 Jun 2007 16:03:34 GMT

You’ve probably heard the term banded around but do you know what it means and what it means to the performance

How does your schema affect your shrink run-time?

SQL Server Storage Engine — Thu, 29 Mar 2007 20:59:56 GMT

For part two of my short series on data file shrinking, I want to look at how elements of your schemas