That's extremely bizarre. They can just do:

WHERE pk = '10000'

and if pk is a numeric type, SQL will convert the 10000 to that type and be able to do...

I'm not talking about partitioning, I'm talking about index tuning, particularly first selecting the best clustered index. Most tables don't really need partitioned. I partition mainly to allow...

You could also archive first and modify the indexes later.

The main thing is to make sure the tables are properly clustered. Often that will give you good performance from the table even without archiving (or partitioning).

Partitioning is sometimes...

--!!NOTE: showing missing indexes can take some time; set @list_missing_indexes = 0 below if you don't want to wait!!

--USE [your_db_name]

SET DEADLOCK_PRIORITY -8 --make sure we are the victim if we...

Would need to see the view definition and related table definitions.

If you're serious about tuning the tables, rather than just this specific query, would also need to see...

First, let's clear this up:

Absolutely not. SQL doesn't care at all about who did...

Sergiy (11/19/2015)

---

Have a look at the topic starter:

SET @RedemptionCode = dbo.GenerateRandomBase32(@RedemptionSeed)

WHILE((@RedemptionCode IS NULL) OR EXISTS(SELECT RedemptionCode...

Sergiy (11/19/2015)

---

ScottPletcher (11/19/2015)

---

When one campaign is over all the relevant promo codes are made inactive.

Yes, by deleting them from the current promo table, not by just flagging them. They...

To have the index automatically built, you can add a persisted, computed column, like this:

CREATE TABLE search_T

(

num INT,

value VARCHAR(max),

value_for_indexing as cast(left(value,896) as varchar(896)) persisted

,UNIQUE CLUSTERED (num,value_for_indexing)

)

Sergiy (11/19/2015)

---

ScottPletcher (11/19/2015)

---

Try to follow this, it's simple enough even for you.

When it's used up initially, it's removed forever from the current table, since it has no current value.

No person...

Sergiy (11/19/2015)

---

ScottPletcher (11/19/2015)

---

Sergiy (11/19/2015)

How exactly you intend to prevent used codes from being reused (regenerated as new)...

Sergiy (11/19/2015)

How exactly you intend to prevent used codes from being reused (regenerated as new) if they...

Sergiy (11/18/2015)

---

How exactly you intend to prevent used codes from being reused (regenerated as new) if they...

Sergiy (11/18/2015)

---

Why not?

May be not "ever issued", may...