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...
_____________
Code for TallyGenerator
November 24, 2015 at 6:55 pm
It seems you need something like "Running Totals".
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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.
_____________
Code for TallyGenerator
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:
http://www.sqlservercentral.com/Forums/FindPost1738471.aspx
_____________
Code for TallyGenerator
November 23, 2015 at 4:19 am
John Mitchell-245523 (11/22/2015)
_____________
Code for TallyGenerator
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,...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
November 20, 2015 at 4:47 pm
John Mitchell-245523 (11/20/2015)
_____________
Code for TallyGenerator
November 20, 2015 at 1:11 pm
You know, not everywhere on Earth people use Western encoding of Latin alphabet.
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
November 19, 2015 at 8:32 pm
Viewing 15 posts - 1,801 through 1,815 (of 6,036 total)