Because we have a query which used Nested Loops if we have RANGE_ROWS and then the query performes worse.

But we can't change the query at the moment, that is the...

Hey,

another stupid question. Is it possible to check the codes against a table in which I store old codes ?

The main point is the performance we have to look.

We have...

Hey Jeff,

our customer want to make a promotion on a product package with this codes.

The customer can buy the product and insert the code onto a web page, after that

he...

Absolutly Great job

Hi,

can you send a suggestions for a design of one table with 250 millions rows ?

Greetings

Hi,

thank you for the kind reply. Here are some additional information:

The table structure:

CREATE TABLE [dbo].[Code](

[Code] [varchar](8) NOT NULL,

[State] [tinyint] NOT NULL,

CONSTRAINT [PK_Code] PRIMARY KEY CLUSTERED

(

[Code] ASC

)WITH (PAD_INDEX ...

Is it possible to check the improvement of an covered index without the creation of this index ?

Thanks for all the hints.

I play arround a little bit and I found a way which fits to my needs.

I need now 50 seconds to insert 1 Million rows into...

Every hint, the problem ist that I have to check wether the key exists

in a table of 130 Million rows and after that I have to create 100 Million

unique keys.

Regards

My Problem is that my base table has 130 Million codes

and I have to check if the created 100 Million codes a unique

against my 130 Millions codes and itself.

Therefore all...

Can you please provide me a sample TSQL

Application which replaces the UDF Function ?

ThanK's

Thank's for all the good hints:

I modified my UDF an now I can show the code:

public static SqlString RNGCharacterMask(int codesize, string characters)

{

...

I can not give you the code of the function

because of security reasons....

Only as much the function generates a code with a security cryption provider.

But I have one Problem because...

Hey,

in the data base we have codes which will printed on packages.

We have two things to do:

First we have the generate new codes in some interfalls. Generating means between...

Here are the needed Informations:

CREATE TABLE [dbo].[Codes](

[Code] [char](10) NOT NULL,

CONSTRAINT [PK_Codes] PRIMARY KEY CLUSTERED

(

[Code] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS ...