Reporting Service Advice For Performance











up vote
1
down vote

favorite












I am looking reporting tools for mssql. Our database is working on sql server. Besides, we calculated total record count . It is about 288000000. I need to get data fastly. But which tool do i need to use?. (There will be monthly, weekly and yearly reports or statistical tables will be prepared like pivot table)










share|improve this question









New contributor




erdi büyük is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.




















  • And all the rows are presented on one row? If only small part how it perform in SSMS to retrieve the data?
    – Grzesiek Danowski
    Nov 8 at 10:46










  • How to ask: Is your question about programming? Does not seem to be the case, unfortunately.
    – mikuszefski
    Nov 8 at 10:48










  • There will be monthly, weekly and yearly reports. Statistical tables will be prepared like pivot table.
    – erdi büyük
    Nov 8 at 11:13















up vote
1
down vote

favorite












I am looking reporting tools for mssql. Our database is working on sql server. Besides, we calculated total record count . It is about 288000000. I need to get data fastly. But which tool do i need to use?. (There will be monthly, weekly and yearly reports or statistical tables will be prepared like pivot table)










share|improve this question









New contributor




erdi büyük is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.




















  • And all the rows are presented on one row? If only small part how it perform in SSMS to retrieve the data?
    – Grzesiek Danowski
    Nov 8 at 10:46










  • How to ask: Is your question about programming? Does not seem to be the case, unfortunately.
    – mikuszefski
    Nov 8 at 10:48










  • There will be monthly, weekly and yearly reports. Statistical tables will be prepared like pivot table.
    – erdi büyük
    Nov 8 at 11:13













up vote
1
down vote

favorite









up vote
1
down vote

favorite











I am looking reporting tools for mssql. Our database is working on sql server. Besides, we calculated total record count . It is about 288000000. I need to get data fastly. But which tool do i need to use?. (There will be monthly, weekly and yearly reports or statistical tables will be prepared like pivot table)










share|improve this question









New contributor




erdi büyük is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











I am looking reporting tools for mssql. Our database is working on sql server. Besides, we calculated total record count . It is about 288000000. I need to get data fastly. But which tool do i need to use?. (There will be monthly, weekly and yearly reports or statistical tables will be prepared like pivot table)







sql-server service reporting reporting-tools






share|improve this question









New contributor




erdi büyük is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question









New contributor




erdi büyük is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question








edited Nov 8 at 11:21





















New contributor




erdi büyük is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked Nov 8 at 10:43









erdi büyük

62




62




New contributor




erdi büyük is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





erdi büyük is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






erdi büyük is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.












  • And all the rows are presented on one row? If only small part how it perform in SSMS to retrieve the data?
    – Grzesiek Danowski
    Nov 8 at 10:46










  • How to ask: Is your question about programming? Does not seem to be the case, unfortunately.
    – mikuszefski
    Nov 8 at 10:48










  • There will be monthly, weekly and yearly reports. Statistical tables will be prepared like pivot table.
    – erdi büyük
    Nov 8 at 11:13


















  • And all the rows are presented on one row? If only small part how it perform in SSMS to retrieve the data?
    – Grzesiek Danowski
    Nov 8 at 10:46










  • How to ask: Is your question about programming? Does not seem to be the case, unfortunately.
    – mikuszefski
    Nov 8 at 10:48










  • There will be monthly, weekly and yearly reports. Statistical tables will be prepared like pivot table.
    – erdi büyük
    Nov 8 at 11:13
















And all the rows are presented on one row? If only small part how it perform in SSMS to retrieve the data?
– Grzesiek Danowski
Nov 8 at 10:46




And all the rows are presented on one row? If only small part how it perform in SSMS to retrieve the data?
– Grzesiek Danowski
Nov 8 at 10:46












How to ask: Is your question about programming? Does not seem to be the case, unfortunately.
– mikuszefski
Nov 8 at 10:48




How to ask: Is your question about programming? Does not seem to be the case, unfortunately.
– mikuszefski
Nov 8 at 10:48












There will be monthly, weekly and yearly reports. Statistical tables will be prepared like pivot table.
– erdi büyük
Nov 8 at 11:13




There will be monthly, weekly and yearly reports. Statistical tables will be prepared like pivot table.
– erdi büyük
Nov 8 at 11:13

















active

oldest

votes











Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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
});


}
});






erdi büyük is a new contributor. Be nice, and check out our Code of Conduct.










 

draft saved


draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53206072%2freporting-service-advice-for-performance%23new-answer', 'question_page');
}
);

Post as a guest





































active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes








erdi büyük is a new contributor. Be nice, and check out our Code of Conduct.










 

draft saved


draft discarded


















erdi büyük is a new contributor. Be nice, and check out our Code of Conduct.













erdi büyük is a new contributor. Be nice, and check out our Code of Conduct.












erdi büyük is a new contributor. Be nice, and check out our Code of Conduct.















 


draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53206072%2freporting-service-advice-for-performance%23new-answer', 'question_page');
}
);

Post as a guest




















































































Popular posts from this blog

Guess what letter conforming each word

Port of Spain

Run scheduled task as local user group (not BUILTIN)