The random number piece should perform well, but it's no good as a primary key or as the leading edge of a clustered index, which kind of defeats the purpose...

Is it possible it doesn't have stats on the heap? That might make a scan less expensive than a set of seeks, if it has to generate stats on-the-fly....

iruagawal (9/2/2009)

---

well, maybe not exactly security, but more like preventing some people from guestimating how many goods placed by looking at the id and doing some calculations. How can I...

You're welcome. Glad I could help.

I'd go with this:

select id, pubKey

from xpt

inner join

(select ADSX.Nodes.value('(.)[1]','varchar(100)') as ADSXValue

from @adsx.nodes('/R/AD') ADSX(Nodes)) Sub

on xpt.pubKey = Sub.ADSXValue;

Edit: Actually, I'd probably do...

I can think of a couple of ways to achieve that. Easiest would be checksum and newID. But I have to ask what that could possibly have to...

Definitely not something you want to try to do with T-SQL stored procs. That kind of thing is much easier to achieve in .NET, and it'll do a better...

Looks like what you're aiming at is a slight variation on a pretty normal tree-view.

Usually, the way you generate those, is have an XML query that produces the data you...

Trust me, my brain is beyond...

Generally speaking, shrinking your database every day is a bad idea. It results in index and table fragmentation, which causes the whole database to slow down. It also...

That should work fine for log shipping. Just not for clustered virtualization.

create trigger dbo.NameStuff on dbo.MySourceTable

after insert

as

set nocount on;

insert into dbo.MyTargetTable (Name)

select Name

from inserted

where Name is not null;

It'll look something like that. If you select from the "inserted" table where...

Without access to your database, I can't be certain, but most likely, because there aren't any rows that satisfy all your criteria.

You're correct...

This is why I keep suggesting a FAQ page, where we can post common answers to common questions. Like "How do I start out as a DBA?", "Why was...