Bi项目和更快的SQL [英] Bi projects and faster SQL

问题描述

我是SSIS的新手
先生/妈妈，请告诉我，

1)如何在bi项目中获得需求以及将需求存储在何处
2)如果我在sql server中有查询，它要花1个小时来执行我想用10 minits执行的操作?


[edit]标题，整理，一些拼写和大写字母-OriginalGriff [/edit]

Hi I am new for SSIS
Please tell me sir/mam,

1) how to get the requirement in bi projects and where it store
2) if I have query in sql server it takes time to execute 1 hour I want to execute with in 10 minits what to do?


[edit]Title, tidy up, some spelling and capitalization - OriginalGriff[/edit]

推荐答案

1)我没有商业智能项目的经验-不能在那里帮忙.

2)两种选择:
2.1)获得更快的硬件(无论瓶颈在哪里，SQL Server PC，网络).
2.2)改进您的SQL语句和/或数据库组织.

如果不了解您的查询应该做什么以及如何执行，将无法进一步回答.

1) I have no experience with Business Intelligence projects - can''t help there.

2) Two options:
2.1) Get faster hardware (SQL Server PC(s), network - wherever the bottleneck is.)
2.2) Improve your SQL statement and / or database organisation.

Without knowing more about what you query is supposed to do, and how it does it, It is not possible to answer further.

这篇关于Bi项目和更快的SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！