Click here to Skip to main content
15,173,985 members
Home / Discussions / Database
   

Database

 
AnswerRe: Naming my clustered index column which isn't the PK (and is a non-PK clustered Identity a good idea?) Pin
Eddy Vluggen23-Apr-18 6:19
professionalEddy Vluggen23-Apr-18 6:19 
AnswerRe: Naming my clustered index column which isn't the PK (and is a non-PK clustered Identity a good idea?) Pin
Jörgen Andersson23-Apr-18 22:58
professionalJörgen Andersson23-Apr-18 22:58 
GeneralRe: Naming my clustered index column which isn't the PK (and is a non-PK clustered Identity a good idea?) Pin
JChrisCompton24-Apr-18 12:21
MemberJChrisCompton24-Apr-18 12:21 
GeneralRe: Naming my clustered index column which isn't the PK (and is a non-PK clustered Identity a good idea?) Pin
Eddy Vluggen25-Apr-18 1:41
professionalEddy Vluggen25-Apr-18 1:41 
GeneralRe: Naming my clustered index column which isn't the PK (and is a non-PK clustered Identity a good idea?) Pin
JChrisCompton25-Apr-18 5:40
MemberJChrisCompton25-Apr-18 5:40 
GeneralRe: Naming my clustered index column which isn't the PK (and is a non-PK clustered Identity a good idea?) Pin
Eddy Vluggen25-Apr-18 6:33
professionalEddy Vluggen25-Apr-18 6:33 
GeneralRe: Naming my clustered index column which isn't the PK (and is a non-PK clustered Identity a good idea?) Pin
JChrisCompton30-Apr-18 6:30
MemberJChrisCompton30-Apr-18 6:30 
GeneralRe: Naming my clustered index column which isn't the PK (and is a non-PK clustered Identity a good idea?) Pin
Eddy Vluggen30-Apr-18 6:58
professionalEddy Vluggen30-Apr-18 6:58 
JChrisCompton wrote:
It is great background and wonderfully answers "what is a page split."
Better than I could in a single post, and it is nice to have an actual example that you can copy/paste to try for yourself and see Smile | :)

JChrisCompton wrote:
I didn't find
Let me share more bookmarks Poke tongue | ;-P

How are varchar values stored in a SQL Server database? - Stack Overflow[^] - first answer. I had already forgotten about the option to compress those fields.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

GeneralRe: Naming my clustered index column which isn't the PK (and is a non-PK clustered Identity a good idea?) Pin
JChrisCompton30-Apr-18 8:35
MemberJChrisCompton30-Apr-18 8:35 
GeneralRe: Naming my clustered index column which isn't the PK (and is a non-PK clustered Identity a good idea?) Pin
Eddy Vluggen30-Apr-18 9:13
professionalEddy Vluggen30-Apr-18 9:13 
GeneralRe: Naming my clustered index column which isn't the PK (and is a non-PK clustered Identity a good idea?) Pin
Jörgen Andersson25-Apr-18 3:15
professionalJörgen Andersson25-Apr-18 3:15 
GeneralRe: Naming my clustered index column which isn't the PK (and is a non-PK clustered Identity a good idea?) Pin
JChrisCompton25-Apr-18 6:47
MemberJChrisCompton25-Apr-18 6:47 
GeneralRe: Naming my clustered index column which isn't the PK (and is a non-PK clustered Identity a good idea?) Pin
Jörgen Andersson25-Apr-18 11:49
professionalJörgen Andersson25-Apr-18 11:49 
PraiseRe: Naming my clustered index column which isn't the PK (and is a non-PK clustered Identity a good idea?) Pin
JChrisCompton26-Apr-18 5:17
MemberJChrisCompton26-Apr-18 5:17 
QuestionEXCEPTIONS INTO Equivalent for SQL Server Pin
User 1205041720-Apr-18 5:59
MemberUser 1205041720-Apr-18 5:59 
AnswerRe: EXCEPTIONS INTO Equivalent for SQL Server Pin
Eddy Vluggen23-Apr-18 6:21
professionalEddy Vluggen23-Apr-18 6:21 
GeneralRe: EXCEPTIONS INTO Equivalent for SQL Server Pin
User 1205041723-Apr-18 6:24
MemberUser 1205041723-Apr-18 6:24 
Questionhow to access temp table field in subquery? Pin
joost.versteegen11-Apr-18 22:43
Memberjoost.versteegen11-Apr-18 22:43 
AnswerRe: how to access temp table field in subquery? Pin
Victor Nijegorodov11-Apr-18 23:18
MemberVictor Nijegorodov11-Apr-18 23:18 
AnswerRe: how to access temp table field in subquery? Pin
Mycroft Holmes12-Apr-18 0:42
professionalMycroft Holmes12-Apr-18 0:42 
GeneralRe: how to access temp table field in subquery? Pin
joost.versteegen12-Apr-18 0:53
Memberjoost.versteegen12-Apr-18 0:53 
AnswerRe: how to access temp table field in subquery? Pin
Richard Deeming19-Apr-18 3:34
mveRichard Deeming19-Apr-18 3:34 
QuestionExporting Select statement values into csv with escape characters Pin
indian1439-Apr-18 13:16
Memberindian1439-Apr-18 13:16 
AnswerRe: Exporting Select statement values into csv with escape characters Pin
Victor Nijegorodov9-Apr-18 21:27
MemberVictor Nijegorodov9-Apr-18 21:27 
QuestionReading csv file data using selecte statement Pin
indian1439-Apr-18 7:50
Memberindian1439-Apr-18 7:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.