help for licence purchase

Hello,
Thank you in advance.
I plan to buy SQL 2000. My situation is: two IIS boxes (
dual CPU), one SQL server ( DUAL CPU, 5GB Memory), they
are all running in Windows 2000.
Those two IIS boxes have some other VB applications (<15)
may access database.
Question:
which licence model is good for me? Standard or Enterprise
version?
alex| Hello,
|
| Thank you in advance.
|
| I plan to buy SQL 2000. My situation is: two IIS boxes (
| dual CPU), one SQL server ( DUAL CPU, 5GB Memory), they
| are all running in Windows 2000.
| Those two IIS boxes have some other VB applications (<15)
| may access database.
|
| Question:
| which licence model is good for me? Standard or Enterprise
| version?
--
Hi Alex,
Checkout the licensing section of the SQL Server FAQ at:
http://www.microsoft.com/sql/howtobuy/faq.asp
Hope this helps,
--
Eric Cárdenas
SQL Server support|||Standard and Enterprise refer to the edition of SQL Server. The edition =is a separate item from the licensing mode. For licensing information =refer to http://www.microsoft.com/sql/howtobuy/default.asp. For =information on each edition of SQL Server, refer to this page: =http://www.microsoft.com/sql/evaluation/features/choosing.asp
-- Keith
"alex" <anonymous@.discussions.microsoft.com> wrote in message =news:033c01c3cf25$1d1152c0$a401280a@.phx.gbl...
> Hello,
> > Thank you in advance.
> > I plan to buy SQL 2000. My situation is: two IIS boxes ( > dual CPU), one SQL server ( DUAL CPU, 5GB Memory), they > are all running in Windows 2000.
> Those two IIS boxes have some other VB applications (<15) > may access database.
> > Question:
> which licence model is good for me? Standard or Enterprise > version?
> > alex >|||Thank you guys.
Please tell me how do I buy SQL server in simple words.
Alex
>--Original Message--
>Hello,
>Thank you in advance.
>I plan to buy SQL 2000. My situation is: two IIS boxes (
>dual CPU), one SQL server ( DUAL CPU, 5GB Memory), they
>are all running in Windows 2000.
>Those two IIS boxes have some other VB applications
(<15)
>may access database.
>Question:
>which licence model is good for me? Standard or
Enterprise
>version?
>alex
>.
>|||http://www.microsoft.com/sql/howtobuy/default.asp
Next Steps
1.. Review the SQL Server Licensing FAQ.
2.. Compare prices of Oracle9i and IBM DB2 to learn how much you can =save with SQL Server.
3.. To obtain copies of SQL Server 2000, you can:
a.. Call (800) 426-9400 from the United States or call (877) =568-2495 from Canada to speak with a Microsoft representative. b.. Purchase licenses from Microsoft licensing program resellers. =(http://shop.microsoft.com/helpdesk/mvlref.asp)
c.. Order from a U.S. reseller =(http://shop.microsoft.com/helpdesk/reseller.asp).=20
d.. Search the Microsoft Worldwide Information site =(http://www.microsoft.com/worldwide/) to find an international reseller =in your location. e.. Buy online from shop.microsoft.com. -- Keith
"alex" <anonymous@.discussions.microsoft.com> wrote in message =news:09b401c3cfc1$258421c0$a601280a@.phx.gbl...
> Thank you guys.
> > Please tell me how do I buy SQL server in simple words.
> > Alex
> > >--Original Message--
> >Hello,
> >
> >Thank you in advance.
> >
> >I plan to buy SQL 2000. My situation is: two IIS boxes ( > >dual CPU), one SQL server ( DUAL CPU, 5GB Memory), they > >are all running in Windows 2000.
> >Those two IIS boxes have some other VB applications > (<15) > >may access database.
> >
> >Question:
> >which licence model is good for me? Standard or > Enterprise > >version?
> >
> >alex > >
> >.
> >

Help explain statement start offset and end offset

SELECT TOP 5
total_worker_time/execution_count AS [Avg CPU Time],
(SELECT SUBSTRING(text,statement_start_offset/2,(CASE WHEN
statement_end_offset = -1 then LEN(CONVERT(nvarchar(max), text)) * 2 ELSE
statement_end_offset end -statement_start_offset)/2) FROM
sys.dm_exec_sql_text(sql_handle)) AS query_text
FROM sys.dm_exec_query_stats
ORDER BY [Avg CPU Time] DESCI saw this query to give top CPU hogs and I want
to understand this statement within the query above(SELECT
SUBSTRING(text,statement_start_offset/2,(CASE WHEN statement_end_offset = -1
then LEN(CONVERT(nvarchar(max), text)) * 2 ELSE statement_end_offset
end -statement_start_offset)/2) FROM sys.dm_exec_sql_text(sql_handle)) AS
query_text
Where can i learn more about what that statement is actually trying to do ?
Hassan
The view sys.dm_exec_sql_text(sql_handle)) is showing you the currently
executing batch, which may be a block of many commands or could be a stored
procedure. The offsets are showing you which exact statement in the code is
actually running at the moment. This way you are not looking at the whole
batch of commands and trying to figure out which statement is actually
running.
So, picture a stored procedure with 1000 lines. Suppose you run this query
several times and you see the same value being returned, which we might say
are equip to lines 400 to 407, then you may have found the slow point in the
code that could use some extra work in tuning.
RLF
"Hassan" <hassan@.test.com> wrote in message
news:uonSdUVJIHA.5208@.TK2MSFTNGP04.phx.gbl...
> SELECT TOP 5
> total_worker_time/execution_count AS [Avg CPU Time],
> (SELECT SUBSTRING(text,statement_start_offset/2,(CASE WHEN
> statement_end_offset = -1 then LEN(CONVERT(nvarchar(max), text)) * 2 ELSE
> statement_end_offset end -statement_start_offset)/2) FROM
> sys.dm_exec_sql_text(sql_handle)) AS query_text
> FROM sys.dm_exec_query_stats
> ORDER BY [Avg CPU Time] DESCI saw this query to give top CPU hogs and I
> want to understand this statement within the query above(SELECT
> SUBSTRING(text,statement_start_offset/2,(CASE WHEN statement_end_offset
> = -1 then LEN(CONVERT(nvarchar(max), text)) * 2 ELSE statement_end_offset
> end -statement_start_offset)/2) FROM sys.dm_exec_sql_text(sql_handle)) AS
> query_text
> Where can i learn more about what that statement is actually trying to do
> ?
>

Help explain statement start offset and end offset

SELECT TOP 5
total_worker_time/execution_count AS [Avg CPU Time],
(SELECT SUBSTRING(text,statement_start_offset/2,(CASE WHEN
statement_end_offset = -1 then LEN(CONVERT(nvarchar(max), text)) * 2 ELSE
statement_end_offset end -statement_start_offset)/2) FROM
sys.dm_exec_sql_text(sql_handle)) AS query_text
FROM sys.dm_exec_query_stats
ORDER BY [Avg CPU Time] DESCI saw this query to give top CPU hogs and I
want
to understand this statement within the query above(SELECT
SUBSTRING(text,statement_start_offset/2,(CASE WHEN statement_end_offset = -1
then LEN(CONVERT(nvarchar(max), text)) * 2 ELSE statement_end_offset
end -statement_start_offset)/2) FROM sys.dm_exec_sql_text(sql_handle)) AS
query_text
Where can i learn more about what that statement is actually trying to do ?Hassan
The view sys.dm_exec_sql_text(sql_handle)) is showing you the currently
executing batch, which may be a block of many commands or could be a stored
procedure. The offsets are showing you which exact statement in the code is
actually running at the moment. This way you are not looking at the whole
batch of commands and trying to figure out which statement is actually
running.
So, picture a stored procedure with 1000 lines. Suppose you run this query
several times and you see the same value being returned, which we might say
are equip to lines 400 to 407, then you may have found the slow point in the
code that could use some extra work in tuning.
RLF
"Hassan" <hassan@.test.com> wrote in message
news:uonSdUVJIHA.5208@.TK2MSFTNGP04.phx.gbl...
> SELECT TOP 5
> total_worker_time/execution_count AS [Avg CPU Time],
> (SELECT SUBSTRING(text,statement_start_offset/2,(CASE WHEN
> statement_end_offset = -1 then LEN(CONVERT(nvarchar(max), text)) * 2 ELSE
> statement_end_offset end -statement_start_offset)/2) FROM
> sys.dm_exec_sql_text(sql_handle)) AS query_text
> FROM sys.dm_exec_query_stats
> ORDER BY [Avg CPU Time] DESCI saw this query to give top CPU hogs and
I
> want to understand this statement within the query above(SELECT
> SUBSTRING(text,statement_start_offset/2,(CASE WHEN statement_end_offset
> = -1 then LEN(CONVERT(nvarchar(max), text)) * 2 ELSE statement_end_offset
> end -statement_start_offset)/2) FROM sys.dm_exec_sql_text(sql_handle)) AS
> query_text
> Where can i learn more about what that statement is actually trying to do
> ?
>

Help explain statement start offset and end offset

SELECT TOP 5
total_worker_time/execution_count AS [Avg CPU Time],
(SELECT SUBSTRING(text,statement_start_offset/2,(CASE WHEN
statement_end_offset = -1 then LEN(CONVERT(nvarchar(max), text)) * 2 ELSE
statement_end_offset end -statement_start_offset)/2) FROM
sys.dm_exec_sql_text(sql_handle)) AS query_text
FROM sys.dm_exec_query_stats
ORDER BY [Avg CPU Time] DESCI saw this query to give top CPU hogs and I want
to understand this statement within the query above(SELECT
SUBSTRING(text,statement_start_offset/2,(CASE WHEN statement_end_offset = -1
then LEN(CONVERT(nvarchar(max), text)) * 2 ELSE statement_end_offset
end -statement_start_offset)/2) FROM sys.dm_exec_sql_text(sql_handle)) AS
query_text
Where can i learn more about what that statement is actually trying to do ?Hassan
The view sys.dm_exec_sql_text(sql_handle)) is showing you the currently
executing batch, which may be a block of many commands or could be a stored
procedure. The offsets are showing you which exact statement in the code is
actually running at the moment. This way you are not looking at the whole
batch of commands and trying to figure out which statement is actually
running.
So, picture a stored procedure with 1000 lines. Suppose you run this query
several times and you see the same value being returned, which we might say
are equip to lines 400 to 407, then you may have found the slow point in the
code that could use some extra work in tuning.
RLF
"Hassan" <hassan@.test.com> wrote in message
news:uonSdUVJIHA.5208@.TK2MSFTNGP04.phx.gbl...
> SELECT TOP 5
> total_worker_time/execution_count AS [Avg CPU Time],
> (SELECT SUBSTRING(text,statement_start_offset/2,(CASE WHEN
> statement_end_offset = -1 then LEN(CONVERT(nvarchar(max), text)) * 2 ELSE
> statement_end_offset end -statement_start_offset)/2) FROM
> sys.dm_exec_sql_text(sql_handle)) AS query_text
> FROM sys.dm_exec_query_stats
> ORDER BY [Avg CPU Time] DESCI saw this query to give top CPU hogs and I
> want to understand this statement within the query above(SELECT
> SUBSTRING(text,statement_start_offset/2,(CASE WHEN statement_end_offset
> = -1 then LEN(CONVERT(nvarchar(max), text)) * 2 ELSE statement_end_offset
> end -statement_start_offset)/2) FROM sys.dm_exec_sql_text(sql_handle)) AS
> query_text
> Where can i learn more about what that statement is actually trying to do
> ?
>