Viewing 15 posts - 4,621 through 4,635 (of 7,610 total)
You could also archive first and modify the indexes later.
November 20, 2015 at 1:48 pm
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...
November 20, 2015 at 12:17 pm
--!!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...
November 20, 2015 at 12:08 pm
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...
November 20, 2015 at 11:48 am
First, let's clear this up:
Is it only the user account of the one who made the [transaction], who gets [blocked]?
Absolutely not. SQL doesn't care at all about who did...
November 20, 2015 at 10:38 am
Sergiy (11/19/2015)
ScottPletcher (11/19/2015)
I'm certain they're never running an EXISTS check because they are not reusing codes,
Have a look at the topic starter:
SET @RedemptionCode = dbo.GenerateRandomBase32(@RedemptionSeed)
WHILE((@RedemptionCode IS NULL) OR EXISTS(SELECT RedemptionCode...
November 19, 2015 at 3:53 pm
Sergiy (11/19/2015)
ScottPletcher (11/19/2015)
Yes, by deleting them from the current promo table, not by just flagging them. They...
November 19, 2015 at 3:30 pm
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)
)
November 19, 2015 at 3:27 pm
Sergiy (11/19/2015)
ScottPletcher (11/19/2015)
When it's used up initially, it's removed forever from the current table, since it has no current value.
No person...
November 19, 2015 at 3:05 pm
Sergiy (11/19/2015)
ScottPletcher (11/19/2015)
Sergiy (11/19/2015)
ScottPletcher (11/18/2015)
Once they've been used up, you'd remove them so they can't be reused.
How exactly you intend to prevent used codes from being reused (regenerated as new)...
November 19, 2015 at 2:35 pm
Sergiy (11/19/2015)
ScottPletcher (11/18/2015)
Once they've been used up, you'd remove them so they can't be reused.
How exactly you intend to prevent used codes from being reused (regenerated as new) if they...
November 19, 2015 at 1:40 pm
Sergiy (11/18/2015)
ScottPletcher (11/18/2015)
Once they've been used up, you'd remove them so they can't be reused.
How exactly you intend to prevent used codes from being reused (regenerated as new) if they...
November 19, 2015 at 8:30 am
Sergiy (11/18/2015)
ScottPletcher (11/18/2015)
Lol. So you think Amazon.com has every gift code number they've ever issued in their current gift codes table? Unbelievable.
Why not?
May be not "ever issued", may...
November 18, 2015 at 3:55 pm
Sergiy (11/18/2015)
ScottPletcher (11/18/2015)
November 18, 2015 at 3:04 pm
Sergiy (11/18/2015)
ScottPletcher (11/18/2015)
First, how do you know that inactive codes are routinely searched? That's almost never the case.
Mobile top up numbers. Gift cards. iTunes cards. Game access codes. Software...
November 18, 2015 at 2:49 pm
Viewing 15 posts - 4,621 through 4,635 (of 7,610 total)