What would the Sql syntax look like if I wanted to select +/- 10 days of a d
elivery date.
For instance; Table has Actual Delivery Date & Expected Delivery date, and u
sing the ABS Sql function, I want to select only the rows from the table tha
t were delivered with +/- 10 days.
And even if it's not the best way to do it, I would really like the info on
ABS.
Any ideas?
Thanx!Use DATEADD function like:
BETWEEN DATEADD ( d, -10, dt ) AND DATEADD ( d, 10, dt )
Anith|||I don't know your table structure or sample data, but here's a guess:
WHERE ABS(DATEDIFF(DAY, ActualDate, ExpectedDate)) <= 10
"Jude" <judes@.email.uophx.edu> wrote in message
news:%23NQBlSwQGHA.1868@.TK2MSFTNGP09.phx.gbl...
What would the Sql syntax look like if I wanted to select +/- 10 days of a
delivery date.
For instance; Table has Actual Delivery Date & Expected Delivery date, and
using the ABS Sql function, I want to select only the rows from the table
that were delivered with +/- 10 days.
And even if it's not the best way to do it, I would really like the info on
ABS.
Any ideas?
Thanx!|||Trust me I would, but someone taking a class asked me this question & I said
I had never used this function, but knew where to go to ask the experts!
Thanx!
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:u1RNgfwQGHA.4960@.TK2MSFTNGP12.phx.gbl...
> Use DATEADD function like:
> BETWEEN DATEADD ( d, -10, dt ) AND DATEADD ( d, 10, dt )
> --
> Anith
>|||Fantastic, Thanx so much Aaron! This is a favor for a friend who is taking
a class, and since I haven't used this function & would just use DateDiff
functions, I didn't have an answer. I knew the experts in here would
though!
Thanx again!!!!!
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:e%23zWkBxQGHA.1160@.TK2MSFTNGP09.phx.gbl...
>I don't know your table structure or sample data, but here's a guess:
> WHERE ABS(DATEDIFF(DAY, ActualDate, ExpectedDate)) <= 10
>
> "Jude" <judes@.email.uophx.edu> wrote in message
> news:%23NQBlSwQGHA.1868@.TK2MSFTNGP09.phx.gbl...
> What would the Sql syntax look like if I wanted to select +/- 10 days of a
> delivery date.
> For instance; Table has Actual Delivery Date & Expected Delivery date, and
> using the ABS Sql function, I want to select only the rows from the table
> that were delivered with +/- 10 days.
> And even if it's not the best way to do it, I would really like the info
> on ABS.
> Any ideas?
> Thanx!
>
>
Showing posts with label actual. Show all posts
Showing posts with label actual. Show all posts
Thursday, March 8, 2012
Sunday, February 19, 2012
About Purchasing MS SQL Server
I have never had to purchase the actual application along with licensing I
have just worked on and with it. This is my question. What would be the
best/cheapest license to get. I will be running only 1 database off of SQL
server with an existing web application that many people can use from a
website. I need to know which license I should order. The processor licens
e
seems more for web based but do i need to get that one because it is so
expensive and we will be running 1 maybe 3 at the most databases off of it.
Or else could i just order 1 CAL license and save alot of money. But along
with that 1 license would more than one person be able to use the web
application at a time?
If you need any more information about our web application or anythign else
please just ask and i will reply back with the answer.
Thanks in advance,
Paul"NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
>I have never had to purchase the actual application along with licensing I
> have just worked on and with it. This is my question. What would be the
> best/cheapest license to get. I will be running only 1 database off of
> SQL
> server with an existing web application that many people can use from a
> website. I need to know which license I should order. The processor
> license
> seems more for web based but do i need to get that one because it is so
> expensive and we will be running 1 maybe 3 at the most databases off of
> it.
> Or else could i just order 1 CAL license and save alot of money. But
> along
> with that 1 license would more than one person be able to use the web
> application at a time?
> If you need any more information about our web application or anythign
> else
> please just ask and i will reply back with the answer.
> Thanks in advance,
> Paul
http://www.microsoft.com/sql/howtobuy/default.asp
Rick Sawtell
MCT, MCSD, MCDBA|||Yeah i have looked throughout microsofts website but it does not tell you
exactly what you need. Like it says Processor License is for more web based
things - but we only need MS SQL for one website's web application because i
t
is a new division of our company with a already existing web application.
That is teh only thing we will be using MS SQL for. So again my question is
do i need teh Procesor license or is there a cheaper road to take.
Thanks
Paul
"Rick Sawtell" wrote:
> "NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in messa
ge
> news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
>
> http://www.microsoft.com/sql/howtobuy/default.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Yes i have been throughout the entire microsoft sql website, but it still
isnt too clear. My company just needs MS SQL Server for one web based
application for one site with one database. It is a new division of our
company and they have a pre-existing web application that needs MS SQL to ru
n
its database. We will not use MS SQL for any other site.
Now for which license would be most cost effective.
The processor license says it is for web based, but is very costly. So my
question again is if there is another road I can take? Such as purchasing 1
CAL license, like i mentioned before, or some other option.
Thanks again
Paul
"Rick Sawtell" wrote:
> "NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in messa
ge
> news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
>
> http://www.microsoft.com/sql/howtobuy/default.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||> exactly what you need. Like it says Processor License is for more web
based
> things - but we only need MS SQL for one website's web application because
it
> is a new division of our company with a already existing web application.
> That is teh only thing we will be using MS SQL for.
You will need to provide a much more specific description of your business
needs. "using MS SQL" is pretty vague and ambiguous. Will your web site be
connecting to this database in response to user requests on your web site?
Or is it not tied directly to web site usage?|||I do not know exactly what the web application does but i knwo it only uses
one user name and password to connect to the database. So there are not
multiple user names to access the database but there are multiple users that
will be using this webapplication at the same time. It has a login with use
r
name and password from a table in the database and then from there they have
there own personal things that only there user name and password can view.
So I guess the answer is yes our web site will be connecting to the database
in response to user requests on the website.
If there is any more information you need to know just please ask as this
isnt one of my specialties and never have had to deal with this before.
Thanks
Paul
"Aaron [SQL Server MVP]" wrote:
> based
> it
> You will need to provide a much more specific description of your business
> needs. "using MS SQL" is pretty vague and ambiguous. Will your web site
be
> connecting to this database in response to user requests on your web site?
> Or is it not tied directly to web site usage?
>
>|||> I do not know exactly what the web application does but i knwo it only
uses
> one user name and password to connect to the database.
Number of user names doesn't matter. Do you think I could get away with
purchasing one CAL and having everyone in the company just pretend they are
me? If you have anonymous access from a web site, and there could be 1 or
10 or 100 users connected to the database at any one time, you will need a
processor license, not a single CAL or 10 CALs or even 100 CALs.
Of course, I am not a licensing expert nor am I a lawyer. You're going to
be much better off if you contact a Microsoft licensing rep, describe them
in full detail your exact business usage, and they will tell you what you
will need.
If you don't care about being in compliance, then do what you want with
whatever justification you feel necessary, I guess <shrug>.|||Look, read about the multiplexing on the same site. If you can not count
and clearly identify each user specifically and license each individually,
then you MUST purchase per processor. Sorry.
However, you may want to look into MSDE or the new SQL Server 2005 Express
Edition. Either of these may be better for your needs; however, these are
for very light-weight systems.
Sincerely,
Anthony Thomas
"NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
news:325A872B-E6E6-47E7-B18E-0C77D5325BC3@.microsoft.com...
Yes i have been throughout the entire microsoft sql website, but it still
isnt too clear. My company just needs MS SQL Server for one web based
application for one site with one database. It is a new division of our
company and they have a pre-existing web application that needs MS SQL to
run
its database. We will not use MS SQL for any other site.
Now for which license would be most cost effective.
The processor license says it is for web based, but is very costly. So my
question again is if there is another road I can take? Such as purchasing 1
CAL license, like i mentioned before, or some other option.
Thanks again
Paul
"Rick Sawtell" wrote:
> "NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in
message
> news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
I[vbcol=seagreen]
the[vbcol=seagreen]
>
> http://www.microsoft.com/sql/howtobuy/default.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||"NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
news:325A872B-E6E6-47E7-B18E-0C77D5325BC3@.microsoft.com...
> Yes i have been throughout the entire microsoft sql website, but it still
> isnt too clear. My company just needs MS SQL Server for one web based
> application for one site with one database. It is a new division of our
> company and they have a pre-existing web application that needs MS SQL to
run
> its database. We will not use MS SQL for any other site.
> Now for which license would be most cost effective.
> The processor license says it is for web based, but is very costly. So my
> question again is if there is another road I can take? Such as purchasing
1
> CAL license, like i mentioned before, or some other option.
You can use 1 CAL if you can positively ensure that a SINGLE USER (as in
HUMAN BEING) is using the database.
With a website, this is pretty dang rare. It doesn't matter if the WEBSITE
appears as a single connection or a single user. If you have multiple
people accessing the website (or even technically I believe mulitple 'bots'
using the website) you either need a CAL for EACH person (and they have to
connect non-anonymously) or you need a Processor license to allow an number
of unlimited connections.
I am NOT a MS license expert in any way though, so your best bet is to check
with them. Last thing you want is MS coming in and doing an audit and
finding you're in the wrong.
> Thanks again
> Paul
> "Rick Sawtell" wrote:
have just worked on and with it. This is my question. What would be the
best/cheapest license to get. I will be running only 1 database off of SQL
server with an existing web application that many people can use from a
website. I need to know which license I should order. The processor licens
e
seems more for web based but do i need to get that one because it is so
expensive and we will be running 1 maybe 3 at the most databases off of it.
Or else could i just order 1 CAL license and save alot of money. But along
with that 1 license would more than one person be able to use the web
application at a time?
If you need any more information about our web application or anythign else
please just ask and i will reply back with the answer.
Thanks in advance,
Paul"NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
>I have never had to purchase the actual application along with licensing I
> have just worked on and with it. This is my question. What would be the
> best/cheapest license to get. I will be running only 1 database off of
> SQL
> server with an existing web application that many people can use from a
> website. I need to know which license I should order. The processor
> license
> seems more for web based but do i need to get that one because it is so
> expensive and we will be running 1 maybe 3 at the most databases off of
> it.
> Or else could i just order 1 CAL license and save alot of money. But
> along
> with that 1 license would more than one person be able to use the web
> application at a time?
> If you need any more information about our web application or anythign
> else
> please just ask and i will reply back with the answer.
> Thanks in advance,
> Paul
http://www.microsoft.com/sql/howtobuy/default.asp
Rick Sawtell
MCT, MCSD, MCDBA|||Yeah i have looked throughout microsofts website but it does not tell you
exactly what you need. Like it says Processor License is for more web based
things - but we only need MS SQL for one website's web application because i
t
is a new division of our company with a already existing web application.
That is teh only thing we will be using MS SQL for. So again my question is
do i need teh Procesor license or is there a cheaper road to take.
Thanks
Paul
"Rick Sawtell" wrote:
> "NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in messa
ge
> news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
>
> http://www.microsoft.com/sql/howtobuy/default.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Yes i have been throughout the entire microsoft sql website, but it still
isnt too clear. My company just needs MS SQL Server for one web based
application for one site with one database. It is a new division of our
company and they have a pre-existing web application that needs MS SQL to ru
n
its database. We will not use MS SQL for any other site.
Now for which license would be most cost effective.
The processor license says it is for web based, but is very costly. So my
question again is if there is another road I can take? Such as purchasing 1
CAL license, like i mentioned before, or some other option.
Thanks again
Paul
"Rick Sawtell" wrote:
> "NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in messa
ge
> news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
>
> http://www.microsoft.com/sql/howtobuy/default.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||> exactly what you need. Like it says Processor License is for more web
based
> things - but we only need MS SQL for one website's web application because
it
> is a new division of our company with a already existing web application.
> That is teh only thing we will be using MS SQL for.
You will need to provide a much more specific description of your business
needs. "using MS SQL" is pretty vague and ambiguous. Will your web site be
connecting to this database in response to user requests on your web site?
Or is it not tied directly to web site usage?|||I do not know exactly what the web application does but i knwo it only uses
one user name and password to connect to the database. So there are not
multiple user names to access the database but there are multiple users that
will be using this webapplication at the same time. It has a login with use
r
name and password from a table in the database and then from there they have
there own personal things that only there user name and password can view.
So I guess the answer is yes our web site will be connecting to the database
in response to user requests on the website.
If there is any more information you need to know just please ask as this
isnt one of my specialties and never have had to deal with this before.
Thanks
Paul
"Aaron [SQL Server MVP]" wrote:
> based
> it
> You will need to provide a much more specific description of your business
> needs. "using MS SQL" is pretty vague and ambiguous. Will your web site
be
> connecting to this database in response to user requests on your web site?
> Or is it not tied directly to web site usage?
>
>|||> I do not know exactly what the web application does but i knwo it only
uses
> one user name and password to connect to the database.
Number of user names doesn't matter. Do you think I could get away with
purchasing one CAL and having everyone in the company just pretend they are
me? If you have anonymous access from a web site, and there could be 1 or
10 or 100 users connected to the database at any one time, you will need a
processor license, not a single CAL or 10 CALs or even 100 CALs.
Of course, I am not a licensing expert nor am I a lawyer. You're going to
be much better off if you contact a Microsoft licensing rep, describe them
in full detail your exact business usage, and they will tell you what you
will need.
If you don't care about being in compliance, then do what you want with
whatever justification you feel necessary, I guess <shrug>.|||Look, read about the multiplexing on the same site. If you can not count
and clearly identify each user specifically and license each individually,
then you MUST purchase per processor. Sorry.
However, you may want to look into MSDE or the new SQL Server 2005 Express
Edition. Either of these may be better for your needs; however, these are
for very light-weight systems.
Sincerely,
Anthony Thomas
"NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
news:325A872B-E6E6-47E7-B18E-0C77D5325BC3@.microsoft.com...
Yes i have been throughout the entire microsoft sql website, but it still
isnt too clear. My company just needs MS SQL Server for one web based
application for one site with one database. It is a new division of our
company and they have a pre-existing web application that needs MS SQL to
run
its database. We will not use MS SQL for any other site.
Now for which license would be most cost effective.
The processor license says it is for web based, but is very costly. So my
question again is if there is another road I can take? Such as purchasing 1
CAL license, like i mentioned before, or some other option.
Thanks again
Paul
"Rick Sawtell" wrote:
> "NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in
message
> news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
I[vbcol=seagreen]
the[vbcol=seagreen]
>
> http://www.microsoft.com/sql/howtobuy/default.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||"NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
news:325A872B-E6E6-47E7-B18E-0C77D5325BC3@.microsoft.com...
> Yes i have been throughout the entire microsoft sql website, but it still
> isnt too clear. My company just needs MS SQL Server for one web based
> application for one site with one database. It is a new division of our
> company and they have a pre-existing web application that needs MS SQL to
run
> its database. We will not use MS SQL for any other site.
> Now for which license would be most cost effective.
> The processor license says it is for web based, but is very costly. So my
> question again is if there is another road I can take? Such as purchasing
1
> CAL license, like i mentioned before, or some other option.
You can use 1 CAL if you can positively ensure that a SINGLE USER (as in
HUMAN BEING) is using the database.
With a website, this is pretty dang rare. It doesn't matter if the WEBSITE
appears as a single connection or a single user. If you have multiple
people accessing the website (or even technically I believe mulitple 'bots'
using the website) you either need a CAL for EACH person (and they have to
connect non-anonymously) or you need a Processor license to allow an number
of unlimited connections.
I am NOT a MS license expert in any way though, so your best bet is to check
with them. Last thing you want is MS coming in and doing an audit and
finding you're in the wrong.
> Thanks again
> Paul
> "Rick Sawtell" wrote:
About Purchasing MS SQL Server
I have never had to purchase the actual application along with licensing I
have just worked on and with it. This is my question. What would be the
best/cheapest license to get. I will be running only 1 database off of SQL
server with an existing web application that many people can use from a
website. I need to know which license I should order. The processor license
seems more for web based but do i need to get that one because it is so
expensive and we will be running 1 maybe 3 at the most databases off of it.
Or else could i just order 1 CAL license and save alot of money. But along
with that 1 license would more than one person be able to use the web
application at a time?
If you need any more information about our web application or anythign else
please just ask and i will reply back with the answer.
Thanks in advance,
Paul
"NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
>I have never had to purchase the actual application along with licensing I
> have just worked on and with it. This is my question. What would be the
> best/cheapest license to get. I will be running only 1 database off of
> SQL
> server with an existing web application that many people can use from a
> website. I need to know which license I should order. The processor
> license
> seems more for web based but do i need to get that one because it is so
> expensive and we will be running 1 maybe 3 at the most databases off of
> it.
> Or else could i just order 1 CAL license and save alot of money. But
> along
> with that 1 license would more than one person be able to use the web
> application at a time?
> If you need any more information about our web application or anythign
> else
> please just ask and i will reply back with the answer.
> Thanks in advance,
> Paul
http://www.microsoft.com/sql/howtobuy/default.asp
Rick Sawtell
MCT, MCSD, MCDBA
|||Yeah i have looked throughout microsofts website but it does not tell you
exactly what you need. Like it says Processor License is for more web based
things - but we only need MS SQL for one website's web application because it
is a new division of our company with a already existing web application.
That is teh only thing we will be using MS SQL for. So again my question is
do i need teh Procesor license or is there a cheaper road to take.
Thanks
Paul
"Rick Sawtell" wrote:
> "NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
> news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
>
> http://www.microsoft.com/sql/howtobuy/default.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||Yes i have been throughout the entire microsoft sql website, but it still
isnt too clear. My company just needs MS SQL Server for one web based
application for one site with one database. It is a new division of our
company and they have a pre-existing web application that needs MS SQL to run
its database. We will not use MS SQL for any other site.
Now for which license would be most cost effective.
The processor license says it is for web based, but is very costly. So my
question again is if there is another road I can take? Such as purchasing 1
CAL license, like i mentioned before, or some other option.
Thanks again
Paul
"Rick Sawtell" wrote:
> "NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
> news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
>
> http://www.microsoft.com/sql/howtobuy/default.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||> exactly what you need. Like it says Processor License is for more web
based
> things - but we only need MS SQL for one website's web application because
it
> is a new division of our company with a already existing web application.
> That is teh only thing we will be using MS SQL for.
You will need to provide a much more specific description of your business
needs. "using MS SQL" is pretty vague and ambiguous. Will your web site be
connecting to this database in response to user requests on your web site?
Or is it not tied directly to web site usage?
|||I do not know exactly what the web application does but i knwo it only uses
one user name and password to connect to the database. So there are not
multiple user names to access the database but there are multiple users that
will be using this webapplication at the same time. It has a login with user
name and password from a table in the database and then from there they have
there own personal things that only there user name and password can view.
So I guess the answer is yes our web site will be connecting to the database
in response to user requests on the website.
If there is any more information you need to know just please ask as this
isnt one of my specialties and never have had to deal with this before.
Thanks
Paul
"Aaron [SQL Server MVP]" wrote:
> based
> it
> You will need to provide a much more specific description of your business
> needs. "using MS SQL" is pretty vague and ambiguous. Will your web site be
> connecting to this database in response to user requests on your web site?
> Or is it not tied directly to web site usage?
>
>
|||> I do not know exactly what the web application does but i knwo it only
uses
> one user name and password to connect to the database.
Number of user names doesn't matter. Do you think I could get away with
purchasing one CAL and having everyone in the company just pretend they are
me? If you have anonymous access from a web site, and there could be 1 or
10 or 100 users connected to the database at any one time, you will need a
processor license, not a single CAL or 10 CALs or even 100 CALs.
Of course, I am not a licensing expert nor am I a lawyer. You're going to
be much better off if you contact a Microsoft licensing rep, describe them
in full detail your exact business usage, and they will tell you what you
will need.
If you don't care about being in compliance, then do what you want with
whatever justification you feel necessary, I guess <shrug>.
|||Look, read about the multiplexing on the same site. If you can not count
and clearly identify each user specifically and license each individually,
then you MUST purchase per processor. Sorry.
However, you may want to look into MSDE or the new SQL Server 2005 Express
Edition. Either of these may be better for your needs; however, these are
for very light-weight systems.
Sincerely,
Anthony Thomas
"NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
news:325A872B-E6E6-47E7-B18E-0C77D5325BC3@.microsoft.com...
Yes i have been throughout the entire microsoft sql website, but it still
isnt too clear. My company just needs MS SQL Server for one web based
application for one site with one database. It is a new division of our
company and they have a pre-existing web application that needs MS SQL to
run
its database. We will not use MS SQL for any other site.
Now for which license would be most cost effective.
The processor license says it is for web based, but is very costly. So my
question again is if there is another road I can take? Such as purchasing 1
CAL license, like i mentioned before, or some other option.
Thanks again
Paul
"Rick Sawtell" wrote:
> "NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
> news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
I[vbcol=seagreen]
the
>
> http://www.microsoft.com/sql/howtobuy/default.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||"NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
news:325A872B-E6E6-47E7-B18E-0C77D5325BC3@.microsoft.com...
> Yes i have been throughout the entire microsoft sql website, but it still
> isnt too clear. My company just needs MS SQL Server for one web based
> application for one site with one database. It is a new division of our
> company and they have a pre-existing web application that needs MS SQL to
run
> its database. We will not use MS SQL for any other site.
> Now for which license would be most cost effective.
> The processor license says it is for web based, but is very costly. So my
> question again is if there is another road I can take? Such as purchasing
1
> CAL license, like i mentioned before, or some other option.
You can use 1 CAL if you can positively ensure that a SINGLE USER (as in
HUMAN BEING) is using the database.
With a website, this is pretty dang rare. It doesn't matter if the WEBSITE
appears as a single connection or a single user. If you have multiple
people accessing the website (or even technically I believe mulitple 'bots'
using the website) you either need a CAL for EACH person (and they have to
connect non-anonymously) or you need a Processor license to allow an number
of unlimited connections.
I am NOT a MS license expert in any way though, so your best bet is to check
with them. Last thing you want is MS coming in and doing an audit and
finding you're in the wrong.
> Thanks again
> Paul
> "Rick Sawtell" wrote:
have just worked on and with it. This is my question. What would be the
best/cheapest license to get. I will be running only 1 database off of SQL
server with an existing web application that many people can use from a
website. I need to know which license I should order. The processor license
seems more for web based but do i need to get that one because it is so
expensive and we will be running 1 maybe 3 at the most databases off of it.
Or else could i just order 1 CAL license and save alot of money. But along
with that 1 license would more than one person be able to use the web
application at a time?
If you need any more information about our web application or anythign else
please just ask and i will reply back with the answer.
Thanks in advance,
Paul
"NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
>I have never had to purchase the actual application along with licensing I
> have just worked on and with it. This is my question. What would be the
> best/cheapest license to get. I will be running only 1 database off of
> SQL
> server with an existing web application that many people can use from a
> website. I need to know which license I should order. The processor
> license
> seems more for web based but do i need to get that one because it is so
> expensive and we will be running 1 maybe 3 at the most databases off of
> it.
> Or else could i just order 1 CAL license and save alot of money. But
> along
> with that 1 license would more than one person be able to use the web
> application at a time?
> If you need any more information about our web application or anythign
> else
> please just ask and i will reply back with the answer.
> Thanks in advance,
> Paul
http://www.microsoft.com/sql/howtobuy/default.asp
Rick Sawtell
MCT, MCSD, MCDBA
|||Yeah i have looked throughout microsofts website but it does not tell you
exactly what you need. Like it says Processor License is for more web based
things - but we only need MS SQL for one website's web application because it
is a new division of our company with a already existing web application.
That is teh only thing we will be using MS SQL for. So again my question is
do i need teh Procesor license or is there a cheaper road to take.
Thanks
Paul
"Rick Sawtell" wrote:
> "NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
> news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
>
> http://www.microsoft.com/sql/howtobuy/default.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||Yes i have been throughout the entire microsoft sql website, but it still
isnt too clear. My company just needs MS SQL Server for one web based
application for one site with one database. It is a new division of our
company and they have a pre-existing web application that needs MS SQL to run
its database. We will not use MS SQL for any other site.
Now for which license would be most cost effective.
The processor license says it is for web based, but is very costly. So my
question again is if there is another road I can take? Such as purchasing 1
CAL license, like i mentioned before, or some other option.
Thanks again
Paul
"Rick Sawtell" wrote:
> "NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
> news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
>
> http://www.microsoft.com/sql/howtobuy/default.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||> exactly what you need. Like it says Processor License is for more web
based
> things - but we only need MS SQL for one website's web application because
it
> is a new division of our company with a already existing web application.
> That is teh only thing we will be using MS SQL for.
You will need to provide a much more specific description of your business
needs. "using MS SQL" is pretty vague and ambiguous. Will your web site be
connecting to this database in response to user requests on your web site?
Or is it not tied directly to web site usage?
|||I do not know exactly what the web application does but i knwo it only uses
one user name and password to connect to the database. So there are not
multiple user names to access the database but there are multiple users that
will be using this webapplication at the same time. It has a login with user
name and password from a table in the database and then from there they have
there own personal things that only there user name and password can view.
So I guess the answer is yes our web site will be connecting to the database
in response to user requests on the website.
If there is any more information you need to know just please ask as this
isnt one of my specialties and never have had to deal with this before.
Thanks
Paul
"Aaron [SQL Server MVP]" wrote:
> based
> it
> You will need to provide a much more specific description of your business
> needs. "using MS SQL" is pretty vague and ambiguous. Will your web site be
> connecting to this database in response to user requests on your web site?
> Or is it not tied directly to web site usage?
>
>
|||> I do not know exactly what the web application does but i knwo it only
uses
> one user name and password to connect to the database.
Number of user names doesn't matter. Do you think I could get away with
purchasing one CAL and having everyone in the company just pretend they are
me? If you have anonymous access from a web site, and there could be 1 or
10 or 100 users connected to the database at any one time, you will need a
processor license, not a single CAL or 10 CALs or even 100 CALs.
Of course, I am not a licensing expert nor am I a lawyer. You're going to
be much better off if you contact a Microsoft licensing rep, describe them
in full detail your exact business usage, and they will tell you what you
will need.
If you don't care about being in compliance, then do what you want with
whatever justification you feel necessary, I guess <shrug>.
|||Look, read about the multiplexing on the same site. If you can not count
and clearly identify each user specifically and license each individually,
then you MUST purchase per processor. Sorry.
However, you may want to look into MSDE or the new SQL Server 2005 Express
Edition. Either of these may be better for your needs; however, these are
for very light-weight systems.
Sincerely,
Anthony Thomas
"NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
news:325A872B-E6E6-47E7-B18E-0C77D5325BC3@.microsoft.com...
Yes i have been throughout the entire microsoft sql website, but it still
isnt too clear. My company just needs MS SQL Server for one web based
application for one site with one database. It is a new division of our
company and they have a pre-existing web application that needs MS SQL to
run
its database. We will not use MS SQL for any other site.
Now for which license would be most cost effective.
The processor license says it is for web based, but is very costly. So my
question again is if there is another road I can take? Such as purchasing 1
CAL license, like i mentioned before, or some other option.
Thanks again
Paul
"Rick Sawtell" wrote:
> "NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
> news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
I[vbcol=seagreen]
the
>
> http://www.microsoft.com/sql/howtobuy/default.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||"NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
news:325A872B-E6E6-47E7-B18E-0C77D5325BC3@.microsoft.com...
> Yes i have been throughout the entire microsoft sql website, but it still
> isnt too clear. My company just needs MS SQL Server for one web based
> application for one site with one database. It is a new division of our
> company and they have a pre-existing web application that needs MS SQL to
run
> its database. We will not use MS SQL for any other site.
> Now for which license would be most cost effective.
> The processor license says it is for web based, but is very costly. So my
> question again is if there is another road I can take? Such as purchasing
1
> CAL license, like i mentioned before, or some other option.
You can use 1 CAL if you can positively ensure that a SINGLE USER (as in
HUMAN BEING) is using the database.
With a website, this is pretty dang rare. It doesn't matter if the WEBSITE
appears as a single connection or a single user. If you have multiple
people accessing the website (or even technically I believe mulitple 'bots'
using the website) you either need a CAL for EACH person (and they have to
connect non-anonymously) or you need a Processor license to allow an number
of unlimited connections.
I am NOT a MS license expert in any way though, so your best bet is to check
with them. Last thing you want is MS coming in and doing an audit and
finding you're in the wrong.
> Thanks again
> Paul
> "Rick Sawtell" wrote:
About Purchasing MS SQL Server
I have never had to purchase the actual application along with licensing I
have just worked on and with it. This is my question. What would be the
best/cheapest license to get. I will be running only 1 database off of SQL
server with an existing web application that many people can use from a
website. I need to know which license I should order. The processor license
seems more for web based but do i need to get that one because it is so
expensive and we will be running 1 maybe 3 at the most databases off of it.
Or else could i just order 1 CAL license and save alot of money. But along
with that 1 license would more than one person be able to use the web
application at a time?
If you need any more information about our web application or anythign else
please just ask and i will reply back with the answer.
Thanks in advance,
Paul"NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
>I have never had to purchase the actual application along with licensing I
> have just worked on and with it. This is my question. What would be the
> best/cheapest license to get. I will be running only 1 database off of
> SQL
> server with an existing web application that many people can use from a
> website. I need to know which license I should order. The processor
> license
> seems more for web based but do i need to get that one because it is so
> expensive and we will be running 1 maybe 3 at the most databases off of
> it.
> Or else could i just order 1 CAL license and save alot of money. But
> along
> with that 1 license would more than one person be able to use the web
> application at a time?
> If you need any more information about our web application or anythign
> else
> please just ask and i will reply back with the answer.
> Thanks in advance,
> Paul
http://www.microsoft.com/sql/howtobuy/default.asp
Rick Sawtell
MCT, MCSD, MCDBA|||Yeah i have looked throughout microsofts website but it does not tell you
exactly what you need. Like it says Processor License is for more web based
things - but we only need MS SQL for one website's web application because it
is a new division of our company with a already existing web application.
That is teh only thing we will be using MS SQL for. So again my question is
do i need teh Procesor license or is there a cheaper road to take.
Thanks
Paul
"Rick Sawtell" wrote:
> "NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
> news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
> >I have never had to purchase the actual application along with licensing I
> > have just worked on and with it. This is my question. What would be the
> > best/cheapest license to get. I will be running only 1 database off of
> > SQL
> > server with an existing web application that many people can use from a
> > website. I need to know which license I should order. The processor
> > license
> > seems more for web based but do i need to get that one because it is so
> > expensive and we will be running 1 maybe 3 at the most databases off of
> > it.
> > Or else could i just order 1 CAL license and save alot of money. But
> > along
> > with that 1 license would more than one person be able to use the web
> > application at a time?
> >
> > If you need any more information about our web application or anythign
> > else
> > please just ask and i will reply back with the answer.
> > Thanks in advance,
> > Paul
>
> http://www.microsoft.com/sql/howtobuy/default.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Yes i have been throughout the entire microsoft sql website, but it still
isnt too clear. My company just needs MS SQL Server for one web based
application for one site with one database. It is a new division of our
company and they have a pre-existing web application that needs MS SQL to run
its database. We will not use MS SQL for any other site.
Now for which license would be most cost effective.
The processor license says it is for web based, but is very costly. So my
question again is if there is another road I can take? Such as purchasing 1
CAL license, like i mentioned before, or some other option.
Thanks again
Paul
"Rick Sawtell" wrote:
> "NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
> news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
> >I have never had to purchase the actual application along with licensing I
> > have just worked on and with it. This is my question. What would be the
> > best/cheapest license to get. I will be running only 1 database off of
> > SQL
> > server with an existing web application that many people can use from a
> > website. I need to know which license I should order. The processor
> > license
> > seems more for web based but do i need to get that one because it is so
> > expensive and we will be running 1 maybe 3 at the most databases off of
> > it.
> > Or else could i just order 1 CAL license and save alot of money. But
> > along
> > with that 1 license would more than one person be able to use the web
> > application at a time?
> >
> > If you need any more information about our web application or anythign
> > else
> > please just ask and i will reply back with the answer.
> > Thanks in advance,
> > Paul
>
> http://www.microsoft.com/sql/howtobuy/default.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||> exactly what you need. Like it says Processor License is for more web
based
> things - but we only need MS SQL for one website's web application because
it
> is a new division of our company with a already existing web application.
> That is teh only thing we will be using MS SQL for.
You will need to provide a much more specific description of your business
needs. "using MS SQL" is pretty vague and ambiguous. Will your web site be
connecting to this database in response to user requests on your web site?
Or is it not tied directly to web site usage?|||I do not know exactly what the web application does but i knwo it only uses
one user name and password to connect to the database. So there are not
multiple user names to access the database but there are multiple users that
will be using this webapplication at the same time. It has a login with user
name and password from a table in the database and then from there they have
there own personal things that only there user name and password can view.
So I guess the answer is yes our web site will be connecting to the database
in response to user requests on the website.
If there is any more information you need to know just please ask as this
isnt one of my specialties and never have had to deal with this before.
Thanks
Paul
"Aaron [SQL Server MVP]" wrote:
> > exactly what you need. Like it says Processor License is for more web
> based
> > things - but we only need MS SQL for one website's web application because
> it
> > is a new division of our company with a already existing web application.
> > That is teh only thing we will be using MS SQL for.
> You will need to provide a much more specific description of your business
> needs. "using MS SQL" is pretty vague and ambiguous. Will your web site be
> connecting to this database in response to user requests on your web site?
> Or is it not tied directly to web site usage?
>
>|||> I do not know exactly what the web application does but i knwo it only
uses
> one user name and password to connect to the database.
Number of user names doesn't matter. Do you think I could get away with
purchasing one CAL and having everyone in the company just pretend they are
me? If you have anonymous access from a web site, and there could be 1 or
10 or 100 users connected to the database at any one time, you will need a
processor license, not a single CAL or 10 CALs or even 100 CALs.
Of course, I am not a licensing expert nor am I a lawyer. You're going to
be much better off if you contact a Microsoft licensing rep, describe them
in full detail your exact business usage, and they will tell you what you
will need.
If you don't care about being in compliance, then do what you want with
whatever justification you feel necessary, I guess <shrug>.|||Look, read about the multiplexing on the same site. If you can not count
and clearly identify each user specifically and license each individually,
then you MUST purchase per processor. Sorry.
However, you may want to look into MSDE or the new SQL Server 2005 Express
Edition. Either of these may be better for your needs; however, these are
for very light-weight systems.
Sincerely,
Anthony Thomas
"NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
news:325A872B-E6E6-47E7-B18E-0C77D5325BC3@.microsoft.com...
Yes i have been throughout the entire microsoft sql website, but it still
isnt too clear. My company just needs MS SQL Server for one web based
application for one site with one database. It is a new division of our
company and they have a pre-existing web application that needs MS SQL to
run
its database. We will not use MS SQL for any other site.
Now for which license would be most cost effective.
The processor license says it is for web based, but is very costly. So my
question again is if there is another road I can take? Such as purchasing 1
CAL license, like i mentioned before, or some other option.
Thanks again
Paul
"Rick Sawtell" wrote:
> "NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in
message
> news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
> >I have never had to purchase the actual application along with licensing
I
> > have just worked on and with it. This is my question. What would be
the
> > best/cheapest license to get. I will be running only 1 database off of
> > SQL
> > server with an existing web application that many people can use from a
> > website. I need to know which license I should order. The processor
> > license
> > seems more for web based but do i need to get that one because it is so
> > expensive and we will be running 1 maybe 3 at the most databases off of
> > it.
> > Or else could i just order 1 CAL license and save alot of money. But
> > along
> > with that 1 license would more than one person be able to use the web
> > application at a time?
> >
> > If you need any more information about our web application or anythign
> > else
> > please just ask and i will reply back with the answer.
> > Thanks in advance,
> > Paul
>
> http://www.microsoft.com/sql/howtobuy/default.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||"NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
news:325A872B-E6E6-47E7-B18E-0C77D5325BC3@.microsoft.com...
> Yes i have been throughout the entire microsoft sql website, but it still
> isnt too clear. My company just needs MS SQL Server for one web based
> application for one site with one database. It is a new division of our
> company and they have a pre-existing web application that needs MS SQL to
run
> its database. We will not use MS SQL for any other site.
> Now for which license would be most cost effective.
> The processor license says it is for web based, but is very costly. So my
> question again is if there is another road I can take? Such as purchasing
1
> CAL license, like i mentioned before, or some other option.
You can use 1 CAL if you can positively ensure that a SINGLE USER (as in
HUMAN BEING) is using the database.
With a website, this is pretty dang rare. It doesn't matter if the WEBSITE
appears as a single connection or a single user. If you have multiple
people accessing the website (or even technically I believe mulitple 'bots'
using the website) you either need a CAL for EACH person (and they have to
connect non-anonymously) or you need a Processor license to allow an number
of unlimited connections.
I am NOT a MS license expert in any way though, so your best bet is to check
with them. Last thing you want is MS coming in and doing an audit and
finding you're in the wrong.
> Thanks again
> Paul
> "Rick Sawtell" wrote:
have just worked on and with it. This is my question. What would be the
best/cheapest license to get. I will be running only 1 database off of SQL
server with an existing web application that many people can use from a
website. I need to know which license I should order. The processor license
seems more for web based but do i need to get that one because it is so
expensive and we will be running 1 maybe 3 at the most databases off of it.
Or else could i just order 1 CAL license and save alot of money. But along
with that 1 license would more than one person be able to use the web
application at a time?
If you need any more information about our web application or anythign else
please just ask and i will reply back with the answer.
Thanks in advance,
Paul"NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
>I have never had to purchase the actual application along with licensing I
> have just worked on and with it. This is my question. What would be the
> best/cheapest license to get. I will be running only 1 database off of
> SQL
> server with an existing web application that many people can use from a
> website. I need to know which license I should order. The processor
> license
> seems more for web based but do i need to get that one because it is so
> expensive and we will be running 1 maybe 3 at the most databases off of
> it.
> Or else could i just order 1 CAL license and save alot of money. But
> along
> with that 1 license would more than one person be able to use the web
> application at a time?
> If you need any more information about our web application or anythign
> else
> please just ask and i will reply back with the answer.
> Thanks in advance,
> Paul
http://www.microsoft.com/sql/howtobuy/default.asp
Rick Sawtell
MCT, MCSD, MCDBA|||Yeah i have looked throughout microsofts website but it does not tell you
exactly what you need. Like it says Processor License is for more web based
things - but we only need MS SQL for one website's web application because it
is a new division of our company with a already existing web application.
That is teh only thing we will be using MS SQL for. So again my question is
do i need teh Procesor license or is there a cheaper road to take.
Thanks
Paul
"Rick Sawtell" wrote:
> "NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
> news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
> >I have never had to purchase the actual application along with licensing I
> > have just worked on and with it. This is my question. What would be the
> > best/cheapest license to get. I will be running only 1 database off of
> > SQL
> > server with an existing web application that many people can use from a
> > website. I need to know which license I should order. The processor
> > license
> > seems more for web based but do i need to get that one because it is so
> > expensive and we will be running 1 maybe 3 at the most databases off of
> > it.
> > Or else could i just order 1 CAL license and save alot of money. But
> > along
> > with that 1 license would more than one person be able to use the web
> > application at a time?
> >
> > If you need any more information about our web application or anythign
> > else
> > please just ask and i will reply back with the answer.
> > Thanks in advance,
> > Paul
>
> http://www.microsoft.com/sql/howtobuy/default.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Yes i have been throughout the entire microsoft sql website, but it still
isnt too clear. My company just needs MS SQL Server for one web based
application for one site with one database. It is a new division of our
company and they have a pre-existing web application that needs MS SQL to run
its database. We will not use MS SQL for any other site.
Now for which license would be most cost effective.
The processor license says it is for web based, but is very costly. So my
question again is if there is another road I can take? Such as purchasing 1
CAL license, like i mentioned before, or some other option.
Thanks again
Paul
"Rick Sawtell" wrote:
> "NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
> news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
> >I have never had to purchase the actual application along with licensing I
> > have just worked on and with it. This is my question. What would be the
> > best/cheapest license to get. I will be running only 1 database off of
> > SQL
> > server with an existing web application that many people can use from a
> > website. I need to know which license I should order. The processor
> > license
> > seems more for web based but do i need to get that one because it is so
> > expensive and we will be running 1 maybe 3 at the most databases off of
> > it.
> > Or else could i just order 1 CAL license and save alot of money. But
> > along
> > with that 1 license would more than one person be able to use the web
> > application at a time?
> >
> > If you need any more information about our web application or anythign
> > else
> > please just ask and i will reply back with the answer.
> > Thanks in advance,
> > Paul
>
> http://www.microsoft.com/sql/howtobuy/default.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||> exactly what you need. Like it says Processor License is for more web
based
> things - but we only need MS SQL for one website's web application because
it
> is a new division of our company with a already existing web application.
> That is teh only thing we will be using MS SQL for.
You will need to provide a much more specific description of your business
needs. "using MS SQL" is pretty vague and ambiguous. Will your web site be
connecting to this database in response to user requests on your web site?
Or is it not tied directly to web site usage?|||I do not know exactly what the web application does but i knwo it only uses
one user name and password to connect to the database. So there are not
multiple user names to access the database but there are multiple users that
will be using this webapplication at the same time. It has a login with user
name and password from a table in the database and then from there they have
there own personal things that only there user name and password can view.
So I guess the answer is yes our web site will be connecting to the database
in response to user requests on the website.
If there is any more information you need to know just please ask as this
isnt one of my specialties and never have had to deal with this before.
Thanks
Paul
"Aaron [SQL Server MVP]" wrote:
> > exactly what you need. Like it says Processor License is for more web
> based
> > things - but we only need MS SQL for one website's web application because
> it
> > is a new division of our company with a already existing web application.
> > That is teh only thing we will be using MS SQL for.
> You will need to provide a much more specific description of your business
> needs. "using MS SQL" is pretty vague and ambiguous. Will your web site be
> connecting to this database in response to user requests on your web site?
> Or is it not tied directly to web site usage?
>
>|||> I do not know exactly what the web application does but i knwo it only
uses
> one user name and password to connect to the database.
Number of user names doesn't matter. Do you think I could get away with
purchasing one CAL and having everyone in the company just pretend they are
me? If you have anonymous access from a web site, and there could be 1 or
10 or 100 users connected to the database at any one time, you will need a
processor license, not a single CAL or 10 CALs or even 100 CALs.
Of course, I am not a licensing expert nor am I a lawyer. You're going to
be much better off if you contact a Microsoft licensing rep, describe them
in full detail your exact business usage, and they will tell you what you
will need.
If you don't care about being in compliance, then do what you want with
whatever justification you feel necessary, I guess <shrug>.|||Look, read about the multiplexing on the same site. If you can not count
and clearly identify each user specifically and license each individually,
then you MUST purchase per processor. Sorry.
However, you may want to look into MSDE or the new SQL Server 2005 Express
Edition. Either of these may be better for your needs; however, these are
for very light-weight systems.
Sincerely,
Anthony Thomas
"NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
news:325A872B-E6E6-47E7-B18E-0C77D5325BC3@.microsoft.com...
Yes i have been throughout the entire microsoft sql website, but it still
isnt too clear. My company just needs MS SQL Server for one web based
application for one site with one database. It is a new division of our
company and they have a pre-existing web application that needs MS SQL to
run
its database. We will not use MS SQL for any other site.
Now for which license would be most cost effective.
The processor license says it is for web based, but is very costly. So my
question again is if there is another road I can take? Such as purchasing 1
CAL license, like i mentioned before, or some other option.
Thanks again
Paul
"Rick Sawtell" wrote:
> "NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in
message
> news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
> >I have never had to purchase the actual application along with licensing
I
> > have just worked on and with it. This is my question. What would be
the
> > best/cheapest license to get. I will be running only 1 database off of
> > SQL
> > server with an existing web application that many people can use from a
> > website. I need to know which license I should order. The processor
> > license
> > seems more for web based but do i need to get that one because it is so
> > expensive and we will be running 1 maybe 3 at the most databases off of
> > it.
> > Or else could i just order 1 CAL license and save alot of money. But
> > along
> > with that 1 license would more than one person be able to use the web
> > application at a time?
> >
> > If you need any more information about our web application or anythign
> > else
> > please just ask and i will reply back with the answer.
> > Thanks in advance,
> > Paul
>
> http://www.microsoft.com/sql/howtobuy/default.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||"NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
news:325A872B-E6E6-47E7-B18E-0C77D5325BC3@.microsoft.com...
> Yes i have been throughout the entire microsoft sql website, but it still
> isnt too clear. My company just needs MS SQL Server for one web based
> application for one site with one database. It is a new division of our
> company and they have a pre-existing web application that needs MS SQL to
run
> its database. We will not use MS SQL for any other site.
> Now for which license would be most cost effective.
> The processor license says it is for web based, but is very costly. So my
> question again is if there is another road I can take? Such as purchasing
1
> CAL license, like i mentioned before, or some other option.
You can use 1 CAL if you can positively ensure that a SINGLE USER (as in
HUMAN BEING) is using the database.
With a website, this is pretty dang rare. It doesn't matter if the WEBSITE
appears as a single connection or a single user. If you have multiple
people accessing the website (or even technically I believe mulitple 'bots'
using the website) you either need a CAL for EACH person (and they have to
connect non-anonymously) or you need a Processor license to allow an number
of unlimited connections.
I am NOT a MS license expert in any way though, so your best bet is to check
with them. Last thing you want is MS coming in and doing an audit and
finding you're in the wrong.
> Thanks again
> Paul
> "Rick Sawtell" wrote:
Monday, February 13, 2012
About Hypothetical Indexes
Dear all,
What is the best way to deal with Hypothetical Indexes?
Do we have to delete them after sometime or create the actual indexes to
gain performance?
Regards
KhurramHypothetical indexes should be removed. They are only supposed to exist
temporarily when running ITW. MS has published a script to remove them
(not tested by me):
http://support.microsoft.com/kb/q293177
If in doubt about what indexes to create then you can try running the
Tuning Wizard again. ITW is only as good as the data you feed it and it
won't always be right. Use it as a guide only.
David Portas
SQL Server MVP
--
What is the best way to deal with Hypothetical Indexes?
Do we have to delete them after sometime or create the actual indexes to
gain performance?
Regards
KhurramHypothetical indexes should be removed. They are only supposed to exist
temporarily when running ITW. MS has published a script to remove them
(not tested by me):
http://support.microsoft.com/kb/q293177
If in doubt about what indexes to create then you can try running the
Tuning Wizard again. ITW is only as good as the data you feed it and it
won't always be right. Use it as a guide only.
David Portas
SQL Server MVP
--
About Hypothetical Indexes
Dear all,
What is the best way to deal with Hypothetical Indexes?
Do we have to delete them after sometime or create the actual indexes to
gain performance?
Regards
Khurram
Hypothetical indexes should be removed. They are only supposed to exist
temporarily when running ITW. MS has published a script to remove them
(not tested by me):
http://support.microsoft.com/kb/q293177
If in doubt about what indexes to create then you can try running the
Tuning Wizard again. ITW is only as good as the data you feed it and it
won't always be right. Use it as a guide only.
David Portas
SQL Server MVP
What is the best way to deal with Hypothetical Indexes?
Do we have to delete them after sometime or create the actual indexes to
gain performance?
Regards
Khurram
Hypothetical indexes should be removed. They are only supposed to exist
temporarily when running ITW. MS has published a script to remove them
(not tested by me):
http://support.microsoft.com/kb/q293177
If in doubt about what indexes to create then you can try running the
Tuning Wizard again. ITW is only as good as the data you feed it and it
won't always be right. Use it as a guide only.
David Portas
SQL Server MVP
About Hypothetical Indexes
Dear all,
What is the best way to deal with Hypothetical Indexes?
Do we have to delete them after sometime or create the actual indexes to
gain performance?
Regards
KhurramHypothetical indexes should be removed. They are only supposed to exist
temporarily when running ITW. MS has published a script to remove them
(not tested by me):
http://support.microsoft.com/kb/q293177
If in doubt about what indexes to create then you can try running the
Tuning Wizard again. ITW is only as good as the data you feed it and it
won't always be right. Use it as a guide only.
--
David Portas
SQL Server MVP
--
What is the best way to deal with Hypothetical Indexes?
Do we have to delete them after sometime or create the actual indexes to
gain performance?
Regards
KhurramHypothetical indexes should be removed. They are only supposed to exist
temporarily when running ITW. MS has published a script to remove them
(not tested by me):
http://support.microsoft.com/kb/q293177
If in doubt about what indexes to create then you can try running the
Tuning Wizard again. ITW is only as good as the data you feed it and it
won't always be right. Use it as a guide only.
--
David Portas
SQL Server MVP
--
Subscribe to:
Posts (Atom)