INTO / SELECT tempdb 80GB
What is "desert glass" and what does it do to the PCs?
Iron deposits mined from under the city
Why can't we use freedom of speech and expression to incite people to rebel against government in India?
Learning to quickly identify valid fingering for piano?
Forcing Mathematica's Integrate to give more general answers
Exit statuses of comparisons in test constructs
Are small insurances worth it
Paper published similar to PhD thesis
How do we objectively assess if a dialogue sounds unnatural or cringy?
Is divide-by-zero a security vulnerability?
Does the US political system, in principle, allow for a no-party system?
Is being socially reclusive okay for a graduate student?
PTiJ: How should animals pray?
Why aren't there more gauls like Obelix?
PSPICE - must be 'I' or 'V' error
Drawing the Möbius band and the Klein bottle
Convert an array of objects to array of the objects' values
Where do you go through passport control when transiting through another Schengen airport on your way out of the Schengen area?
Should we avoid writing fiction about historical events without extensive research?
Named nets not connected in Eagle board design
What does "rhumatis" mean?
Sundering Titan and basic normal lands and snow lands
Naming Characters after Friends/Family
PTIJ: Aliyot for the deceased
INTO / SELECT tempdb 80GB
I have a table 1.3 million rows, 22 vars. The count of unique values are as follows:
var1 880
var2 300
var3 240
var4 200
var5 50
var6 50
var7 40
var8 40
var9 40
var10 10
var11 50
var12 7 million
var13 7 million
var14 7 million
var15 7 million
var16 7 million
var17 5 million
var18 5 million
var19 5 million
var20 5 million
var21 9 million
var22 9 million
I make sense to divide this in 3 tables. What is the recommended option to add indexes using INTO SELECT for the three tables?
tempdb select-into
asked 54 secs ago
AllanAllan
1
New contributor
Allan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have a table 1.3 million rows, 22 vars. The count of unique values are as follows:
var1 880
var2 300
var3 240
var4 200
var5 50
var6 50
var7 40
var8 40
var9 40
var10 10
var11 50
var12 7 million
var13 7 million
var14 7 million
var15 7 million
var16 7 million
var17 5 million
var18 5 million
var19 5 million
var20 5 million
var21 9 million
var22 9 million
I make sense to divide this in 3 tables. What is the recommended option to add indexes using INTO SELECT for the three tables?
tempdb select-into
asked 54 secs ago
AllanAllan
1
New contributor
Allan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have a table 1.3 million rows, 22 vars. The count of unique values are as follows:
var1 880
var2 300
var3 240
var4 200
var5 50
var6 50
var7 40
var8 40
var9 40
var10 10
var11 50
var12 7 million
var13 7 million
var14 7 million
var15 7 million
var16 7 million
var17 5 million
var18 5 million
var19 5 million
var20 5 million
var21 9 million
var22 9 million
I make sense to divide this in 3 tables. What is the recommended option to add indexes using INTO SELECT for the three tables?
tempdb select-into
asked 54 secs ago
AllanAllan
1
New contributor
Allan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have a table 1.3 million rows, 22 vars. The count of unique values are as follows:
var1 880
var2 300
var3 240
var4 200
var5 50
var6 50
var7 40
var8 40
var9 40
var10 10
var11 50
var12 7 million
var13 7 million
var14 7 million
var15 7 million
var16 7 million
var17 5 million
var18 5 million
var19 5 million
var20 5 million
var21 9 million
var22 9 million
I make sense to divide this in 3 tables. What is the recommended option to add indexes using INTO SELECT for the three tables?
tempdb select-into
tempdb select-into
asked 54 secs ago
AllanAllan
1
New contributor
Allan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 54 secs ago
AllanAllan
1
New contributor
Allan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 54 secs ago
AllanAllan
1
New contributor
Allan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 54 secs ago
AllanAllan
1
asked 54 secs ago
AllanAllan
1
1
New contributor
Allan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Allan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Allan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Allan is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f231616%2finto-select-tempdb-80gb%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Allan is a new contributor. Be nice, and check out our Code of Conduct.
Allan is a new contributor. Be nice, and check out our Code of Conduct.
Allan is a new contributor. Be nice, and check out our Code of Conduct.
Allan is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f231616%2finto-select-tempdb-80gb%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
