Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\pkarklin>net statistics server
Server Statistics for \\CLS01NODE05MSK


Statistics since  01.04.2010 8:26 

Sessions accepted                  3
Sessions timed-out                 61
Sessions errored-out               616

Kilobytes sent                     728675321
Kilobytes received                 19512146

Mean response time (msec)          0

System errors                      0
Permission violations              1059
Password violations                179

Files accessed                     4262018
Communication devices accessed     0
Print jobs spooled                 0

Times buffers exhausted

  Big buffers                      0
  Request buffers                  0

The command completed successfully.


C:\Documents and Settings\pkarklin>

USE tempdb
GO

CREATE TABLE dbo.T1(col1 int PRIMARY KEY NONCLUSTERED, col2 char( 4000 ))
GO
INSERT dbo.T1 VALUES( 1 , REPLICATE('A',  4000 ))
INSERT dbo.T1 VALUES( 2 , REPLICATE('B',  4000 ))
INSERT dbo.T1 VALUES( 3 , REPLICATE('C',  4000 ))
GO

SELECT
  col1,
  sys.fn_PhysLocFormatter(%%physloc%%) as [Physical RID]   
FROM
  dbo.T1
GO

col1        Physical RID
----------- -------------
1           (6:5123:0)
2           (6:5123:1)
3           (1:1448:0)

UPDATE
  dbo.T1
SET
  col1 =  4 
WHERE
  col1 =  1 
GO
SELECT
  col1,
  sys.fn_PhysLocFormatter(%%physloc%%) as [Physical RID]   
FROM
  dbo.T1
GO

col1        Physical RID
----------- --------------
4           (6:5123:0)
2           (6:5123:1)
3           (1:1448:0)

USE tempdb
GO

CREATE TABLE dbo.T1(col1 int PRIMARY KEY, col2 char( 4000 ))
GO
INSERT dbo.T1 VALUES( 1 , REPLICATE('A',  4000 ))
INSERT dbo.T1 VALUES( 2 , REPLICATE('B',  4000 ))
INSERT dbo.T1 VALUES( 3 , REPLICATE('C',  4000 ))
GO

SELECT
  col1,
  sys.fn_PhysLocFormatter(%%physloc%%) as [Physical RID]   
FROM
  dbo.T1
GO

col1        Physical RID
----------- -------------
1           (1:1777:0)
2           (1:1777:1)
3           (7:854:0)

UPDATE
  dbo.T1
SET
  col1 =  4 
WHERE
  col1 =  1 
GO
SELECT
  col1,
  sys.fn_PhysLocFormatter(%%physloc%%) as [Physical RID]   
FROM
  dbo.T1
GO

col1        Physical RID
----------- -------------
2           (1:1777:1)
3           (7:854:0)
4           (7:854:1)

Statistics since  01.04.2010 8:26 

 Sessions accepted                  3