Viewing 15 posts - 1,801 through 1,815 (of 6,036 total)
Welsh Corgi (11/24/2015)
I can easily archive the tables without running into the risk of having to tune the...
November 24, 2015 at 6:55 pm
It seems you need something like "Running Totals".
November 23, 2015 at 5:48 pm
GilaMonster (10/12/2015)
Be careful with table variables, because they don't have statistics
Not quite true.
They do not have statistics only if you have not created them.
But this table variable will have...
November 23, 2015 at 3:29 pm
Load a file to a table:
1. From a local folder (local to the server)
2. From a network location.
November 23, 2015 at 3:19 pm
Jayanth_Kurup (11/23/2015)
Me and Jeff have been having a side bar on this discussion and he will be posting his findings shortly.
I have already posted my findings here:
November 23, 2015 at 4:19 am
John Mitchell-245523 (11/22/2015)
November 22, 2015 at 7:59 pm
John Mitchell-245523 (11/22/2015)
Yes, I understand all that. My only point was that a char(3) primary key is no more alien to non-western eyes than a GUID one.
That is right,...
November 22, 2015 at 4:33 pm
Leaving the merky waters of international standards aside:
Did you ever compare the performance of an INNER JOIN on integer (or binary) columns vs. on character columns (considering they are populated...
November 21, 2015 at 5:03 am
John Mitchell-245523 (11/21/2015)
Sergiy (11/20/2015)
First - GIUD is not made of characters. It's a 16 bytes long binary value.
I thought you'd say that. You're right, but it's still rendered as...
November 21, 2015 at 4:51 am
Sean Lange (11/20/2015)
Sergiy (11/20/2015)
And third - US states abbreviations are definitely not an international standard. "CA" - what is it? California? Or Canada?
That is just absurd. There is no standard...
November 20, 2015 at 4:47 pm
John Mitchell-245523 (11/20/2015)
November 20, 2015 at 1:11 pm
You know, not everywhere on Earth people use Western encoding of Latin alphabet.
November 20, 2015 at 4:12 am
Sean Lange (11/19/2015)
I would hope that for lookup tables like states and currencies you don't use a guid as the primary key. The ANSI abbreviation is an excellent choice for...
November 20, 2015 at 2:09 am
Would it be easier to add a minimal required age to student's birthday and see if the returned date (date when the student reach the required age) <= of the...
November 19, 2015 at 9:26 pm
OK,
Here we go.
The test as promissed.
Starting with creating a table:
CREATE TABLE [dbo].[UsedRedemptionCodesTest](
[RedemptionCodeID] [int] IDENTITY(1,1) NOT NULL,
[RedemptionCode] [char](36) NULL,
[IsActive] [bit] NOT NULL,
CONSTRAINT [PK_UsedRedemptionCodesTest_RedemptionCodeID] PRIMARY KEY CLUSTERED ([IsActive], [RedemptionCodeID] ASC))
CREATE UNIQUE NONCLUSTERED...
November 19, 2015 at 8:32 pm
Viewing 15 posts - 1,801 through 1,815 (of 6,036 total)