the URL when the report is rendered. How can I do this?If you are using RS 2005 and are either at or can go to 2.0 framework then
check out the new webform controls that ship with VS 2005. The other option
is to use web services instead of URL integration URL integration is easier
but it really is not suitable if you are trying to hide things from the
user.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"OriginalStealth" <OriginalStealth@.discussions.microsoft.com> wrote in
message news:F77A8831-CD45-4431-8DF6-E89D487C3F80@.microsoft.com...
> the URL when the report is rendered. How can I do this?
Showing posts with label interface. Show all posts
Showing posts with label interface. Show all posts
Monday, March 12, 2012
Wednesday, March 7, 2012
HyperTreading and SQL 2000 licenses.
Hi,
Licensing wise, if a server has 2 physical CPU's that hyperthreaded, how
many licenses need to be configured in SQL interface.
I know we need to buy 2, but does SQL 2000 recognize that the 4 CPU's
showing are really 2 physical CPU's...
Thanks !!!
SQL Licensing is per physical CPU 'Socket'.
Dual core, hyperthreaded processors can be seen as four (4) processors by
the OS (and SQL Server) -BUT only require a single license.
There is a Computer GOD!
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Thinkpad21" <thinkpad21@.yahoo.com> wrote in message
news:ukXwjFuHHHA.1264@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Licensing wise, if a server has 2 physical CPU's that hyperthreaded, how
> many licenses need to be configured in SQL interface.
> I know we need to buy 2, but does SQL 2000 recognize that the 4 CPU's
> showing are really 2 physical CPU's...
> Thanks !!!
>
|||Thinkpad21 wrote:
> Hi,
> Licensing wise, if a server has 2 physical CPU's that hyperthreaded, how
> many licenses need to be configured in SQL interface.
> I know we need to buy 2, but does SQL 2000 recognize that the 4 CPU's
> showing are really 2 physical CPU's...
Regardless of how you license it SQL Server can use all processors. It
is your repsonsibility to license them correctly (i.e. per physical
processor).
For optimum performance with HT it is important that you mask 2 of the
logical processors so that SQL Server will not attempt to use more than
that number. 2 x HT CPUs is NOT the same as 4 cores.
See: http://support.microsoft.com/kb/322385
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
Licensing wise, if a server has 2 physical CPU's that hyperthreaded, how
many licenses need to be configured in SQL interface.
I know we need to buy 2, but does SQL 2000 recognize that the 4 CPU's
showing are really 2 physical CPU's...
Thanks !!!
SQL Licensing is per physical CPU 'Socket'.
Dual core, hyperthreaded processors can be seen as four (4) processors by
the OS (and SQL Server) -BUT only require a single license.
There is a Computer GOD!
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Thinkpad21" <thinkpad21@.yahoo.com> wrote in message
news:ukXwjFuHHHA.1264@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Licensing wise, if a server has 2 physical CPU's that hyperthreaded, how
> many licenses need to be configured in SQL interface.
> I know we need to buy 2, but does SQL 2000 recognize that the 4 CPU's
> showing are really 2 physical CPU's...
> Thanks !!!
>
|||Thinkpad21 wrote:
> Hi,
> Licensing wise, if a server has 2 physical CPU's that hyperthreaded, how
> many licenses need to be configured in SQL interface.
> I know we need to buy 2, but does SQL 2000 recognize that the 4 CPU's
> showing are really 2 physical CPU's...
Regardless of how you license it SQL Server can use all processors. It
is your repsonsibility to license them correctly (i.e. per physical
processor).
For optimum performance with HT it is important that you mask 2 of the
logical processors so that SQL Server will not attempt to use more than
that number. 2 x HT CPUs is NOT the same as 4 cores.
See: http://support.microsoft.com/kb/322385
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
HyperTreading and SQL 2000 licenses.
Hi,
Licensing wise, if a server has 2 physical CPU's that hyperthreaded, how
many licenses need to be configured in SQL interface.
I know we need to buy 2, but does SQL 2000 recognize that the 4 CPU's
showing are really 2 physical CPU's...
Thanks !!!SQL Licensing is per physical CPU 'Socket'.
Dual core, hyperthreaded processors can be seen as four (4) processors by
the OS (and SQL Server) -BUT only require a single license.
There is a Computer GOD!
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Thinkpad21" <thinkpad21@.yahoo.com> wrote in message
news:ukXwjFuHHHA.1264@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Licensing wise, if a server has 2 physical CPU's that hyperthreaded, how
> many licenses need to be configured in SQL interface.
> I know we need to buy 2, but does SQL 2000 recognize that the 4 CPU's
> showing are really 2 physical CPU's...
> Thanks !!!
>|||Thinkpad21 wrote:
> Hi,
> Licensing wise, if a server has 2 physical CPU's that hyperthreaded, how
> many licenses need to be configured in SQL interface.
> I know we need to buy 2, but does SQL 2000 recognize that the 4 CPU's
> showing are really 2 physical CPU's...
Regardless of how you license it SQL Server can use all processors. It
is your repsonsibility to license them correctly (i.e. per physical
processor).
For optimum performance with HT it is important that you mask 2 of the
logical processors so that SQL Server will not attempt to use more than
that number. 2 x HT CPUs is NOT the same as 4 cores.
See: http://support.microsoft.com/kb/322385
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
Licensing wise, if a server has 2 physical CPU's that hyperthreaded, how
many licenses need to be configured in SQL interface.
I know we need to buy 2, but does SQL 2000 recognize that the 4 CPU's
showing are really 2 physical CPU's...
Thanks !!!SQL Licensing is per physical CPU 'Socket'.
Dual core, hyperthreaded processors can be seen as four (4) processors by
the OS (and SQL Server) -BUT only require a single license.
There is a Computer GOD!
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Thinkpad21" <thinkpad21@.yahoo.com> wrote in message
news:ukXwjFuHHHA.1264@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Licensing wise, if a server has 2 physical CPU's that hyperthreaded, how
> many licenses need to be configured in SQL interface.
> I know we need to buy 2, but does SQL 2000 recognize that the 4 CPU's
> showing are really 2 physical CPU's...
> Thanks !!!
>|||Thinkpad21 wrote:
> Hi,
> Licensing wise, if a server has 2 physical CPU's that hyperthreaded, how
> many licenses need to be configured in SQL interface.
> I know we need to buy 2, but does SQL 2000 recognize that the 4 CPU's
> showing are really 2 physical CPU's...
Regardless of how you license it SQL Server can use all processors. It
is your repsonsibility to license them correctly (i.e. per physical
processor).
For optimum performance with HT it is important that you mask 2 of the
logical processors so that SQL Server will not attempt to use more than
that number. 2 x HT CPUs is NOT the same as 4 cores.
See: http://support.microsoft.com/kb/322385
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
HyperTreading and SQL 2000 licenses.
Hi,
Licensing wise, if a server has 2 physical CPU's that hyperthreaded, how
many licenses need to be configured in SQL interface.
I know we need to buy 2, but does SQL 2000 recognize that the 4 CPU's
showing are really 2 physical CPU's...
Thanks !!!SQL Licensing is per physical CPU 'Socket'.
Dual core, hyperthreaded processors can be seen as four (4) processors by
the OS (and SQL Server) -BUT only require a single license.
There is a Computer GOD!
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Thinkpad21" <thinkpad21@.yahoo.com> wrote in message
news:ukXwjFuHHHA.1264@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Licensing wise, if a server has 2 physical CPU's that hyperthreaded, how
> many licenses need to be configured in SQL interface.
> I know we need to buy 2, but does SQL 2000 recognize that the 4 CPU's
> showing are really 2 physical CPU's...
> Thanks !!!
>|||Thinkpad21 wrote:
> Hi,
> Licensing wise, if a server has 2 physical CPU's that hyperthreaded, how
> many licenses need to be configured in SQL interface.
> I know we need to buy 2, but does SQL 2000 recognize that the 4 CPU's
> showing are really 2 physical CPU's...
Regardless of how you license it SQL Server can use all processors. It
is your repsonsibility to license them correctly (i.e. per physical
processor).
For optimum performance with HT it is important that you mask 2 of the
logical processors so that SQL Server will not attempt to use more than
that number. 2 x HT CPUs is NOT the same as 4 cores.
See: http://support.microsoft.com/kb/322385
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
Licensing wise, if a server has 2 physical CPU's that hyperthreaded, how
many licenses need to be configured in SQL interface.
I know we need to buy 2, but does SQL 2000 recognize that the 4 CPU's
showing are really 2 physical CPU's...
Thanks !!!SQL Licensing is per physical CPU 'Socket'.
Dual core, hyperthreaded processors can be seen as four (4) processors by
the OS (and SQL Server) -BUT only require a single license.
There is a Computer GOD!
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Thinkpad21" <thinkpad21@.yahoo.com> wrote in message
news:ukXwjFuHHHA.1264@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Licensing wise, if a server has 2 physical CPU's that hyperthreaded, how
> many licenses need to be configured in SQL interface.
> I know we need to buy 2, but does SQL 2000 recognize that the 4 CPU's
> showing are really 2 physical CPU's...
> Thanks !!!
>|||Thinkpad21 wrote:
> Hi,
> Licensing wise, if a server has 2 physical CPU's that hyperthreaded, how
> many licenses need to be configured in SQL interface.
> I know we need to buy 2, but does SQL 2000 recognize that the 4 CPU's
> showing are really 2 physical CPU's...
Regardless of how you license it SQL Server can use all processors. It
is your repsonsibility to license them correctly (i.e. per physical
processor).
For optimum performance with HT it is important that you mask 2 of the
logical processors so that SQL Server will not attempt to use more than
that number. 2 x HT CPUs is NOT the same as 4 cores.
See: http://support.microsoft.com/kb/322385
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
Labels:
configured,
cpu,
database,
hyperthreaded,
hypertreading,
interface,
licenses,
licensing,
microsoft,
mysql,
oracle,
physical,
server,
sql,
wise
Subscribe to:
Posts (Atom)