hi all..
how will i fetch duplicate rows in a table i want the count also
eg in my table if the same company name exist morethan once i want to fetch it
thnks in advance
Jagduplicate rows is not the same thing as multiple rows with the same value in a particular column
presumably if your table has a primary key, you will never have a duplicate row
for your question about company names, try this --select companyname
, count(*) as rows
from daTable
group by companyname
having count(*) > 1|||u r right
its not duplicate its multiple nd thnks for ur querysql
Showing posts with label company. Show all posts
Showing posts with label company. Show all posts
Tuesday, March 27, 2012
Wednesday, March 21, 2012
Dundas Charts for RS 2000
Hi all,
maybe this is the wrong forum or company to post, but I'm looking for an answer, which I can't find at Dundas' Website.
Is there a Version of Dundas Charts for Reporting Services 2000? All I find is the Version for 2005...
And if there is such a version, are there differences concerning the possibility of usinig 2 Y-axis?
One more thing. What would be the arguments for using 2005 instead of 2000?
Replies are very much appreciated! Thanks in advance!
ME
This link should provide an overview on a few the new features in RS 2005 compared to the previous version: http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx
The integration of third party components (e.g. as used by the Dundas controls in RS 2005) requires the new CustomReportItem feature specifically added in RS 2005.
-- Robert
|||Have you looked into Chart FX at http://www.softwarefx.com/SfxSqlProducts/cfxReportingServices/
From their website:
"Chart FX for Reporting Services leverages the charting features from the award winning Chart FX charting engine. Plus it's just as easy to add this powerful technology to your reporting projects.
Here are some features.
Ease of Use & Integration
? Chart Wizard
? Data Wizard
? Property Grid
? Resource Center
? Legends "
Good luck.
Friday, March 9, 2012
Dual Processor Licensing
I intend to run SQL 2k on a dual processor server, my company wish however
to be very economic with licenses and i'd like to know if you run SQL 2k or
2005 for that matter, is it possible from inside SQL to set the application
to only run on one of the processors?
I know this is a bit of a dunb question and there are some very smart
answers that could be said, but i just need to ask the question, so i can go
back to company people and tell them they are being very tight!!
And get them to buy another enterprise server processor licence.
RgdsFrom the SQL Server licensing FAQ
(http://www.microsoft.com/sql/howtobuy/faq.mspx)
<Excerpt>
Do I have to acquire licenses for all of the processors in a server?
A. You have to acquire licenses only for processors that are accessible to
any copy of the operating system upon which SQL Server 2005 is installed. In
a virtualized environment, processor licenses are required for every
processor that is accessed by a virtual machine. Please see the
virtualization licensing brief and virtualization white paper for more
information on how to license under a virtualized environment.
</Excerpt>
The same applies to SQL 2000. Although you can set SQL Server processor
affinity to restrict processor utilization, this does not reduce the number
of licenses required.
Hope this helps.
Dan Guzman
SQL Server MVP
"Stu" <lbwer@.blah.com> wrote in message
news:OxhPN5VtGHA.3552@.TK2MSFTNGP03.phx.gbl...
>I intend to run SQL 2k on a dual processor server, my company wish however
>to be very economic with licenses and i'd like to know if you run SQL 2k or
>2005 for that matter, is it possible from inside SQL to set the application
>to only run on one of the processors?
> I know this is a bit of a dunb question and there are some very smart
> answers that could be said, but i just need to ask the question, so i can
> go back to company people and tell them they are being very tight!!
> And get them to buy another enterprise server processor licence.
> Rgds
>|||"Stu" <lbwer@.blah.com> wrote in message
news:OxhPN5VtGHA.3552@.TK2MSFTNGP03.phx.gbl...
>I intend to run SQL 2k on a dual processor server, my company wish however
>to be very economic with licenses and i'd like to know if you run SQL 2k or
>2005 for that matter, is it possible from inside SQL to set the application
>to only run on one of the processors?
>
Yes. You can set SQL Server's CPU Affinity mask to have SQL run on a subset
of the processors. However this has no affect on licensing.
affinity mask Option
http://msdn2.microsoft.com/en-us/library/ms187104.aspx
> I know this is a bit of a dunb question and there are some very smart
> answers that could be said, but i just need to ask the question, so i can
> go back to company people and tell them they are being very tight!!
> And get them to buy another enterprise server processor licence.
>
SQL Sever must be licensed on all processors that the Windows instance can
see. So unless you can turn off one of the CPU's in the BIOS, or you
install SQL Server on a Virtual Server that can only "see" one CPU, you must
license both processors.
SQL Server Pricing and Licensing
http://www.microsoft.com/sql/howtob...rlicensing.mspx
David|||Meaning I guess that because the application is installed on a dual
processor box, it will need 2 licences no matter now many are being
utilised?
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:%234SpDIWtGHA.1512@.TK2MSFTNGP03.phx.gbl...
> "Stu" <lbwer@.blah.com> wrote in message
> news:OxhPN5VtGHA.3552@.TK2MSFTNGP03.phx.gbl...
> Yes. You can set SQL Server's CPU Affinity mask to have SQL run on a
> subset of the processors. However this has no affect on licensing.
> affinity mask Option
> http://msdn2.microsoft.com/en-us/library/ms187104.aspx
>
> SQL Sever must be licensed on all processors that the Windows instance can
> see. So unless you can turn off one of the CPU's in the BIOS, or you
> install SQL Server on a Virtual Server that can only "see" one CPU, you
> must license both processors.
> SQL Server Pricing and Licensing
> http://www.microsoft.com/sql/howtob...rlicensing.mspx
> David
>|||"Stu" <lbwer@.blah.com> wrote in message
news:e2XEVNWtGHA.4140@.TK2MSFTNGP03.phx.gbl...
> Meaning I guess that because the application is installed on a dual
> processor box, it will need 2 licences no matter now many are being
> utilised?
Yes. Of course for licensing you count "sockets" not "cores".
David|||For SQL 2000, it is necessary to license for each CPU in the computer -even
if they are not used by SQL Server.
However, it SQL 2005, if you used VM Ware (or MS Virtual Server) to create
totally separate environments, then you can license for only the number of
CPU's that are used by SQL Server in that environment.
That could be cost effective for you.
See:
http://download.microsoft.com/downl...censingv1.1.doc
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Stu" <lbwer@.blah.com> wrote in message
news:e2XEVNWtGHA.4140@.TK2MSFTNGP03.phx.gbl...
> Meaning I guess that because the application is installed on a dual
> processor box, it will need 2 licences no matter now many are being
> utilised?
> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
> message news:%234SpDIWtGHA.1512@.TK2MSFTNGP03.phx.gbl...
>
to be very economic with licenses and i'd like to know if you run SQL 2k or
2005 for that matter, is it possible from inside SQL to set the application
to only run on one of the processors?
I know this is a bit of a dunb question and there are some very smart
answers that could be said, but i just need to ask the question, so i can go
back to company people and tell them they are being very tight!!
And get them to buy another enterprise server processor licence.
RgdsFrom the SQL Server licensing FAQ
(http://www.microsoft.com/sql/howtobuy/faq.mspx)
<Excerpt>
Do I have to acquire licenses for all of the processors in a server?
A. You have to acquire licenses only for processors that are accessible to
any copy of the operating system upon which SQL Server 2005 is installed. In
a virtualized environment, processor licenses are required for every
processor that is accessed by a virtual machine. Please see the
virtualization licensing brief and virtualization white paper for more
information on how to license under a virtualized environment.
</Excerpt>
The same applies to SQL 2000. Although you can set SQL Server processor
affinity to restrict processor utilization, this does not reduce the number
of licenses required.
Hope this helps.
Dan Guzman
SQL Server MVP
"Stu" <lbwer@.blah.com> wrote in message
news:OxhPN5VtGHA.3552@.TK2MSFTNGP03.phx.gbl...
>I intend to run SQL 2k on a dual processor server, my company wish however
>to be very economic with licenses and i'd like to know if you run SQL 2k or
>2005 for that matter, is it possible from inside SQL to set the application
>to only run on one of the processors?
> I know this is a bit of a dunb question and there are some very smart
> answers that could be said, but i just need to ask the question, so i can
> go back to company people and tell them they are being very tight!!
> And get them to buy another enterprise server processor licence.
> Rgds
>|||"Stu" <lbwer@.blah.com> wrote in message
news:OxhPN5VtGHA.3552@.TK2MSFTNGP03.phx.gbl...
>I intend to run SQL 2k on a dual processor server, my company wish however
>to be very economic with licenses and i'd like to know if you run SQL 2k or
>2005 for that matter, is it possible from inside SQL to set the application
>to only run on one of the processors?
>
Yes. You can set SQL Server's CPU Affinity mask to have SQL run on a subset
of the processors. However this has no affect on licensing.
affinity mask Option
http://msdn2.microsoft.com/en-us/library/ms187104.aspx
> I know this is a bit of a dunb question and there are some very smart
> answers that could be said, but i just need to ask the question, so i can
> go back to company people and tell them they are being very tight!!
> And get them to buy another enterprise server processor licence.
>
SQL Sever must be licensed on all processors that the Windows instance can
see. So unless you can turn off one of the CPU's in the BIOS, or you
install SQL Server on a Virtual Server that can only "see" one CPU, you must
license both processors.
SQL Server Pricing and Licensing
http://www.microsoft.com/sql/howtob...rlicensing.mspx
David|||Meaning I guess that because the application is installed on a dual
processor box, it will need 2 licences no matter now many are being
utilised?
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:%234SpDIWtGHA.1512@.TK2MSFTNGP03.phx.gbl...
> "Stu" <lbwer@.blah.com> wrote in message
> news:OxhPN5VtGHA.3552@.TK2MSFTNGP03.phx.gbl...
> Yes. You can set SQL Server's CPU Affinity mask to have SQL run on a
> subset of the processors. However this has no affect on licensing.
> affinity mask Option
> http://msdn2.microsoft.com/en-us/library/ms187104.aspx
>
> SQL Sever must be licensed on all processors that the Windows instance can
> see. So unless you can turn off one of the CPU's in the BIOS, or you
> install SQL Server on a Virtual Server that can only "see" one CPU, you
> must license both processors.
> SQL Server Pricing and Licensing
> http://www.microsoft.com/sql/howtob...rlicensing.mspx
> David
>|||"Stu" <lbwer@.blah.com> wrote in message
news:e2XEVNWtGHA.4140@.TK2MSFTNGP03.phx.gbl...
> Meaning I guess that because the application is installed on a dual
> processor box, it will need 2 licences no matter now many are being
> utilised?
Yes. Of course for licensing you count "sockets" not "cores".
David|||For SQL 2000, it is necessary to license for each CPU in the computer -even
if they are not used by SQL Server.
However, it SQL 2005, if you used VM Ware (or MS Virtual Server) to create
totally separate environments, then you can license for only the number of
CPU's that are used by SQL Server in that environment.
That could be cost effective for you.
See:
http://download.microsoft.com/downl...censingv1.1.doc
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Stu" <lbwer@.blah.com> wrote in message
news:e2XEVNWtGHA.4140@.TK2MSFTNGP03.phx.gbl...
> Meaning I guess that because the application is installed on a dual
> processor box, it will need 2 licences no matter now many are being
> utilised?
> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
> message news:%234SpDIWtGHA.1512@.TK2MSFTNGP03.phx.gbl...
>
Dual Processor Licensing
I intend to run SQL 2k on a dual processor server, my company wish however
to be very economic with licenses and i'd like to know if you run SQL 2k or
2005 for that matter, is it possible from inside SQL to set the application
to only run on one of the processors?
I know this is a bit of a dunb question and there are some very smart
answers that could be said, but i just need to ask the question, so i can go
back to company people and tell them they are being very tight!!
And get them to buy another enterprise server processor licence.
RgdsFrom the SQL Server licensing FAQ
(http://www.microsoft.com/sql/howtobuy/faq.mspx)
<Excerpt>
Do I have to acquire licenses for all of the processors in a server?
A. You have to acquire licenses only for processors that are accessible to
any copy of the operating system upon which SQL Server 2005 is installed. In
a virtualized environment, processor licenses are required for every
processor that is accessed by a virtual machine. Please see the
virtualization licensing brief and virtualization white paper for more
information on how to license under a virtualized environment.
</Excerpt>
The same applies to SQL 2000. Although you can set SQL Server processor
affinity to restrict processor utilization, this does not reduce the number
of licenses required.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Stu" <lbwer@.blah.com> wrote in message
news:OxhPN5VtGHA.3552@.TK2MSFTNGP03.phx.gbl...
>I intend to run SQL 2k on a dual processor server, my company wish however
>to be very economic with licenses and i'd like to know if you run SQL 2k or
>2005 for that matter, is it possible from inside SQL to set the application
>to only run on one of the processors?
> I know this is a bit of a dunb question and there are some very smart
> answers that could be said, but i just need to ask the question, so i can
> go back to company people and tell them they are being very tight!!
> And get them to buy another enterprise server processor licence.
> Rgds
>|||"Stu" <lbwer@.blah.com> wrote in message
news:OxhPN5VtGHA.3552@.TK2MSFTNGP03.phx.gbl...
>I intend to run SQL 2k on a dual processor server, my company wish however
>to be very economic with licenses and i'd like to know if you run SQL 2k or
>2005 for that matter, is it possible from inside SQL to set the application
>to only run on one of the processors?
>
Yes. You can set SQL Server's CPU Affinity mask to have SQL run on a subset
of the processors. However this has no affect on licensing.
affinity mask Option
http://msdn2.microsoft.com/en-us/library/ms187104.aspx
> I know this is a bit of a dunb question and there are some very smart
> answers that could be said, but i just need to ask the question, so i can
> go back to company people and tell them they are being very tight!!
> And get them to buy another enterprise server processor licence.
>
SQL Sever must be licensed on all processors that the Windows instance can
see. So unless you can turn off one of the CPU's in the BIOS, or you
install SQL Server on a Virtual Server that can only "see" one CPU, you must
license both processors.
SQL Server Pricing and Licensing
http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx
David|||Meaning I guess that because the application is installed on a dual
processor box, it will need 2 licences no matter now many are being
utilised?
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:%234SpDIWtGHA.1512@.TK2MSFTNGP03.phx.gbl...
> "Stu" <lbwer@.blah.com> wrote in message
> news:OxhPN5VtGHA.3552@.TK2MSFTNGP03.phx.gbl...
>>I intend to run SQL 2k on a dual processor server, my company wish however
>>to be very economic with licenses and i'd like to know if you run SQL 2k
>>or 2005 for that matter, is it possible from inside SQL to set the
>>application to only run on one of the processors?
> Yes. You can set SQL Server's CPU Affinity mask to have SQL run on a
> subset of the processors. However this has no affect on licensing.
> affinity mask Option
> http://msdn2.microsoft.com/en-us/library/ms187104.aspx
>> I know this is a bit of a dunb question and there are some very smart
>> answers that could be said, but i just need to ask the question, so i can
>> go back to company people and tell them they are being very tight!!
>> And get them to buy another enterprise server processor licence.
> SQL Sever must be licensed on all processors that the Windows instance can
> see. So unless you can turn off one of the CPU's in the BIOS, or you
> install SQL Server on a Virtual Server that can only "see" one CPU, you
> must license both processors.
> SQL Server Pricing and Licensing
> http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx
> David
>|||"Stu" <lbwer@.blah.com> wrote in message
news:e2XEVNWtGHA.4140@.TK2MSFTNGP03.phx.gbl...
> Meaning I guess that because the application is installed on a dual
> processor box, it will need 2 licences no matter now many are being
> utilised?
Yes. Of course for licensing you count "sockets" not "cores".
David|||For SQL 2000, it is necessary to license for each CPU in the computer -even
if they are not used by SQL Server.
However, it SQL 2005, if you used VM Ware (or MS Virtual Server) to create
totally separate environments, then you can license for only the number of
CPU's that are used by SQL Server in that environment.
That could be cost effective for you.
See:
http://download.microsoft.com/download/e/c/a/ecafe5d1-b514-48ab-93eb-61377df9c5c2/SQLServer2005Licensingv1.1.doc
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Stu" <lbwer@.blah.com> wrote in message
news:e2XEVNWtGHA.4140@.TK2MSFTNGP03.phx.gbl...
> Meaning I guess that because the application is installed on a dual
> processor box, it will need 2 licences no matter now many are being
> utilised?
> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
> message news:%234SpDIWtGHA.1512@.TK2MSFTNGP03.phx.gbl...
>> "Stu" <lbwer@.blah.com> wrote in message
>> news:OxhPN5VtGHA.3552@.TK2MSFTNGP03.phx.gbl...
>>I intend to run SQL 2k on a dual processor server, my company wish
>>however to be very economic with licenses and i'd like to know if you run
>>SQL 2k or 2005 for that matter, is it possible from inside SQL to set the
>>application to only run on one of the processors?
>>
>> Yes. You can set SQL Server's CPU Affinity mask to have SQL run on a
>> subset of the processors. However this has no affect on licensing.
>> affinity mask Option
>> http://msdn2.microsoft.com/en-us/library/ms187104.aspx
>> I know this is a bit of a dunb question and there are some very smart
>> answers that could be said, but i just need to ask the question, so i
>> can go back to company people and tell them they are being very tight!!
>> And get them to buy another enterprise server processor licence.
>>
>> SQL Sever must be licensed on all processors that the Windows instance
>> can see. So unless you can turn off one of the CPU's in the BIOS, or you
>> install SQL Server on a Virtual Server that can only "see" one CPU, you
>> must license both processors.
>> SQL Server Pricing and Licensing
>> http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx
>> David
>
to be very economic with licenses and i'd like to know if you run SQL 2k or
2005 for that matter, is it possible from inside SQL to set the application
to only run on one of the processors?
I know this is a bit of a dunb question and there are some very smart
answers that could be said, but i just need to ask the question, so i can go
back to company people and tell them they are being very tight!!
And get them to buy another enterprise server processor licence.
RgdsFrom the SQL Server licensing FAQ
(http://www.microsoft.com/sql/howtobuy/faq.mspx)
<Excerpt>
Do I have to acquire licenses for all of the processors in a server?
A. You have to acquire licenses only for processors that are accessible to
any copy of the operating system upon which SQL Server 2005 is installed. In
a virtualized environment, processor licenses are required for every
processor that is accessed by a virtual machine. Please see the
virtualization licensing brief and virtualization white paper for more
information on how to license under a virtualized environment.
</Excerpt>
The same applies to SQL 2000. Although you can set SQL Server processor
affinity to restrict processor utilization, this does not reduce the number
of licenses required.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Stu" <lbwer@.blah.com> wrote in message
news:OxhPN5VtGHA.3552@.TK2MSFTNGP03.phx.gbl...
>I intend to run SQL 2k on a dual processor server, my company wish however
>to be very economic with licenses and i'd like to know if you run SQL 2k or
>2005 for that matter, is it possible from inside SQL to set the application
>to only run on one of the processors?
> I know this is a bit of a dunb question and there are some very smart
> answers that could be said, but i just need to ask the question, so i can
> go back to company people and tell them they are being very tight!!
> And get them to buy another enterprise server processor licence.
> Rgds
>|||"Stu" <lbwer@.blah.com> wrote in message
news:OxhPN5VtGHA.3552@.TK2MSFTNGP03.phx.gbl...
>I intend to run SQL 2k on a dual processor server, my company wish however
>to be very economic with licenses and i'd like to know if you run SQL 2k or
>2005 for that matter, is it possible from inside SQL to set the application
>to only run on one of the processors?
>
Yes. You can set SQL Server's CPU Affinity mask to have SQL run on a subset
of the processors. However this has no affect on licensing.
affinity mask Option
http://msdn2.microsoft.com/en-us/library/ms187104.aspx
> I know this is a bit of a dunb question and there are some very smart
> answers that could be said, but i just need to ask the question, so i can
> go back to company people and tell them they are being very tight!!
> And get them to buy another enterprise server processor licence.
>
SQL Sever must be licensed on all processors that the Windows instance can
see. So unless you can turn off one of the CPU's in the BIOS, or you
install SQL Server on a Virtual Server that can only "see" one CPU, you must
license both processors.
SQL Server Pricing and Licensing
http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx
David|||Meaning I guess that because the application is installed on a dual
processor box, it will need 2 licences no matter now many are being
utilised?
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:%234SpDIWtGHA.1512@.TK2MSFTNGP03.phx.gbl...
> "Stu" <lbwer@.blah.com> wrote in message
> news:OxhPN5VtGHA.3552@.TK2MSFTNGP03.phx.gbl...
>>I intend to run SQL 2k on a dual processor server, my company wish however
>>to be very economic with licenses and i'd like to know if you run SQL 2k
>>or 2005 for that matter, is it possible from inside SQL to set the
>>application to only run on one of the processors?
> Yes. You can set SQL Server's CPU Affinity mask to have SQL run on a
> subset of the processors. However this has no affect on licensing.
> affinity mask Option
> http://msdn2.microsoft.com/en-us/library/ms187104.aspx
>> I know this is a bit of a dunb question and there are some very smart
>> answers that could be said, but i just need to ask the question, so i can
>> go back to company people and tell them they are being very tight!!
>> And get them to buy another enterprise server processor licence.
> SQL Sever must be licensed on all processors that the Windows instance can
> see. So unless you can turn off one of the CPU's in the BIOS, or you
> install SQL Server on a Virtual Server that can only "see" one CPU, you
> must license both processors.
> SQL Server Pricing and Licensing
> http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx
> David
>|||"Stu" <lbwer@.blah.com> wrote in message
news:e2XEVNWtGHA.4140@.TK2MSFTNGP03.phx.gbl...
> Meaning I guess that because the application is installed on a dual
> processor box, it will need 2 licences no matter now many are being
> utilised?
Yes. Of course for licensing you count "sockets" not "cores".
David|||For SQL 2000, it is necessary to license for each CPU in the computer -even
if they are not used by SQL Server.
However, it SQL 2005, if you used VM Ware (or MS Virtual Server) to create
totally separate environments, then you can license for only the number of
CPU's that are used by SQL Server in that environment.
That could be cost effective for you.
See:
http://download.microsoft.com/download/e/c/a/ecafe5d1-b514-48ab-93eb-61377df9c5c2/SQLServer2005Licensingv1.1.doc
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Stu" <lbwer@.blah.com> wrote in message
news:e2XEVNWtGHA.4140@.TK2MSFTNGP03.phx.gbl...
> Meaning I guess that because the application is installed on a dual
> processor box, it will need 2 licences no matter now many are being
> utilised?
> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
> message news:%234SpDIWtGHA.1512@.TK2MSFTNGP03.phx.gbl...
>> "Stu" <lbwer@.blah.com> wrote in message
>> news:OxhPN5VtGHA.3552@.TK2MSFTNGP03.phx.gbl...
>>I intend to run SQL 2k on a dual processor server, my company wish
>>however to be very economic with licenses and i'd like to know if you run
>>SQL 2k or 2005 for that matter, is it possible from inside SQL to set the
>>application to only run on one of the processors?
>>
>> Yes. You can set SQL Server's CPU Affinity mask to have SQL run on a
>> subset of the processors. However this has no affect on licensing.
>> affinity mask Option
>> http://msdn2.microsoft.com/en-us/library/ms187104.aspx
>> I know this is a bit of a dunb question and there are some very smart
>> answers that could be said, but i just need to ask the question, so i
>> can go back to company people and tell them they are being very tight!!
>> And get them to buy another enterprise server processor licence.
>>
>> SQL Sever must be licensed on all processors that the Windows instance
>> can see. So unless you can turn off one of the CPU's in the BIOS, or you
>> install SQL Server on a Virtual Server that can only "see" one CPU, you
>> must license both processors.
>> SQL Server Pricing and Licensing
>> http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx
>> David
>
dual processor license
We are buying a new db server that will support the future growth of our
company. Our current database load can easily be handled by a single
processor server, but I would like to buy a server that can handle a much
heavier load in the future.
1) I am wondering if I get a dual processor server, can I install a single
processor license of sql server for the time being?
2) Will this only utilize one processor?
3) Can I add an additional processor license in the future as when we need
more processing power?
4) Also, what is the latest projected relase date for SQL Server 2005?
5) Is any pricing availible for this yet?
6) If I get SQL Server 2000 license now, will there be any upgrade options
to 2005 when it is availible?
Any advice is greatly appreciated.
--DanThe SQL Server 2000 Licensing FAQ at
http://www.microsoft.com/sql/howtobuy/faq.asp states the following:
Q. Do I have to license all of the processors in a server?
A. You only have to acquire licenses for processors that are
accessible to any copy of the operating system upon which SQL Server 2000 is
installed.
So that should take care of questions 1 through 3. :-) You could physically
remove one of the processors from the new system and run it that way until
you have need, then purchase the second processor license and install the
second processor.
For #4, I believe our official response is in the summer of 2005.
For #5, I don't think any of the pricing decisions have been made yet.
For #6, there's usually some kind of upgrade pricing, but again, I doubt
that decision has been made yet.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:6E68F23D-3143-4385-8876-06CF474C7299@.microsoft.com...
> We are buying a new db server that will support the future growth of our
> company. Our current database load can easily be handled by a single
> processor server, but I would like to buy a server that can handle a much
> heavier load in the future.
> 1) I am wondering if I get a dual processor server, can I install a single
> processor license of sql server for the time being?
> 2) Will this only utilize one processor?
> 3) Can I add an additional processor license in the future as when we need
> more processing power?
> 4) Also, what is the latest projected relase date for SQL Server 2005?
> 5) Is any pricing availible for this yet?
> 6) If I get SQL Server 2000 license now, will there be any upgrade options
> to 2005 when it is availible?
> Any advice is greatly appreciated.
> --Dan
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end|||Just to add a little to the discussion. MS licensing currently allows you
to buy with software assurance. This lets you upgrade to the newest version
when it comes out provided it's in the timeframe provide by the SA license.
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:eHlqD#u6EHA.3236@.TK2MSFTNGP15.phx.gbl...
> The SQL Server 2000 Licensing FAQ at
> http://www.microsoft.com/sql/howtobuy/faq.asp states the following:
> Q. Do I have to license all of the processors in a server?
>
> A. You only have to acquire licenses for processors that are
> accessible to any copy of the operating system upon which SQL Server 2000
is
> installed.
>
>
> So that should take care of questions 1 through 3. :-) You could
physically
> remove one of the processors from the new system and run it that way until
> you have need, then purchase the second processor license and install the
> second processor.
> For #4, I believe our official response is in the summer of 2005.
> For #5, I don't think any of the pricing decisions have been made yet.
> For #6, there's usually some kind of upgrade pricing, but again, I doubt
> that decision has been made yet.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Please reply to the newsgroups only, thanks.
> "Dan" <Dan@.discussions.microsoft.com> wrote in message
> news:6E68F23D-3143-4385-8876-06CF474C7299@.microsoft.com...
> > We are buying a new db server that will support the future growth of our
> > company. Our current database load can easily be handled by a single
> > processor server, but I would like to buy a server that can handle a
much
> > heavier load in the future.
> >
> > 1) I am wondering if I get a dual processor server, can I install a
single
> > processor license of sql server for the time being?
> > 2) Will this only utilize one processor?
> > 3) Can I add an additional processor license in the future as when we
need
> > more processing power?
> > 4) Also, what is the latest projected relase date for SQL Server 2005?
> > 5) Is any pricing availible for this yet?
> > 6) If I get SQL Server 2000 license now, will there be any upgrade
options
> > to 2005 when it is availible?
> >
> > Any advice is greatly appreciated.
> > --Dan
>
>
company. Our current database load can easily be handled by a single
processor server, but I would like to buy a server that can handle a much
heavier load in the future.
1) I am wondering if I get a dual processor server, can I install a single
processor license of sql server for the time being?
2) Will this only utilize one processor?
3) Can I add an additional processor license in the future as when we need
more processing power?
4) Also, what is the latest projected relase date for SQL Server 2005?
5) Is any pricing availible for this yet?
6) If I get SQL Server 2000 license now, will there be any upgrade options
to 2005 when it is availible?
Any advice is greatly appreciated.
--DanThe SQL Server 2000 Licensing FAQ at
http://www.microsoft.com/sql/howtobuy/faq.asp states the following:
Q. Do I have to license all of the processors in a server?
A. You only have to acquire licenses for processors that are
accessible to any copy of the operating system upon which SQL Server 2000 is
installed.
So that should take care of questions 1 through 3. :-) You could physically
remove one of the processors from the new system and run it that way until
you have need, then purchase the second processor license and install the
second processor.
For #4, I believe our official response is in the summer of 2005.
For #5, I don't think any of the pricing decisions have been made yet.
For #6, there's usually some kind of upgrade pricing, but again, I doubt
that decision has been made yet.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:6E68F23D-3143-4385-8876-06CF474C7299@.microsoft.com...
> We are buying a new db server that will support the future growth of our
> company. Our current database load can easily be handled by a single
> processor server, but I would like to buy a server that can handle a much
> heavier load in the future.
> 1) I am wondering if I get a dual processor server, can I install a single
> processor license of sql server for the time being?
> 2) Will this only utilize one processor?
> 3) Can I add an additional processor license in the future as when we need
> more processing power?
> 4) Also, what is the latest projected relase date for SQL Server 2005?
> 5) Is any pricing availible for this yet?
> 6) If I get SQL Server 2000 license now, will there be any upgrade options
> to 2005 when it is availible?
> Any advice is greatly appreciated.
> --Dan
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end|||Just to add a little to the discussion. MS licensing currently allows you
to buy with software assurance. This lets you upgrade to the newest version
when it comes out provided it's in the timeframe provide by the SA license.
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:eHlqD#u6EHA.3236@.TK2MSFTNGP15.phx.gbl...
> The SQL Server 2000 Licensing FAQ at
> http://www.microsoft.com/sql/howtobuy/faq.asp states the following:
> Q. Do I have to license all of the processors in a server?
>
> A. You only have to acquire licenses for processors that are
> accessible to any copy of the operating system upon which SQL Server 2000
is
> installed.
>
>
> So that should take care of questions 1 through 3. :-) You could
physically
> remove one of the processors from the new system and run it that way until
> you have need, then purchase the second processor license and install the
> second processor.
> For #4, I believe our official response is in the summer of 2005.
> For #5, I don't think any of the pricing decisions have been made yet.
> For #6, there's usually some kind of upgrade pricing, but again, I doubt
> that decision has been made yet.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Please reply to the newsgroups only, thanks.
> "Dan" <Dan@.discussions.microsoft.com> wrote in message
> news:6E68F23D-3143-4385-8876-06CF474C7299@.microsoft.com...
> > We are buying a new db server that will support the future growth of our
> > company. Our current database load can easily be handled by a single
> > processor server, but I would like to buy a server that can handle a
much
> > heavier load in the future.
> >
> > 1) I am wondering if I get a dual processor server, can I install a
single
> > processor license of sql server for the time being?
> > 2) Will this only utilize one processor?
> > 3) Can I add an additional processor license in the future as when we
need
> > more processing power?
> > 4) Also, what is the latest projected relase date for SQL Server 2005?
> > 5) Is any pricing availible for this yet?
> > 6) If I get SQL Server 2000 license now, will there be any upgrade
options
> > to 2005 when it is availible?
> >
> > Any advice is greatly appreciated.
> > --Dan
>
>
Subscribe to:
Posts (Atom)