Rowguid - index in system table

Hi,
I am dealing with merge replication.
The missing statistics event points out [MSmerge_tombstone].[rowguid] in all
our databases. Noticed that no specific index for rowguid created in
[MSmerge_tombstone] table specific on this column.
We would like to know why there is no index created on this column.Do we
need to manually create this index?
Does this missing statistics is an indication of potential problem. If so
what could be the corrective action(s) ?
Thanks,
Soura
indexes are only used if the table is greater than 100 pages. This means
that if more than 1500 rows exist in your tombstone table it would benefit
for queries which are done on the rowguid column alone.
The most significant column in the queries is the generation column and also
on the tablenick and rowguid columns. There are indexes on these columns.
Which queries/procs are complaining about the missing statistics? Does
autocreate and auto update statistics help with the performance of this
database?
Also note that by default the metadata tables are cleaned up each time the
merge agent runs so they should be small.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"SouRa" <SouRa@.discussions.microsoft.com> wrote in message
news:16760881-928B-4137-A542-D430C97ACC78@.microsoft.com...
> Hi,
> I am dealing with merge replication.
> The missing statistics event points out [MSmerge_tombstone].[rowguid] in
> all
> our databases. Noticed that no specific index for rowguid created in
> [MSmerge_tombstone] table specific on this column.
> We would like to know why there is no index created on this column.Do we
> need to manually create this index?
> Does this missing statistics is an indication of potential problem. If so
> what could be the corrective action(s) ?
> Thanks,
> Soura

Rowcount in tables

Can someone throw light on how to get the rowcount of a table that is stored in any system tables? I want to get tablename and rowcount for all user tables in a database in a query. Is there anyway other than count(*)?
Thanks
VinnieDBCC UPDATEUSAGE (0) WITH COUNT_ROWS (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_24rp.asp)

SELECT rows, Object_name(id)
FROM dbo.sysindexes
WHERE indid IN (0, 1)If you skip the DBCC, you'll get a SWAG guess, but none too accurate in a busy server.

-PatP|||sysindexes has a rowcount, see BOL for more details on this.

EDIT: sniped again!|||Thanks guys.|||Check for sp_spaceused. It may help you.|||Here's my little addtion to the pile: (built on MSSQL2k)

DECLARE @.MinSize dec(28,2), @.LikeName varchar(45), @.SizeSort bit, @.IncludeLogs bit
--DBCC UPDATEUSAGE(0) WITH COUNT_ROWS

SET @.MinSize = .00
SET @.LikeName = '' --Company%'
SET @.SizeSort = 1
SET @.IncludeLogs = 0

/*
** We need to create a temp table to do the calculation.
** reserved: sum(reserved) where indid in (0, 1, 255)
** data: sum(dpages) where indid < 2 + sum(used) where indid = 255 (text)

** indexp: sum(used) where indid in (0, 1, 255) - data
** unused: sum(reserved) - sum(used) where indid in (0, 1, 255)
*/
IF @.LikeName = '' SET @.LikeName = '%'

CREATE TABLE #space
(
name varchar(30),
id int,
type char(1),
rows int NULL,
reserved dec(28,2) NULL,
data dec(28,2) NULL,
datapages dec(28,2) NULL,
blob dec(28,2) NULL,
indexp dec(28,2) NULL,
unused dec(28,2) NULL,
rowsize dec(28,2) NULL
)

SET NOCOUNT ON

/************************************************** ***********
** Generate a list of all User and System tables.
** AND
** Now calculate the summary data.
** reserved: sum(reserved) where indid in (0, 1, 255)
*/
INSERT INTO #space (name, id, type, reserved)
SELECT LEFT(obj.name,30), obj.id, obj.type, SUM(reserved)
FROM sysindexes idx, sysobjects obj
WHERE idx.id = obj.id
AND idx.indid IN (0, 1, 255)
AND obj.type in ('S','U')
AND obj.name != 'syslogs'
AND obj.name LIKE @.LikeName
AND (@.IncludeLogs = 1 OR obj.name NOT LIKE '%Log')
GROUP BY obj.name, obj.id, obj.type

/************************************************** ***********
** Initialize these to zero.
*/
UPDATE #space
SET rows = 0, data = 0, blob = 0, indexp = 0, unused = 0

/************************************************** ***********
** data: sum(dpages) where indid < 2
** + sum(used) where indid = 255 (text)
*/
UPDATE #space
SET data = data + ISNULL((
SELECT SUM(idx.dpages)
FROM sysindexes idx
WHERE id = spc.id
AND idx.indid < 2), 0)
FROM #space spc

UPDATE #space
SET blob = blob + ISNULL((
SELECT SUM(idx.used)
FROM sysindexes idx
WHERE id = spc.id
AND idx.indid = 255), 0)
FROM #space spc

/************************************************** ***********
** index: sum(used) where indid in (0, 1, 255) - data space
*/
UPDATE #space
SET indexp = ISNULL((
SELECT SUM(idx.used)
FROM sysindexes idx
WHERE id = spc.id
AND idx.indid IN (0, 1, 255)), 0) - data - blob
FROM #space spc

/************************************************** ***********
** unused: sum(reserved) - sum(used) where indid in (0, 1, 255)
*/
UPDATE #space
SET unused = reserved - ISNULL((
SELECT SUM(idx.used)
FROM sysindexes idx
WHERE id = spc.id
AND idx.indid IN (0, 1, 255)), 0)
FROM #space spc

/************************************************** ***********
** rows: rows where indid < 2
*/
UPDATE #space
SET rows = idx.rows
FROM #space spc, sysindexes idx
WHERE spc.id = idx.id
AND idx.indid < 2

/************************************************** ***********
** Page Size: for Windows NT
*/
DECLARE @.PageSize int, @.UsablePage int
SELECT @.PageSize = low
FROM master.dbo.spt_values
WHERE number = 1 AND type = 'E'

set @.UsablePage = @.PageSize - 132

/************************************************** ***********
** Compute the results
*/
UPDATE #space SET
reserved = reserved * @.PageSize,
datapages = data,
data = data * @.PageSize,
blob = blob * @.PageSize,
indexp = indexp * @.PageSize,
unused = unused * @.PageSize

UPDATE #space SET
rowsize =
CASE
WHEN rows < 50 THEN -1
ELSE ((data) / rows)
END

UPDATE #space SET
reserved = reserved / 1024.0 / 1024.0,
data = data / 1024.0 / 1024.0,
blob = blob / 1024.0 / 1024.0,
indexp = indexp / 1024.0 / 1024.0,
unused = unused / 1024.0 / 1024.0

/************************************************** ***********
** Finally: output the report header

*/

PRINT GETDATE()
PRINT ''

IF @.MinSize != 0
PRINT 'Tables with a Total space used of ' + LTRIM(STR(@.MinSize, 8,1)) + ' MB or greater in the ' + DB_NAME() + ' database.'
ELSE
PRINT 'All tables in the ' + DB_NAME() + ' database.'

PRINT ''

/************************************************** ***********
** Finally: output the totals
*/

DECLARE @.DataTotal dec(28,2), @.BlobTotal dec(28,2), @.IndexTotal dec(28,2), @.Format varchar(15)

SELECT @.DataTotal = SUM(data),
@.BlobTotal = SUM(blob),
@.IndexTotal = SUM(indexp)
FROM #space

SET @.Format = CONVERT(varchar(15),convert(money,@.DataTotal+@.Blob Total+@.IndexTotal),1)
PRINT 'Space used : ' + REPLICATE(' ',15-DATALENGTH(@.Format)) + @.Format + ' MB'
SET @.Format = CONVERT(varchar(15),convert(money,@.DataTotal),1)
PRINT 'Space used by table data : ' + REPLICATE(' ',15-DATALENGTH(@.Format)) + @.Format + ' MB'
SET @.Format = CONVERT(varchar(15),convert(money,@.BlobTotal),1)
PRINT 'Space used by text/image data : ' + REPLICATE(' ',15-DATALENGTH(@.Format)) + @.Format + ' MB'
SET @.Format = CONVERT(varchar(15),convert(money,@.IndexTotal),1)
PRINT 'Space used by table indexes : ' + REPLICATE(' ',15-DATALENGTH(@.Format)) + @.Format + ' MB'
SET @.Format = CONVERT(varchar(15),@.PageSize)
PRINT 'Page size : ' + REPLICATE(' ',15-DATALENGTH(@.Format)) + @.Format + ' Bytes'
SET @.Format = CONVERT(varchar(15),@.UsablePage)
PRINT 'Usable Page size : ' + REPLICATE(' ',15-DATALENGTH(@.Format)) + @.Format + ' Bytes'
PRINT ''

/************************************************** ***********

** Finally: output the detail
*/

update #space
set rowsize = CASE
WHEN rowsize < 0 THEN 0
WHEN (data) < .1 THEN 0
ELSE rowsize
END

SELECT
TableName = name,
Rows = convert(varchar(11),CONVERT(varchar(15),convert(mo ney,rows),1)),
Total = convert(varchar(11),CONVERT(varchar(15),convert(mo ney,data+blob+indexp),1)),
Data = convert(varchar(11),CONVERT(varchar(15),convert(mo ney,data),1)),
Blob = convert(varchar(11),CONVERT(varchar(15),convert(mo ney,blob),1)),
Indexes = convert(varchar(11),CONVERT(varchar(15),convert(mo ney,indexp),1)),
RowBytes = convert(varchar(11),
CASE
WHEN rowsize = 0 THEN 'n/a'
ELSE CONVERT(varchar(15),convert(money,rowsize),1)
END),
RowsPage = convert(varchar(11),
CASE
WHEN rows = 0 THEN 'n/a'
ELSE CONVERT(varchar(15),convert(money,rows/datapages),1)
END),
Pages = convert(varchar(11),CONVERT(varchar(15),convert(mo ney,datapages),1)),
TotalSize = data+indexp+blob
INTO #report
FROM #space
WHERE data+indexp >= @.MinSize AND type = 'U' and name != 'dtproperties'

UPDATE #report
SET Rows = REPLACE(REPLACE(Rows,'.00',''),'.0',''),
Pages = REPLACE(REPLACE(Pages,'.00',''),'.0','')

UPDATE #report
SET Rows = REPLICATE(' ',11-DATALENGTH(Rows)) + Rows,
Total = REPLICATE(' ',11-DATALENGTH(Total)) + Total,
Data = REPLICATE(' ',11-DATALENGTH(Data)) + Data,
Blob = REPLICATE(' ',11-DATALENGTH(Blob)) + Blob,
Indexes = REPLICATE(' ',11-DATALENGTH(Indexes)) + Indexes,
RowsPage = REPLICATE(' ',11-DATALENGTH(RowsPage)) + RowsPage,
Pages = REPLICATE(' ',11-DATALENGTH(Pages)) + Pages,
RowBytes = REPLICATE(' ',11-DATALENGTH(RowBytes)) + RowBytes

PRINT ' --- Average --- ----- Table Space In MB -----'

IF @.SizeSort = 1
SELECT
TableName,
' Row Size' = RowBytes,
' Rows/Page' = RowsPage,
' Data Pages' = Pages,
' Rows' = Rows,
' Total' = Total,
' Data' = Data,
' Text/Img' = Blob,
' Index' = Indexes
FROM #report
ORDER BY TotalSize DESC
ELSE
SELECT
TableName,
' Row Size' = RowBytes,
' Rows/Page' = RowsPage,
' Data Pages' = Pages,
' Rows' = Rows,
' Total' = Total,
' Data' = Data,
' Text/Img' = Blob,
' Index' = Indexes
FROM #report
ORDER BY TableName

PRINT ''

DROP TABLE #space
DROP TABLE #report|||Here's my little addtion to the pile: (built on MSSQL2k)Great zot there, bubba! I'd consider that a pile all its own, not an addition to an existing pile! Whew, I can't wait to see a major contribution!

-PatP|||I got the following errors when I ran this in Query Analyzer:

Server: Msg 137, Level 15, State 2, Line 172
Must declare the variable '@.Blob'.
Server: Msg 170, Level 15, State 1, Line 201
Line 201: Incorrect syntax near 'ney'.|||i think you might have a simple wrapping issue...@.blob isnt a variable in this script but @.blobtotal is.

testing it...that is exactly what happened...

any tips on posting this without having the format chang on me?|||try the attachment...

for some reason pasting it FROM this forum adds some freaky yeaky spaces.

they dont appear as spaces in the forum window, but they sure as hell get added if you copy/paste it out of here...

...sorry...forum noooob issue.|||Cool that worked. Check this script out that I've been using.sql

Row level filtering (does not need to be secure)

I'm trying to design a system where I can filter (not secure) a users results, the user may or may not pass in a user ID. We typically use middle tier connection pooling with a single identity, so I believe labelling is not suitable.

I think the ideal solution would be...

User to establishes a connection through our application, a user id will be established as part of the connection. A view is created describing what the user is able to access. Preferably the user should not be aware of the view. The user or our application executes a number of select queries.

Note that there may be many users with different filters required connecting at any time.

Direct user updates of the table do not need to be supported.

This topic comes up on the forums from time to time in the context of row level security.

The following whitepaper may also be useful to you:

http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx

It uses labeling but I think your solution will require something like that because you are pushing an id for the user down to SQL Server from the middle tier.

HTH,

-Steven Gott

S/DET

SQL Server

Row based security

I have a database system that contains 1 category of data.
There are plans in the future to add other categories of data as well.
Some users of the database can have access to 1 or more of the categories of
data, and other users can only have access to 1 category, and non of the
other categories of data.
I have a solution in place for row level security using stored procedures
and lookup tables to define what data can be viewed by what users.
In the Oracle world, row based security is handled, but in SQL Server there
is no mechanism in place within the security model to accommodate for it.
What are some approaches in SQL Server that others have used to accommodate
for Row level security issues?
Simon WorthCheck this link for an approach on how do implement row level security in SQ
L
Server:
http://vyaskn.tripod.com/ row_level...as
es.htm
-Sue
"Simon Worth" wrote:

> I have a database system that contains 1 category of data.
> There are plans in the future to add other categories of data as well.
> Some users of the database can have access to 1 or more of the categories
of
> data, and other users can only have access to 1 category, and non of the
> other categories of data.
> I have a solution in place for row level security using stored procedures
> and lookup tables to define what data can be viewed by what users.
> In the Oracle world, row based security is handled, but in SQL Server ther
e
> is no mechanism in place within the security model to accommodate for it.
> What are some approaches in SQL Server that others have used to accommodat
e
> for Row level security issues?
> --
> Simon Worth
>
>|||Thanks Sue,
I've read that article before, and that's actually were I developed some
ideas from.
I was just wondering what others have done in the past, or are planning on
implementing in the future.
Just curiosity I guess. Plus, once in awhile you get an answer that really
makes sense that you hadn't thought of before.
Simon Worth
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:0D4434BE-321E-4A38-87BF-2D08A238D35F@.microsoft.com...
> Check this link for an approach on how do implement row level security in
SQL[vbcol=seagreen]
> Server:
> http://vyaskn.tripod.com/ row_level...as
es.htm
> -Sue
> "Simon Worth" wrote:
>
categories of[vbcol=seagreen]
procedures[vbcol=seagreen]
there[vbcol=seagreen]
it.[vbcol=seagreen]
accommodate[vbcol=seagreen]

Rough estimate of Database Size

We are running a Finance System using SQL Server 2000. The production
database is around 20GB in size.
Since the system supports SQL Server 2005 and we are going to replace the
existing server, we would like to use SQL Server 2005 as backend database.
As we are in the sizing stage, we would like to get an estimate of the
database with SQL Server 2005.
We would like to know is there any way to find out the size of the
corresponding SQL server 2005 database. We would also like to know what
factors affect the size of database ? Is there any special feature in SQL
Server 2005 takes up more space ?
ThanksPeter
Don't you perfrom some monitoring such as how often your DB was growing?
What does the appliaction do more INSERTS/UPDATE/DELETE or SELECTs?
Well I know it is hard to get on right target , so create the database with
max estimated size and don't use Automatically autogrow file feature. It is
very important especially for LOG file as it grows much more often than
DATA file. Use filegrowth in megabytes feature ,something like 500 MB or 1GB
For SQL Server 2005 there is 'instant file initialization' feature( for
data files only) . Make sure that SQL Server account is added to Perform
volume Maintenance Task
http://support.microsoft.com/kb/931843
http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:eVypU0V6HHA.5212@.TK2MSFTNGP04.phx.gbl...
> We are running a Finance System using SQL Server 2000. The production
> database is around 20GB in size.
> Since the system supports SQL Server 2005 and we are going to replace the
> existing server, we would like to use SQL Server 2005 as backend database.
> As we are in the sizing stage, we would like to get an estimate of the
> database with SQL Server 2005.
> We would like to know is there any way to find out the size of the
> corresponding SQL server 2005 database. We would also like to know what
> factors affect the size of database ? Is there any special feature in SQL
> Server 2005 takes up more space ?
> Thanks
>|||Dear Uri,
The database has around 100 insert / update transactions a day. The others
just perform read only.
Does index structure in SQL Server 2000 is different from that from SQL
Server 2005 ?
Thanks
Peter
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eLtsDDW6HHA.5316@.TK2MSFTNGP04.phx.gbl...
> Peter
> Don't you perfrom some monitoring such as how often your DB was growing?
> What does the appliaction do more INSERTS/UPDATE/DELETE or SELECTs?
> Well I know it is hard to get on right target , so create the database
> with max estimated size and don't use Automatically autogrow file
> feature. It is very important especially for LOG file as it grows much
> more often than DATA file. Use filegrowth in megabytes feature ,something
> like 500 MB or 1GB
> For SQL Server 2005 there is 'instant file initialization' feature( for
> data files only) . Make sure that SQL Server account is added to Perform
> volume Maintenance Task
> http://support.microsoft.com/kb/931843
> http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx
> http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx
> "Peter" <Peter@.discussions.microsoft.com> wrote in message
> news:eVypU0V6HHA.5212@.TK2MSFTNGP04.phx.gbl...
>> We are running a Finance System using SQL Server 2000. The production
>> database is around 20GB in size.
>> Since the system supports SQL Server 2005 and we are going to replace the
>> existing server, we would like to use SQL Server 2005 as backend
>> database.
>> As we are in the sizing stage, we would like to get an estimate of the
>> database with SQL Server 2005.
>> We would like to know is there any way to find out the size of the
>> corresponding SQL server 2005 database. We would also like to know what
>> factors affect the size of database ? Is there any special feature in
>> SQL Server 2005 takes up more space ?
>> Thanks
>|||Peter
> Does index structure in SQL Server 2000 is different from that from SQL
> Server 2005 ?
No
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:%23xO2eNW6HHA.3940@.TK2MSFTNGP05.phx.gbl...
> Dear Uri,
> The database has around 100 insert / update transactions a day. The
> others just perform read only.
> Does index structure in SQL Server 2000 is different from that from SQL
> Server 2005 ?
> Thanks
> Peter
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eLtsDDW6HHA.5316@.TK2MSFTNGP04.phx.gbl...
>> Peter
>> Don't you perfrom some monitoring such as how often your DB was growing?
>> What does the appliaction do more INSERTS/UPDATE/DELETE or SELECTs?
>> Well I know it is hard to get on right target , so create the database
>> with max estimated size and don't use Automatically autogrow file
>> feature. It is very important especially for LOG file as it grows much
>> more often than DATA file. Use filegrowth in megabytes feature ,something
>> like 500 MB or 1GB
>> For SQL Server 2005 there is 'instant file initialization' feature( for
>> data files only) . Make sure that SQL Server account is added to Perform
>> volume Maintenance Task
>> http://support.microsoft.com/kb/931843
>> http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx
>> http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx
>> "Peter" <Peter@.discussions.microsoft.com> wrote in message
>> news:eVypU0V6HHA.5212@.TK2MSFTNGP04.phx.gbl...
>> We are running a Finance System using SQL Server 2000. The production
>> database is around 20GB in size.
>> Since the system supports SQL Server 2005 and we are going to replace
>> the existing server, we would like to use SQL Server 2005 as backend
>> database.
>> As we are in the sizing stage, we would like to get an estimate of the
>> database with SQL Server 2005.
>> We would like to know is there any way to find out the size of the
>> corresponding SQL server 2005 database. We would also like to know what
>> factors affect the size of database ? Is there any special feature in
>> SQL Server 2005 takes up more space ?
>> Thanks
>>
>|||You can use your existing SQL Server 2000 database as a good estimate of
2005 space requirements. The new features that come to mind that will
affect space are vardecimal and included index columns. Tempdb space may
need to be significantly larger, depending on the features you use. See
http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx.
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:eVypU0V6HHA.5212@.TK2MSFTNGP04.phx.gbl...
> We are running a Finance System using SQL Server 2000. The production
> database is around 20GB in size.
> Since the system supports SQL Server 2005 and we are going to replace the
> existing server, we would like to use SQL Server 2005 as backend database.
> As we are in the sizing stage, we would like to get an estimate of the
> database with SQL Server 2005.
> We would like to know is there any way to find out the size of the
> corresponding SQL server 2005 database. We would also like to know what
> factors affect the size of database ? Is there any special feature in SQL
> Server 2005 takes up more space ?
> Thanks
>|||Isn't instant file initialization an Enterprise Edition only feature?
TheSQLGuru
President
Indicium Resources, Inc.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eLtsDDW6HHA.5316@.TK2MSFTNGP04.phx.gbl...
> Peter
> Don't you perfrom some monitoring such as how often your DB was growing?
> What does the appliaction do more INSERTS/UPDATE/DELETE or SELECTs?
> Well I know it is hard to get on right target , so create the database
> with max estimated size and don't use Automatically autogrow file
> feature. It is very important especially for LOG file as it grows much
> more often than DATA file. Use filegrowth in megabytes feature ,something
> like 500 MB or 1GB
> For SQL Server 2005 there is 'instant file initialization' feature( for
> data files only) . Make sure that SQL Server account is added to Perform
> volume Maintenance Task
> http://support.microsoft.com/kb/931843
> http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx
> http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx
> "Peter" <Peter@.discussions.microsoft.com> wrote in message
> news:eVypU0V6HHA.5212@.TK2MSFTNGP04.phx.gbl...
>> We are running a Finance System using SQL Server 2000. The production
>> database is around 20GB in size.
>> Since the system supports SQL Server 2005 and we are going to replace the
>> existing server, we would like to use SQL Server 2005 as backend
>> database.
>> As we are in the sizing stage, we would like to get an estimate of the
>> database with SQL Server 2005.
>> We would like to know is there any way to find out the size of the
>> corresponding SQL server 2005 database. We would also like to know what
>> factors affect the size of database ? Is there any special feature in
>> SQL Server 2005 takes up more space ?
>> Thanks
>|||On Tue, 28 Aug 2007 14:20:06 +0300, "Uri Dimant" <urid@.iscar.co.il>
wrote:
>Peter
>> Does index structure in SQL Server 2000 is different from that from SQL
>> Server 2005 ?
>No
Isn't there something about the uniquifiers for clustered indexes ...
But even if IIRC, that's not going to cost more than a percent or so
on a typical database. Is it?
J.|||JXStern
> Isn't there something about the uniquifiers for clustered indexes ...
No it is the same, i.e if you create CI but not UNIQUE , sql server adds
uniquifiers to the index
> But even if IIRC, that's not going to cost more than a percent or so
> on a typical database. Is it?
Sorry , what is IIRC?
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:vue8d351pro4etm0hr1bi04pp8802in7hj@.4ax.com...
> On Tue, 28 Aug 2007 14:20:06 +0300, "Uri Dimant" <urid@.iscar.co.il>
> wrote:
>>Peter
>> Does index structure in SQL Server 2000 is different from that from SQL
>> Server 2005 ?
>>No
> Isn't there something about the uniquifiers for clustered indexes ...
> But even if IIRC, that's not going to cost more than a percent or so
> on a typical database. Is it?
> J.
>|||On Wed, 29 Aug 2007 10:50:49 +0300, "Uri Dimant" <urid@.iscar.co.il>
wrote:
>JXStern
>> Isn't there something about the uniquifiers for clustered indexes ...
>No it is the same, i.e if you create CI but not UNIQUE , sql server adds
>uniquifiers to the index
>> But even if IIRC, that's not going to cost more than a percent or so
>> on a typical database. Is it?
>Sorry , what is IIRC?
If I Recall Correctly ... but it looks like I didn't.
J.
>"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
>news:vue8d351pro4etm0hr1bi04pp8802in7hj@.4ax.com...
>> On Tue, 28 Aug 2007 14:20:06 +0300, "Uri Dimant" <urid@.iscar.co.il>
>> wrote:
>>Peter
>> Does index structure in SQL Server 2000 is different from that from SQL
>> Server 2005 ?
>>No
>> Isn't there something about the uniquifiers for clustered indexes ...
>> But even if IIRC, that's not going to cost more than a percent or so
>> on a typical database. Is it?
>> J.
>