Production Report against OLAP database

We have a large number of (Crystal) Reports ( based on Stor Proc ) running
against our OLTP database (SQL Server).
Instead of reports running against OLTP database I would like to create
Cubes and create production reports against them.
Is it possible to do that? Are there any client applications which allows to
create these types of reports? We don't need real time information.
Any help is greatly appreciated."Atul Mehta" <amehta@.oaktreecap.com> schrieb im Newsbeitrag
news:ub8DdHCvDHA.1740@.TK2MSFTNGP12.phx.gbl...

quote:

---

> We have a large number of (Crystal) Reports ( based on Stor Proc ) running
> against our OLTP database (SQL Server).
> Instead of reports running against OLTP database I would like to create
> Cubes and create production reports against them.
> Is it possible to do that? Are there any client applications which allows

---

to

quote:

---

> create these types of reports? We don't need real time information.
> Any help is greatly appreciated.

---

Atul, you don't necessarily need another Reporting Tool. You need to decide
where you want to build your -> Data Warehouse or -> Data Mart in.
Regards,
Joerg|||If you're looking for cheap and easy, office web components (pivot tables),
or cheap and tedious: ASP web pages and PTS. You might want to see if MSFT
Reporting Services is a potential solution for you.
Another option is to build a star schema reporting database, which will be
useful for building cubes as well, but may eliminate the need.
"Atul Mehta" <amehta@.oaktreecap.com> wrote in message
news:ub8DdHCvDHA.1740@.TK2MSFTNGP12.phx.gbl...

quote:

---

> We have a large number of (Crystal) Reports ( based on Stor Proc ) running
> against our OLTP database (SQL Server).
> Instead of reports running against OLTP database I would like to create
> Cubes and create production reports against them.
> Is it possible to do that? Are there any client applications which allows

---

to

quote:

---

> create these types of reports? We don't need real time information.
> Any help is greatly appreciated.
>
>
>

---

Product Sales Forecasting.

Hi,

We are trying to forcast product sales for next three months based on their sales for previous 12 months. In this case, Microsoft Time Series algorithm requires the sales data to be present for each product for past 12 months (?). However, our products have typical life span of 6 months and obviously the new products will not have sales before they were added. Any help will be very much appreciated.

Thanks

Riju

Riju -

A few pointers that have been very successful for us in forecasting sales and inventory:

1. Can you build store clustering models to increase the data set size?
2. For new products you can also try correlating sales from similar existing products. We have utilized attributes from existing products and mapped their sales as a predictor for new product sales.

Here is a whitepaper that provides a detailed inventory forecasting example from Project REAL http://apollodatatech.com/company/shell.html?projreal

Hope this helps,

Jeff

Please visit Apollo Data Technologies http://apollodatatech.com/|||

Hi Jeff,

Thanks for the response.

It seems that the Out-of-stock predictive model in REAL project is based in the Decision Tree algorithm which does not require the data to be present for each period. I am having problem to use Time Series algorithm becuase my products typically have sales for about six month and i am trying to use the last 12 months data to predict the sales of next 3 months.

Thanks

Riju

|||

This must be a common problem in forcasting. Isn't there any way to handle this?

Thanks

Riju

|||You should read the paper referenced by apollo. In these circumstances you likely need to build a tree model to predict based on similar products, not use time series as there's not enough historical data.|||

Hi Jamie,

Thanks for the response.

I read the paper referenced by Apollow which gave the detail information on how to predict the product sales using the Decision Tree algorithm. However, i was trying to get some help on how to use the Time Series algorithm in my situation. Thanks to your response which stated that the Time Series algorithm is not applicable in my situation.

Riju

Producing several letters based on the results of a query

I have created a single page letter using a number of text boxes and one
table, which is populated with static text along with some data from a single
row results set. This works perfectly when the results set only contains one
row, but when there are multiple data rows, the report still only contains
one page, whereas I expected there to be a page for every row.
A simple way to reproduce this is to create a report with a single text box
containing the value of one column from a query that returns multiple rows.
This results in a one page report, rather than a page for each row returned.
I'd be grateful if someone can help with this - I'm hoping there's a simple
solution, like setting a 'repeating region' property.
By the way, I've tried creating a single column table in the hope I could
put the entire contents of the letter into a cell of the table and that the
table row (and therefore the letter) would then repeat for each row of data,
but it doesn't appear to be possible to fix the size of a table row and have
multiple text boxes (and a table) inside it.
Thanks in advance,
David.Hey David,
If I understand you correctly, your trying to make, basically, a form
letter, that populates the variables from a query. For example
This is my test letter to "DAVID".
Where "DAVID" is generated from column/row in your Dataset. Why can't you
make a single cell table with all the text as you want it, except insert the
Field references you need (instead of textboxes)? For Example, the cell
would look like:
= "This is my test letter to " & Fields!ContactName.Value & ". " &
Fields!ContactName.Value & " lives at " & Fields!ContactAddy.Value & "."
etc...
Once this is done, you choose the "Group" properties and place a page break
after each group (or row in this case). This creates a new letter, each on
its own pages, for each row returned.
Michael C
"David C" wrote:
> I have created a single page letter using a number of text boxes and one
> table, which is populated with static text along with some data from a single
> row results set. This works perfectly when the results set only contains one
> row, but when there are multiple data rows, the report still only contains
> one page, whereas I expected there to be a page for every row.
> A simple way to reproduce this is to create a report with a single text box
> containing the value of one column from a query that returns multiple rows.
> This results in a one page report, rather than a page for each row returned.
> I'd be grateful if someone can help with this - I'm hoping there's a simple
> solution, like setting a 'repeating region' property.
> By the way, I've tried creating a single column table in the hope I could
> put the entire contents of the letter into a cell of the table and that the
> table row (and therefore the letter) would then repeat for each row of data,
> but it doesn't appear to be possible to fix the size of a table row and have
> multiple text boxes (and a table) inside it.
> Thanks in advance,
> David.|||Thanks Michael - it was the grouping that I needed. I actually stumbled
across the same answer last night in a TechNet article
(http://technet.microsoft.com/en-us/library/ms155816.aspx).
I put a List in first and then added a single column Table to it. I then
created a group expression on the list in Properties - General - Edit Details
Group - General, as follows: -
=Ceiling(RowNumber(Nothing)/1)
I also set 'Page break at end'.
Is this what you meant?
My problem now is that I want to make some of the text bold and I thought
I'd be able to do this using the Format command - something like Format("some
text", "Bold"), but that doesn't seem to work. Have you any idea how I can do
that?
Thanks again.
David.
"Michael C" wrote:
> Hey David,
> If I understand you correctly, your trying to make, basically, a form
> letter, that populates the variables from a query. For example
> This is my test letter to "DAVID".
> Where "DAVID" is generated from column/row in your Dataset. Why can't you
> make a single cell table with all the text as you want it, except insert the
> Field references you need (instead of textboxes)? For Example, the cell
> would look like:
> = "This is my test letter to " & Fields!ContactName.Value & ". " &
> Fields!ContactName.Value & " lives at " & Fields!ContactAddy.Value & "."
> etc...
> Once this is done, you choose the "Group" properties and place a page break
> after each group (or row in this case). This creates a new letter, each on
> its own pages, for each row returned.
> Michael C
> "David C" wrote:
> > I have created a single page letter using a number of text boxes and one
> > table, which is populated with static text along with some data from a single
> > row results set. This works perfectly when the results set only contains one
> > row, but when there are multiple data rows, the report still only contains
> > one page, whereas I expected there to be a page for every row.
> >
> > A simple way to reproduce this is to create a report with a single text box
> > containing the value of one column from a query that returns multiple rows.
> > This results in a one page report, rather than a page for each row returned.
> >
> > I'd be grateful if someone can help with this - I'm hoping there's a simple
> > solution, like setting a 'repeating region' property.
> >
> > By the way, I've tried creating a single column table in the hope I could
> > put the entire contents of the letter into a cell of the table and that the
> > table row (and therefore the letter) would then repeat for each row of data,
> > but it doesn't appear to be possible to fix the size of a table row and have
> > multiple text boxes (and a table) inside it.
> >
> > Thanks in advance,
> >
> > David.|||Hey David,
Unfortunately I do not think there is a way, and if there i do not know
it. I had asked the forum recently about 2 fonts, 1 control but got no
responses.
You have done basically what I was describing. Glad it (sort of) worked for
you.
Michael
"David C" wrote:
> Thanks Michael - it was the grouping that I needed. I actually stumbled
> across the same answer last night in a TechNet article
> (http://technet.microsoft.com/en-us/library/ms155816.aspx).
> I put a List in first and then added a single column Table to it. I then
> created a group expression on the list in Properties - General - Edit Details
> Group - General, as follows: -
> =Ceiling(RowNumber(Nothing)/1)
> I also set 'Page break at end'.
> Is this what you meant?
> My problem now is that I want to make some of the text bold and I thought
> I'd be able to do this using the Format command - something like Format("some
> text", "Bold"), but that doesn't seem to work. Have you any idea how I can do
> that?
> Thanks again.
> David.
>
> "Michael C" wrote:
> > Hey David,
> > If I understand you correctly, your trying to make, basically, a form
> > letter, that populates the variables from a query. For example
> >
> > This is my test letter to "DAVID".
> >
> > Where "DAVID" is generated from column/row in your Dataset. Why can't you
> > make a single cell table with all the text as you want it, except insert the
> > Field references you need (instead of textboxes)? For Example, the cell
> > would look like:
> >
> > = "This is my test letter to " & Fields!ContactName.Value & ". " &
> > Fields!ContactName.Value & " lives at " & Fields!ContactAddy.Value & "."
> > etc...
> >
> > Once this is done, you choose the "Group" properties and place a page break
> > after each group (or row in this case). This creates a new letter, each on
> > its own pages, for each row returned.
> >
> > Michael C
> >
> > "David C" wrote:
> >
> > > I have created a single page letter using a number of text boxes and one
> > > table, which is populated with static text along with some data from a single
> > > row results set. This works perfectly when the results set only contains one
> > > row, but when there are multiple data rows, the report still only contains
> > > one page, whereas I expected there to be a page for every row.
> > >
> > > A simple way to reproduce this is to create a report with a single text box
> > > containing the value of one column from a query that returns multiple rows.
> > > This results in a one page report, rather than a page for each row returned.
> > >
> > > I'd be grateful if someone can help with this - I'm hoping there's a simple
> > > solution, like setting a 'repeating region' property.
> > >
> > > By the way, I've tried creating a single column table in the hope I could
> > > put the entire contents of the letter into a cell of the table and that the
> > > table row (and therefore the letter) would then repeat for each row of data,
> > > but it doesn't appear to be possible to fix the size of a table row and have
> > > multiple text boxes (and a table) inside it.
> > >
> > > Thanks in advance,
> > >
> > > David.|||Hi Michael,
The text I wanted to be in bold was on a separate line, so in the end I just
put in a separate row in the table and set the row to bold. This worked fine,
presumably because the List control was handling the grouping.
Thanks again for your help.
David.
"Michael C" wrote:
> Hey David,
> Unfortunately I do not think there is a way, and if there i do not know
> it. I had asked the forum recently about 2 fonts, 1 control but got no
> responses.
> You have done basically what I was describing. Glad it (sort of) worked for
> you.
> Michael
> "David C" wrote:
> > Thanks Michael - it was the grouping that I needed. I actually stumbled
> > across the same answer last night in a TechNet article
> > (http://technet.microsoft.com/en-us/library/ms155816.aspx).
> >
> > I put a List in first and then added a single column Table to it. I then
> > created a group expression on the list in Properties - General - Edit Details
> > Group - General, as follows: -
> >
> > =Ceiling(RowNumber(Nothing)/1)
> >
> > I also set 'Page break at end'.
> >
> > Is this what you meant?
> >
> > My problem now is that I want to make some of the text bold and I thought
> > I'd be able to do this using the Format command - something like Format("some
> > text", "Bold"), but that doesn't seem to work. Have you any idea how I can do
> > that?
> >
> > Thanks again.
> >
> > David.
> >
> >
> >
> > "Michael C" wrote:
> >
> > > Hey David,
> > > If I understand you correctly, your trying to make, basically, a form
> > > letter, that populates the variables from a query. For example
> > >
> > > This is my test letter to "DAVID".
> > >
> > > Where "DAVID" is generated from column/row in your Dataset. Why can't you
> > > make a single cell table with all the text as you want it, except insert the
> > > Field references you need (instead of textboxes)? For Example, the cell
> > > would look like:
> > >
> > > = "This is my test letter to " & Fields!ContactName.Value & ". " &
> > > Fields!ContactName.Value & " lives at " & Fields!ContactAddy.Value & "."
> > > etc...
> > >
> > > Once this is done, you choose the "Group" properties and place a page break
> > > after each group (or row in this case). This creates a new letter, each on
> > > its own pages, for each row returned.
> > >
> > > Michael C
> > >
> > > "David C" wrote:
> > >
> > > > I have created a single page letter using a number of text boxes and one
> > > > table, which is populated with static text along with some data from a single
> > > > row results set. This works perfectly when the results set only contains one
> > > > row, but when there are multiple data rows, the report still only contains
> > > > one page, whereas I expected there to be a page for every row.
> > > >
> > > > A simple way to reproduce this is to create a report with a single text box
> > > > containing the value of one column from a query that returns multiple rows.
> > > > This results in a one page report, rather than a page for each row returned.
> > > >
> > > > I'd be grateful if someone can help with this - I'm hoping there's a simple
> > > > solution, like setting a 'repeating region' property.
> > > >
> > > > By the way, I've tried creating a single column table in the hope I could
> > > > put the entire contents of the letter into a cell of the table and that the
> > > > table row (and therefore the letter) would then repeat for each row of data,
> > > > but it doesn't appear to be possible to fix the size of a table row and have
> > > > multiple text boxes (and a table) inside it.
> > > >
> > > > Thanks in advance,
> > > >
> > > > David.

Processor License

I am going to have to install a web based application on a SQL server that
has 4 processors. The web application will integrate with SQL. I do not
have any control over the users that access this system. I am assuming I
will need to but a 4 processor license for SQL. Is there anyway I can run
SQL on just the 1 processor and buy a single processor license?Here is an article on Microsoft's site. It suggests that you would need to
make the processor unavailable to the OS as well.
http://www.microsoft.com/sql/howtobuy/processor.asp
As always. Contact your reseller for an official answer.
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Sarah Kingswell" <sarah.kingswell@.ntlworld.com> wrote in message
news:%23c5oilvlDHA.2592@.TK2MSFTNGP10.phx.gbl...
> I am going to have to install a web based application on a SQL server that
> has 4 processors. The web application will integrate with SQL. I do not
> have any control over the users that access this system. I am assuming I
> will need to but a 4 processor license for SQL. Is there anyway I can run
> SQL on just the 1 processor and buy a single processor license?
>|||In addition to Allan's answer, the general rule by MS has been that IF the
procs are on the motherboard (whether or not you have them disabled for SQL
Server use), you must buy licenses for that proc - or take the proc off of
the motherboard...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sarah Kingswell" <sarah.kingswell@.ntlworld.com> wrote in message
news:#c5oilvlDHA.2592@.TK2MSFTNGP10.phx.gbl...
> I am going to have to install a web based application on a SQL server that
> has 4 processors. The web application will integrate with SQL. I do not
> have any control over the users that access this system. I am assuming I
> will need to but a 4 processor license for SQL. Is there anyway I can run
> SQL on just the 1 processor and buy a single processor license?
>|||Hi Wayne!
> In addition to Allan's answer, the general rule by MS has been that IF the
> procs are on the motherboard (whether or not you have them disabled for SQL
> Server use), you must buy licenses for that proc - or take the proc off of
> the motherboard...
In the word doc released in May, MS softened down this a bit. Here's a quote:
You must acquire licenses for only those processors that are accessible to any operating system copy
upon which the Server Software is set up to run
· Microsoft is enhancing its server licensing to make it more cost-effective for customers
to utilize Server Software licensed in the Per Processor model when the software, through
partitioning or other similar technology, does not utilize all of the processors in a server.
The URL is:
http://www.microsoft.com/licensing/downloads/Server%20Licensing%20Customer%20Guide.doc
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:%23h6$JawlDHA.1084@.tk2msftngp13.phx.gbl...
> In addition to Allan's answer, the general rule by MS has been that IF the
> procs are on the motherboard (whether or not you have them disabled for SQL
> Server use), you must buy licenses for that proc - or take the proc off of
> the motherboard...
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Sarah Kingswell" <sarah.kingswell@.ntlworld.com> wrote in message
> news:#c5oilvlDHA.2592@.TK2MSFTNGP10.phx.gbl...
> > I am going to have to install a web based application on a SQL server that
> > has 4 processors. The web application will integrate with SQL. I do not
> > have any control over the users that access this system. I am assuming I
> > will need to but a 4 processor license for SQL. Is there anyway I can run
> > SQL on just the 1 processor and buy a single processor license?
> >
> >
>|||Hi Tibor...
How have you been doing?
Does that mean that SQL enabled to use 2 procs on an 8 proc machine only
requires 2 proc licenses?
thanks bud, I didn't know that...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:eRxFjtwlDHA.2652@.TK2MSFTNGP09.phx.gbl...
> Hi Wayne!
> > In addition to Allan's answer, the general rule by MS has been that IF
the
> > procs are on the motherboard (whether or not you have them disabled for
SQL
> > Server use), you must buy licenses for that proc - or take the proc off
of
> > the motherboard...
> In the word doc released in May, MS softened down this a bit. Here's a
quote:
> You must acquire licenses for only those processors that are accessible to
any operating system copy
> upon which the Server Software is set up to run
> · Microsoft is enhancing its server licensing to make it more
cost-effective for customers
> to utilize Server Software licensed in the Per Processor model when the
software, through
> partitioning or other similar technology, does not utilize all of the
processors in a server.
>
>
> The URL is:
>
http://www.microsoft.com/licensing/downloads/Server%20Licensing%20Customer%2
0Guide.doc
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
> "Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
> news:%23h6$JawlDHA.1084@.tk2msftngp13.phx.gbl...
> > In addition to Allan's answer, the general rule by MS has been that IF
the
> > procs are on the motherboard (whether or not you have them disabled for
SQL
> > Server use), you must buy licenses for that proc - or take the proc off
of
> > the motherboard...
> >
> >
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Computer Education Services Corporation (CESC), Charlotte, NC
> > www.computeredservices.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> >
> >
> > "Sarah Kingswell" <sarah.kingswell@.ntlworld.com> wrote in message
> > news:#c5oilvlDHA.2592@.TK2MSFTNGP10.phx.gbl...
> > > I am going to have to install a web based application on a SQL server
that
> > > has 4 processors. The web application will integrate with SQL. I do
not
> > > have any control over the users that access this system. I am
assuming I
> > > will need to but a 4 processor license for SQL. Is there anyway I can
run
> > > SQL on just the 1 processor and buy a single processor license?
> > >
> > >
> >
> >
>|||My reading of the doc - If the processor is available to the OS, you have to
pay... I'll ask someone at PASS next month... Are you coming?...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:eRxFjtwlDHA.2652@.TK2MSFTNGP09.phx.gbl...
> Hi Wayne!
> > In addition to Allan's answer, the general rule by MS has been that IF
the
> > procs are on the motherboard (whether or not you have them disabled for
SQL
> > Server use), you must buy licenses for that proc - or take the proc off
of
> > the motherboard...
> In the word doc released in May, MS softened down this a bit. Here's a
quote:
> You must acquire licenses for only those processors that are accessible to
any operating system copy
> upon which the Server Software is set up to run
> · Microsoft is enhancing its server licensing to make it more
cost-effective for customers
> to utilize Server Software licensed in the Per Processor model when the
software, through
> partitioning or other similar technology, does not utilize all of the
processors in a server.
>
>
> The URL is:
>
http://www.microsoft.com/licensing/downloads/Server%20Licensing%20Customer%2
0Guide.doc
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
> "Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
> news:%23h6$JawlDHA.1084@.tk2msftngp13.phx.gbl...
> > In addition to Allan's answer, the general rule by MS has been that IF
the
> > procs are on the motherboard (whether or not you have them disabled for
SQL
> > Server use), you must buy licenses for that proc - or take the proc off
of
> > the motherboard...
> >
> >
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Computer Education Services Corporation (CESC), Charlotte, NC
> > www.computeredservices.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> >
> >
> > "Sarah Kingswell" <sarah.kingswell@.ntlworld.com> wrote in message
> > news:#c5oilvlDHA.2592@.TK2MSFTNGP10.phx.gbl...
> > > I am going to have to install a web based application on a SQL server
that
> > > has 4 processors. The web application will integrate with SQL. I do
not
> > > have any control over the users that access this system. I am
assuming I
> > > will need to but a 4 processor license for SQL. Is there anyway I can
run
> > > SQL on just the 1 processor and buy a single processor license?
> > >
> > >
> >
> >
>|||Hi Wayne,
> How have you been doing?
I'm good, thanks! Hope you are too :-)
> Does that mean that SQL enabled to use 2 procs on an 8 proc machine only
> requires 2 proc licenses?
Just trimming affinity mask doesn't help, need to be restricted at the OS level (as you posted in
the other post).
> My reading of the doc - If the processor is available to the OS, you have to
> pay... I'll ask someone at PASS next month...
Yep, that is my interpretation as well. Let us know of you get some conflicting info.
> I'll ask someone at PASS next month... Are you coming?...
I'm afraid not. Too much going on here... :-)
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:%23H5Hq$zlDHA.1764@.tk2msftngp13.phx.gbl...
> Hi Tibor...
> How have you been doing?
> Does that mean that SQL enabled to use 2 procs on an 8 proc machine only
> requires 2 proc licenses?
> thanks bud, I didn't know that...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
> wrote in message news:eRxFjtwlDHA.2652@.TK2MSFTNGP09.phx.gbl...
> > Hi Wayne!
> >
> > > In addition to Allan's answer, the general rule by MS has been that IF
> the
> > > procs are on the motherboard (whether or not you have them disabled for
> SQL
> > > Server use), you must buy licenses for that proc - or take the proc off
> of
> > > the motherboard...
> >
> > In the word doc released in May, MS softened down this a bit. Here's a
> quote:
> > You must acquire licenses for only those processors that are accessible to
> any operating system copy
> > upon which the Server Software is set up to run
> > · Microsoft is enhancing its server licensing to make it more
> cost-effective for customers
> > to utilize Server Software licensed in the Per Processor model when the
> software, through
> > partitioning or other similar technology, does not utilize all of the
> processors in a server.
> >
> >
> >
> >
> >
> > The URL is:
> >
> http://www.microsoft.com/licensing/downloads/Server%20Licensing%20Customer%2
> 0Guide.doc
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at: http://groups.google.com/groups?oi=djq&as
> ugroup=microsoft.public.sqlserver
> >
> >
> > "Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
> > news:%23h6$JawlDHA.1084@.tk2msftngp13.phx.gbl...
> > > In addition to Allan's answer, the general rule by MS has been that IF
> the
> > > procs are on the motherboard (whether or not you have them disabled for
> SQL
> > > Server use), you must buy licenses for that proc - or take the proc off
> of
> > > the motherboard...
> > >
> > >
> > >
> > > --
> > > Wayne Snyder, MCDBA, SQL Server MVP
> > > Computer Education Services Corporation (CESC), Charlotte, NC
> > > www.computeredservices.com
> > > (Please respond only to the newsgroups.)
> > >
> > > I support the Professional Association of SQL Server (PASS) and it's
> > > community of SQL Server professionals.
> > > www.sqlpass.org
> > >
> > >
> > > "Sarah Kingswell" <sarah.kingswell@.ntlworld.com> wrote in message
> > > news:#c5oilvlDHA.2592@.TK2MSFTNGP10.phx.gbl...
> > > > I am going to have to install a web based application on a SQL server
> that
> > > > has 4 processors. The web application will integrate with SQL. I do
> not
> > > > have any control over the users that access this system. I am
> assuming I
> > > > will need to but a 4 processor license for SQL. Is there anyway I can
> run
> > > > SQL on just the 1 processor and buy a single processor license?
> > > >
> > > >
> > >
> > >
> >
> >
>

Processor based license will improve performance?

If we use processor based license for SQL Server will that improve
performance compare to CAL based licensing?
Thanks.
Ram
Ram wrote:
> If we use processor based license for SQL Server will that improve
> performance compare to CAL based licensing?
> Thanks.
> Ram
>
no!
|||No. It's just a different licence agreement. The software is the same in each
case.
David Portas
SQL Server MVP
|||Performance and License are two different and unrelated things. However, as
a side effect, if by acquiring more licenses (Seat based or Processor based)
you are adding
more users, then, ofcourse, the new users will impact performance.
Gopi
"Ram" <Ramakrishna.pothuganti@.vizual.co.in> wrote in message
news:ejOjuswSFHA.2304@.tk2msftngp13.phx.gbl...
> If we use processor based license for SQL Server will that improve
> performance compare to CAL based licensing?
> Thanks.
> Ram
>

Processor based license will improve performance?

If we use processor based license for SQL Server will that improve
performance compare to CAL based licensing?
Thanks.
RamRam wrote:
> If we use processor based license for SQL Server will that improve
> performance compare to CAL based licensing?
> Thanks.
> Ram
>
no!|||No. It's just a different licence agreement. The software is the same in eac
h
case.
David Portas
SQL Server MVP
--|||Performance and License are two different and unrelated things. However, as
a side effect, if by acquiring more licenses (Seat based or Processor based)
you are adding
more users, then, ofcourse, the new users will impact performance.
Gopi
"Ram" <Ramakrishna.pothuganti@.vizual.co.in> wrote in message
news:ejOjuswSFHA.2304@.tk2msftngp13.phx.gbl...
> If we use processor based license for SQL Server will that improve
> performance compare to CAL based licensing?
> Thanks.
> Ram
>

Processor based license will improve performance?

If we use processor based license for SQL Server will that improve
performance compare to CAL based licensing?
Thanks.
RamRam wrote:
> If we use processor based license for SQL Server will that improve
> performance compare to CAL based licensing?
> Thanks.
> Ram
>
no!|||No. It's just a different licence agreement. The software is the same in each
case.
--
David Portas
SQL Server MVP
--|||Performance and License are two different and unrelated things. However, as
a side effect, if by acquiring more licenses (Seat based or Processor based)
you are adding
more users, then, ofcourse, the new users will impact performance.
Gopi
"Ram" <Ramakrishna.pothuganti@.vizual.co.in> wrote in message
news:ejOjuswSFHA.2304@.tk2msftngp13.phx.gbl...
> If we use processor based license for SQL Server will that improve
> performance compare to CAL based licensing?
> Thanks.
> Ram
>sql

Processing priority based on client connection?

Is there a way to set a process priority in SQL Server 2000 based upon the
client or connection type being used to access the data? For example, on a
particular database, I want to give the client application for which the
database was designed priority over other connections such as Microsoft
Access or Seagate Crystal Reports.
Can this be done?As far as I know, it is not possible to set priority based on the client =or the connection.
-- Keith
"Glen Appleton" <buglen@.hotmail.com> wrote in message =news:O432%23p2uDHA.1788@.tk2msftngp13.phx.gbl...
> Is there a way to set a process priority in SQL Server 2000 based upon =the
> client or connection type being used to access the data? For example, =on a
> particular database, I want to give the client application for which =the
> database was designed priority over other connections such as =Microsoft
> Access or Seagate Crystal Reports.
> > Can this be done?
> >

Processing one row at a time

I'm populating a new table based on information in an existing table. The new table is a list of all "items" and contains a primary key. The old table is a database of receipts where items can appear many times in any order.

I have put together the off-the-shelf components to do this, using a lookup transformation to see if the item is already in the new table. Problem is, because there's so much repetition in the old table I need to process the old table one row at a time. Batch processing is generating errors because the lookup doesn't detect duplicates within the buffer.

I tried setting the "DefaultBufferMaxRows" property of the task to 1, but that doesn't seem to have any effect.

To get the data from the old table, I'm using an OLE DB source. To get the data into the new table, I'm using the OLE DB Command transformation with parameters to execute an INSERT statement.

This is a job I have to do exactly once, so I don't care if I have to run it overnight. I'd rather have a simple, easy to understand but inefficient script so I understand what it's doing completely.

Any help on forcing SSIS to process one row at a time?

Lee Silverman
JackRabbit Sports

Could you use an Aggregate transform to eliminate the duplicates, or a GROUP BY in the source select?|||

Could you use an Aggregate transform to eliminate the duplicates, or a GROUP BY in the source select?

Unfortunately no. Items wwith the same unique identifier have often had important changes made to the descriptive fields over the course of the last two or three years. When the Lookup finds a unique identifier that is already in the table, the branch that handles that then goes on to check to see if the descriptive info has changed, and if so updates the data in the table. Likewise, on the side of the lookup where the unique identifier was not found, that branch needs to see handle the case where the new item shares an item lookup number with a previous item, and if so marks the previous item as expired.

The data in the source table is ordered sequentially, and the logic of the script requires that each line item be processed one at a time. It's going to be slow, but once it's done it'll be done.

Lee Silverman
JackRabbit Sports

|||Could you use a For Each Container with the ADO enumerator to loop through your recordset of tableA and then do your manipulations/lookups within that?|||You could use an OLE DB Command to do your inserts and updates, and disable caching on the lookups. That will force the lookups to requery the database for each row. I'm not sure that will work in your case, but it might be worth a try.|||

How does one disable caching on lookups? Do you have to check "enable memory restriction" but then not check "enable caching"?

In any event, I solved the problem by writing a script in T-SQL, and I took the opportunity to teach myself how to use a cursor to scroll through the original table one line at a time. It's running now.

Lee

|||

Lee Silverman wrote:

How does one disable caching on lookups? Do you have to check "enable memory restriction" but then not check "enable caching"?

That is it.

Processing of Table in a report, delayed based on input parameter

I have input parameters which are dates in my report. My problem is I
have to validate these parameters before I display the table in the
report. Currently I am handling this by using the "Visibility"
property of the table. But I wanted to know is there is any other way,
I can stop the processing of the table till I validate the input date.
Thank You.Your query parameter can be an expression instead of directly mapped to the
dates. Then use code behind reports to validate the dates. Set the date to a
know bogus date that returns no data.
To map to an expression go to data tab, click on the ..., parameters tab.
Pick expression instead of the report parameter.
Another vaiation of the above. Have hidden parameters. Set the value of the
parameter to an expression that references the visible date parameter (and
again use code behind report). Then map this hidden parameter to your query
parameter. This hidden parameter can also be used for visibility. Hide the
data (by setting to a date that returns no data then it would be empty
anyway). Then show a textbox with your comment on why the date is invalid.
The above should at least point you in the right direction. Some of this
will be a hack but you should be able to get something acceptable worked
out.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
For instance
"ricky" <G.RekhaDevi@.gmail.com> wrote in message
news:55dde3ac-e215-44c3-8a9b-e3f20987e0b8@.i72g2000hsd.googlegroups.com...
>I have input parameters which are dates in my report. My problem is I
> have to validate these parameters before I display the table in the
> report. Currently I am handling this by using the "Visibility"
> property of the table. But I wanted to know is there is any other way,
> I can stop the processing of the table till I validate the input date.
> Thank You.

Processing dataset as a whole, and not per row

Which component should be used to process dataset as a whole, and not on per row basis? I have need to process dataset conditionally (condition based on dataset), e.g. if a special row is present in dataset than dataset should be processed in a special way. Should I maybe use one Script Transformation to determine if dataset satisfies condition (and store that result into a variable), and then based on that condition (variable value) perform or not processing (using Conditional Split and Script Transformation)?

You could try to identify if the 'special row' exists through a sql statement in an execute sql task, then set a variable to '1' or '2' and then have precendent constraints to two different data flow tasks evaluated as expressions based on the value of the variable from the execute sql task. Hope that makes sense, I realize it isn't all that clear.

|||Yes, it makes sense, thanks. With that said, I have a new problem - have to find out how dataset/context is passed between different data flow tasks of a single control flow (using DataReader Source and Destination maybe?). (Did I mention I was a beginner...well I am)

Another problem I have to solve is to implement specific transformation. Within a dataset there are two distinct groups of rows - distinction is based on value of a single column. Transformation should for each row of one group, lookup matching row in other group. If matching row is found than based on its column values, column values of a row from first group should be updated. Otherwise, an additional row should be appended to the dataset with (almost all) column values just copied from first group row. How does one do something like that - looping with inner looping, and appending rows to a dataset?

|||

You can use RAW files to persist the data between data flow tasks. They are extremely fast. The issue with using the recordset is that you have to use a Script Source to process it in the second data flow (the DataReader source uses an ADO.NET connection to a database to retrieve data.)

On your second problem, you could look at using a conditional split to split the groups, then a Merge Join to join them back together based on the matching columns. For adding the additional rows, you'd need to use a script component. There are probably other ways to do this, that's just the first to come to mind.

|||I believe exporting data to files will present a security issue. Maybe I could do everything just on Data Flow - just use single script component to determine whether processing is needed and store it to variable, and then use Split to direct whole dataset either to be processed branch or to the other branch where no processing will be done. Question is how fast would this solution perform.

For second problem, I still don't see how splitting dataset would solve my problem - I don't know how could I reference second part of the dataset when going through first one. For each row in first dataset a matchig row has to be found in second dataset. If found, row in first dataset gets updated (using values from second group). If not found, new row in first group has to be appended. Maybe Lookup component could be used for this - default output when matching column is found, otherwise use error output.

In this short time I couldn't find the way to append a row using Script Transformation component. Could you please give me a reference to a book, web site, or something similar where this information can be found?
|||

Stevo Slavic wrote:

I believe exporting data to files will present a security issue.

Perhaps, but the files aren't in plain text. You can also use staging tables in a database instead of using files.|||

Stevo Slavic wrote:

In this short time I couldn't find the way to append a row using Script Transformation component. Could you please give me a reference to a book, web site, or something similar where this information can be found?

You need to use an async output on the script. See http://agilebi.com/cs/blogs/jwelch/archive/2007/09/14/dynamically-pivoting-rows-to-columns.aspx for an example of an async component. It's also documented in Books Online: http://msdn2.microsoft.com/zh-cn/library/ms136133.aspx

Processing dataset as a whole, and not per row

Which component should be used to process dataset as a whole, and not on per row basis? I have need to process dataset conditionally (condition based on dataset), e.g. if a special row is present in dataset than dataset should be processed in a special way. Should I maybe use one Script Transformation to determine if dataset satisfies condition (and store that result into a variable), and then based on that condition (variable value) perform or not processing (using Conditional Split and Script Transformation)?

You could try to identify if the 'special row' exists through a sql statement in an execute sql task, then set a variable to '1' or '2' and then have precendent constraints to two different data flow tasks evaluated as expressions based on the value of the variable from the execute sql task. Hope that makes sense, I realize it isn't all that clear.

|||Yes, it makes sense, thanks. With that said, I have a new problem - have to find out how dataset/context is passed between different data flow tasks of a single control flow (using DataReader Source and Destination maybe?). (Did I mention I was a beginner...well I am)

Another problem I have to solve is to implement specific transformation. Within a dataset there are two distinct groups of rows - distinction is based on value of a single column. Transformation should for each row of one group, lookup matching row in other group. If matching row is found than based on its column values, column values of a row from first group should be updated. Otherwise, an additional row should be appended to the dataset with (almost all) column values just copied from first group row. How does one do something like that - looping with inner looping, and appending rows to a dataset?

|||

You can use RAW files to persist the data between data flow tasks. They are extremely fast. The issue with using the recordset is that you have to use a Script Source to process it in the second data flow (the DataReader source uses an ADO.NET connection to a database to retrieve data.)

On your second problem, you could look at using a conditional split to split the groups, then a Merge Join to join them back together based on the matching columns. For adding the additional rows, you'd need to use a script component. There are probably other ways to do this, that's just the first to come to mind.

|||I believe exporting data to files will present a security issue. Maybe I could do everything just on Data Flow - just use single script component to determine whether processing is needed and store it to variable, and then use Split to direct whole dataset either to be processed branch or to the other branch where no processing will be done. Question is how fast would this solution perform.

For second problem, I still don't see how splitting dataset would solve my problem - I don't know how could I reference second part of the dataset when going through first one. For each row in first dataset a matchig row has to be found in second dataset. If found, row in first dataset gets updated (using values from second group). If not found, new row in first group has to be appended. Maybe Lookup component could be used for this - default output when matching column is found, otherwise use error output.

In this short time I couldn't find the way to append a row using Script Transformation component. Could you please give me a reference to a book, web site, or something similar where this information can be found?
|||

Stevo Slavic wrote:

I believe exporting data to files will present a security issue.

Perhaps, but the files aren't in plain text. You can also use staging tables in a database instead of using files.|||

Stevo Slavic wrote:

In this short time I couldn't find the way to append a row using Script Transformation component. Could you please give me a reference to a book, web site, or something similar where this information can be found?

You need to use an async output on the script. See http://agilebi.com/cs/blogs/jwelch/archive/2007/09/14/dynamically-pivoting-rows-to-columns.aspx for an example of an async component. It's also documented in Books Online: http://msdn2.microsoft.com/zh-cn/library/ms136133.aspx