Showing posts with label single. Show all posts
Showing posts with label single. Show all posts

Tuesday, March 27, 2012

Duplicate Records in a table

How do i remove duplicate records from a table with a single query without using cursors or anything like that.

Sample :

tempCol

1

1

2

2

1

P.S The table has only one column


Usually way is: in your query, create a temp table to hold the distinct records from your physical table, then, delete the rows in the physical table, then, insert back from your temp table, finally, drop the temp table.

|||

che3358gives a good way to do it. The only thing I'd add is that you can make it all go faster by doing it only for the duplicate rows, ie, instead of doing it for distinct rows, do a count(*) and a having, ie,

select field1, field2, field3
into #DupTable
from mytable
group by field1, field2, field3
having count(*) > 1


delete mytable
from mytable a, #DupTable b
where a.field1 = a.field1
and b.field2 = b.field2
and ....

insert into mytable (field1, field2, ...)
select field1, field2, ...
from #DupTable

Thursday, March 22, 2012

Duplicate an existing SQL Login Account

How does one create a copy of an existing SQL login account. I have a
database that has a single login with everything setup. I just want to be
able to copy/duplicate the existing account to a new user so I can set a
different
password.
Thanks!You might be able to get what you want by "Generating SQL Script" from
the right-click context menu on the database you want to add the user
to. Place the checkmarks on the first tab to create all types of
objects, uncheck the options to create the CREATE and DROP statements on
the second tab, and go to the 3rd tab and check "Script object-level
permissions".
When you build the script, it should include commands that grant the
permissions to the current account that holds the permissions. You will
have to manually pick through the script commands to find the
appropriate ones and change the name of the user to replace the old
user's username with the new one to build an entirely new script.
While not the answer you're looking for, I think you should consider
creating one or more roles configured to grant permissions that match
the account that is configured properly now, then create the new account
and add the both user accounts to the role you created.
Good luck,
Tony Sebion
"John Williams" <JohnWilliams@.discussions.microsoft.com> wrote in
message news:F0AEB5FA-2AFD-4785-9217-184B22E3CFE0@.microsoft.com:

> How does one create a copy of an existing SQL login account. I have a
> database that has a single login with everything setup. I just want to be
> able to copy/duplicate the existing account to a new user so I can set a
> different
> password.
> Thanks!|||Scripting it out will work, the only downside would be remebering to
propogate all changes from user to user as things change. And things
always do change...
I'd recommend setting the permissions that are on user account to a
role instead. Then you can assign the role to the users that need
those permissions.
If needed you can deny access to objects on a user by user basis if
necessary or create another role that has those denied permissions and
assign that to the users.
HTH
Jason Strate

Duplicate an existing SQL Login Account

How does one create a copy of an existing SQL login account. I have a
database that has a single login with everything setup. I just want to be
able to copy/duplicate the existing account to a new user so I can set a
different
password.
Thanks!
You might be able to get what you want by "Generating SQL Script" from
the right-click context menu on the database you want to add the user
to. Place the checkmarks on the first tab to create all types of
objects, uncheck the options to create the CREATE and DROP statements on
the second tab, and go to the 3rd tab and check "Script object-level
permissions".
When you build the script, it should include commands that grant the
permissions to the current account that holds the permissions. You will
have to manually pick through the script commands to find the
appropriate ones and change the name of the user to replace the old
user's username with the new one to build an entirely new script.
While not the answer you're looking for, I think you should consider
creating one or more roles configured to grant permissions that match
the account that is configured properly now, then create the new account
and add the both user accounts to the role you created.
Good luck,
Tony Sebion
"John Williams" <JohnWilliams@.discussions.microsoft.com> wrote in
message news:F0AEB5FA-2AFD-4785-9217-184B22E3CFE0@.microsoft.com:

> How does one create a copy of an existing SQL login account. I have a
> database that has a single login with everything setup. I just want to be
> able to copy/duplicate the existing account to a new user so I can set a
> different
> password.
> Thanks!
|||Scripting it out will work, the only downside would be remebering to
propogate all changes from user to user as things change. And things
always do change...
I'd recommend setting the permissions that are on user account to a
role instead. Then you can assign the role to the users that need
those permissions.
If needed you can deny access to objects on a user by user basis if
necessary or create another role that has those denied permissions and
assign that to the users.
HTH
Jason Strate

Duplicate an existing SQL Login Account

How does one create a copy of an existing SQL login account. I have a
database that has a single login with everything setup. I just want to be
able to copy/duplicate the existing account to a new user so I can set a
different
password.
Thanks!You might be able to get what you want by "Generating SQL Script" from
the right-click context menu on the database you want to add the user
to. Place the checkmarks on the first tab to create all types of
objects, uncheck the options to create the CREATE and DROP statements on
the second tab, and go to the 3rd tab and check "Script object-level
permissions".
When you build the script, it should include commands that grant the
permissions to the current account that holds the permissions. You will
have to manually pick through the script commands to find the
appropriate ones and change the name of the user to replace the old
user's username with the new one to build an entirely new script.
While not the answer you're looking for, I think you should consider
creating one or more roles configured to grant permissions that match
the account that is configured properly now, then create the new account
and add the both user accounts to the role you created.
Good luck,
Tony Sebion
"John Williams" <JohnWilliams@.discussions.microsoft.com> wrote in
message news:F0AEB5FA-2AFD-4785-9217-184B22E3CFE0@.microsoft.com:
> How does one create a copy of an existing SQL login account. I have a
> database that has a single login with everything setup. I just want to be
> able to copy/duplicate the existing account to a new user so I can set a
> different
> password.
> Thanks!|||Scripting it out will work, the only downside would be remebering to
propogate all changes from user to user as things change. And things
always do change...
I'd recommend setting the permissions that are on user account to a
role instead. Then you can assign the role to the users that need
those permissions.
If needed you can deny access to objects on a user by user basis if
necessary or create another role that has those denied permissions and
assign that to the users.
HTH
Jason Strate

Duplicate an existig SQL user login account

How does one create a copy of an existing SQL login account. I have a
database that has a single login with everything setup. I just want to be
able to copy the existing account to a new user so I can set a different
password.
Thanks!You might be able to get what you want by "Generating SQL Script" from
the right-click context menu on the database you want to add the user
to. Place the checkmarks on the first tab to create all types of
objects, uncheck the options to create the CREATE and DROP statements on
the second tab, and go to the 3rd tab and check "Script object-level
permissions".
When you build the script, it should include commands that grant the
permissions to the current account that holds the permissions. You will
have to manually pick through the script commands to find the
appropriate ones and change the name of the user to replace the old
user's username with the new one to build an entirely new script.
While not the answer you're looking for, I think you should consider
creating one or more roles configured to grant permissions that match
the account that is configured properly now, then create the new account
and add the both user accounts to the role you created.
Good luck,
Tony Sebion
"John Williams" <JohnWilliams@.discussions.microsoft.com> wrote in
message news:5EA1D83E-15E9-44B9-9707-C4AAB5C9CDB6@.microsoft.com:

> How does one create a copy of an existing SQL login account. I have a
> database that has a single login with everything setup. I just want to be
> able to copy the existing account to a new user so I can set a different
> password.
> Thanks!sql

Sunday, March 11, 2012

Dual Y-Axes

Greetings,

I'm wondering if it is possible to have two independent y-axes on a single chart?

I am wanting to plot data using a hybrid bar/line chart and have the values for the vertical bars show on the left y-axis and the values for the points on the line show on the right y-axis.

I've seen this sort of thing done on other platforms before, but don't know if it is possible with SQL Reporting. We are using SQL RS 2000 by the way.

Thanks
--
AnthonyI think RS can't do it out of the box. Have a look at Dundas Charts.|||I was afraid you would say that. I will see if Dundas Charts has anything that will work, but I don't know that we are going to get that in our budget, so if anyone else knows of a way to rig RS to do it without Dundas, that would be great.

Also, from looking at the Dundas site, it appears they are only offering Dundas Charts for RS 2005 at this point. Whether it would still work with RS 2000, I don't know.
|||I know Dundas definately supports it, I use it quite regularly.|||

Keep in mind that the CustomReportItem-based extensibility (such as "Dundas Charts for Reporting Services" or similar offers from other third parties) are available for SSRS 2005 only in Standard, Enterprise, or Developer Editions.

It is not available for SSRS 2000.

-- Robert

Dual Xeon or Dual P4 for SQL Server?

I am planning to build a server to be used as a SQL Server and web server.
Right now I can only use a single box for both.

I have read some threads were dual processors are having problems with some
parallel queries and the suggestions of having sql server use a single CPU.

My budget is limited so I am debating whether to get 2.6G dual xeon 533FSB
or dual P4 800FSB (DRR@. ram) or stick with a speedy single cpu.
If I get a dual cpu motherboard, is it a good idea to have 1 cpu used for
sql server and the other for everything else?

John DalbergOn Sun, 21 Nov 2004 07:14:17 -0800, John Dalberg wrote:

> I am planning to build a server to be used as a SQL Server and web server.
> Right now I can only use a single box for both.
> I have read some threads were dual processors are having problems with some
> parallel queries and the suggestions of having sql server use a single CPU.
> My budget is limited so I am debating whether to get 2.6G dual xeon 533FSB
> or dual P4 800FSB (DRR@. ram) or stick with a speedy single cpu.
> If I get a dual cpu motherboard, is it a good idea to have 1 cpu used for
> sql server and the other for everything else?
> John Dalberg

I forgot to mention also what about AMD's Athlon since I can get faster
Athlons for the same amount of money for Intel CPUs? Are dual Athlon
motherboards a good choice for SQL Server?

John Dalberg|||In article <u1ekecr53aij.1ek79hzro64q4$.dlg@.40tude.net>,
john_dd@.hotmail.com says...
> I am planning to build a server to be used as a SQL Server and web server.
> Right now I can only use a single box for both.
> I have read some threads were dual processors are having problems with some
> parallel queries and the suggestions of having sql server use a single CPU.
> My budget is limited so I am debating whether to get 2.6G dual xeon 533FSB
> or dual P4 800FSB (DRR@. ram) or stick with a speedy single cpu.
> If I get a dual cpu motherboard, is it a good idea to have 1 cpu used for
> sql server and the other for everything else?

John, you can't use Dual P4's any more, Intel fixed that after the P3.

If you want to build a cheap but fast SQL Server, assuming SQL 2000 or
higher, tape a look at the ASUS PC-DL Deluxe motherboard. I have about
30 of these running the following:

ASUS PC-DL Deluxe
Dua Xeon 2.4G (or faster) (make sure they are same lot/part)
2GB or 4GB of RAM (does not require ECC RAM)
It has onboard SATA and IDE, you can use a total of 6 drives between the
connectors without a problem.

The 2GB systems with Dual 250GB SATA drives, video, case, CD-ROM, etc...
are under $1900 each.

If you want a big box, like this:

PC-DL Deluxe
Dual Xeon 2.8ghz
2 x 80GB IDE (OS = 12GB, LOGS = 60GB)
6 x 250GB IDE (for DATA files)
Promise SX6000 Hardware IDE RAID Controller (hot swap IDE drives)
cheap video
Chenbro Server case with Dual 550W PSU's
and Windows 2003 Standard Server 5cal

This box runs about $4000

I run SQL 2000 on Dual P3 and Dual/Quad Xeon without any problems.

If you get a P4, get one that does Hyper-Threading, and use Server 2003
so that you get the most benefit from it.

As for Athlon, faster is a matter of what task is being performed and
how stable you want the system to be. When it comes to business systems
I use Intel CPU's only, but that's a personal preference and has never
cost me a job or stability.

--
--
spamfree999@.rrohio.com
(Remove 999 to reply to me)|||John Dalberg (john_dd@.hotmail.com) writes:
> I am planning to build a server to be used as a SQL Server and web server.
> Right now I can only use a single box for both.
> I have read some threads were dual processors are having problems with
> some parallel queries and the suggestions of having sql server use a
> single CPU.
> My budget is limited so I am debating whether to get 2.6G dual xeon 533FSB
> or dual P4 800FSB (DRR@. ram) or stick with a speedy single cpu.
> If I get a dual cpu motherboard, is it a good idea to have 1 cpu used for
> sql server and the other for everything else?

Machine configurations is not my best game, but if you are going to have
both SQL Server and web server on the same box, I would definitely go for
two CPUs. (Or at least one CPU that is hyper-threaded.)

As for SQL Server and parallel queries, yes, there is a potential problem.
I have seen more than once, SQL Server being too optimistic about parallel
query plans, and taken a plan with poor performance. What we usually do,
when we run into these queries is to add the query hint OPTION (MAXDOP 1)
which turns of parallellism for that query.

A more definitive cure is to set the configuration option "Max degress of
parllellism" to 1. Note that this is not the same as confining SQL Server
to one CPU only, but that one single query can only take one processor. Two
users executing different queries can still get one CPU each.

Giving SQL Server only one CPU *may* be a good idea, if you expect the
web server and the rest to need substantial amount of resources. But you
could also get the effect that one processor is mainly idle, while the
other is working around the clock.

So my recommendation would be set "Max degrees of Parallelism" to 1 (Or
to 2, if you have two hyper-threaded CPUs), but let SQL Server use both
CPUs.

Finally, there may be a licensing issue. I vaguely recall that for some
editions that you pay a license per processor, but please check this with
Microsoft. Licensing is definitely not my best game.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||In article <Xns95A8BE037B8EAYazorman@.127.0.0.1>, esquel@.sommarskog.se
says...
> Finally, there may be a licensing issue. I vaguely recall that for some
> editions that you pay a license per processor, but please check this with
> Microsoft. Licensing is definitely not my best game.

I was told by the MS People in the Great Lakes MS Office that HT CPU's
still count as 1 CPU for licensing.

One other thing, unless he's using SBS, I was also told that a Web
Server accessing a MS SQL Database, requires a CPU License on the
Database server for each physical CPU the SQL server is permitted to
use.

I have always licensed our SQL Servers in CPU mode when being accessed
by a web server using anonymous connections to the web server.

--
--
spamfree999@.rrohio.com
(Remove 999 to reply to me)|||Erland Sommarskog wrote:
> John Dalberg (john_dd@.hotmail.com) writes:
> > I am planning to build a server to be used as a SQL Server and web
server.
> > Right now I can only use a single box for both.
> > bob.mckenna@.rbc.com
> > I have read some threads were dual processors are having problems
with
> > some parallel queries and the suggestions of having sql server use
a
> > single CPU.
> > My budget is limited so I am debating whether to get 2.6G dual xeon
533FSB
> > or dual P4 800FSB (DRR@. ram) or stick with a speedy single cpu.
> > If I get a dual cpu motherboard, is it a good idea to have 1 cpu
used for
> > sql server and the other for everything else?
> Machine configurations is not my best game, but if you are going to
have
> both SQL Server and web server on the same box, I would definitely go
for
> two CPUs. (Or at least one CPU that is hyper-threaded.)
> As for SQL Server and parallel queries, yes, there is a potential
problem.
> I have seen more than once, SQL Server being too optimistic about
parallel
> query plans, and taken a plan with poor performance. What we usually
do,
> when we run into these queries is to add the query hint OPTION
(MAXDOP 1)
> which turns of parallellism for that query.
> A more definitive cure is to set the configuration option "Max
degress of
> parllellism" to 1. Note that this is not the same as confining SQL
Server
> to one CPU only, but that one single query can only take one
processor. Two
> users executing different queries can still get one CPU each.
> Giving SQL Server only one CPU *may* be a good idea, if you expect
the
> web server and the rest to need substantial amount of resources. But
you
> could also get the effect that one processor is mainly idle, while
the
> other is working around the clock.
> So my recommendation would be set "Max degrees of Parallelism" to 1
(Or
> to 2, if you have two hyper-threaded CPUs), but let SQL Server use
both
> CPUs.
>
> Finally, there may be a licensing issue. I vaguely recall that for
some
> editions that you pay a license per processor, but please check this
with
> Microsoft. Licensing is definitely not my best game.
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp

Friday, March 9, 2012

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
>
>

Dual CPU w/Dual Core or single core with dual CPU

Hello everyone,
I am about to replace my current SQL server that is running a dual 1.2ghz
Itanium 64 cpu. We just hate the lack of support for the Itanium. We are
looking at a 2.8 dual core/dual cpu machine or a single core 3.4ghz dual cpu
machine. Which should perform the best for SQL server? Both machines have
2mb cache.
Thanks,
Nick
You might want to look at the dual core AMD boxes. You can probably get 2
dual core CPU's for less than what you think and you can run SQL2005 64 bit
edition on them.
Andrew J. Kelly SQL MVP
"Nick" <nsocha@.prodigy.net> wrote in message
news:uMnG3ckFGHA.2064@.TK2MSFTNGP09.phx.gbl...
> Hello everyone,
> I am about to replace my current SQL server that is running a dual 1.2ghz
> Itanium 64 cpu. We just hate the lack of support for the Itanium. We are
> looking at a 2.8 dual core/dual cpu machine or a single core 3.4ghz dual
> cpu machine. Which should perform the best for SQL server? Both machines
> have 2mb cache.
> Thanks,
> Nick
>
|||Thanks for the reply.
I have heard great things about the dual core AMD, but I am still wondering
if the 2.8 dual core/dual cpu will outperform a single core /dual cpu 3.4?
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23OR3QsrFGHA.4036@.TK2MSFTNGP12.phx.gbl...
> You might want to look at the dual core AMD boxes. You can probably get 2
> dual core CPU's for less than what you think and you can run SQL2005 64
> bit edition on them.
> --
> Andrew J. Kelly SQL MVP
>
> "Nick" <nsocha@.prodigy.net> wrote in message
> news:uMnG3ckFGHA.2064@.TK2MSFTNGP09.phx.gbl...
>
|||Even though the dual cores are almost the same as two individual processors
there is a difference. Of coarse you would have to test under your exact
conditions but I would be very surprised if the 2.8GHZ processors (dual core
or dual procs) would perform as well as two 3.4GHZ ones. All other things
equal a faster proc will beat a slower one.
Andrew J. Kelly SQL MVP
"Nick" <nsocha@.prodigy.net> wrote in message
news:e3ORd7rFGHA.3684@.TK2MSFTNGP14.phx.gbl...
> Thanks for the reply.
> I have heard great things about the dual core AMD, but I am still
> wondering if the 2.8 dual core/dual cpu will outperform a single core
> /dual cpu 3.4?
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%23OR3QsrFGHA.4036@.TK2MSFTNGP12.phx.gbl...
>
|||Thanks for the replies. I am leaning towards the 3.4 single cores.
Nick
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uXO8yQsFGHA.2012@.TK2MSFTNGP14.phx.gbl...
> Even though the dual cores are almost the same as two individual
> processors there is a difference. Of coarse you would have to test under
> your exact conditions but I would be very surprised if the 2.8GHZ
> processors (dual core or dual procs) would perform as well as two 3.4GHZ
> ones. All other things equal a faster proc will beat a slower one.
> --
> Andrew J. Kelly SQL MVP
>
> "Nick" <nsocha@.prodigy.net> wrote in message
> news:e3ORd7rFGHA.3684@.TK2MSFTNGP14.phx.gbl...
>
|||Are you queries compute intensive? Is your CPU a bottleneck? There is no
way to answer this as a generic configuration. It all depends upon what you
are doing on the system. Just because a processor is dual core doesn't mean
you get the equivalent of 2 processors. You get more processing capacity on
a single die, but it doesn't double.
"Nick" <nsocha@.prodigy.net> wrote in message
news:uMnG3ckFGHA.2064@.TK2MSFTNGP09.phx.gbl...
> Hello everyone,
> I am about to replace my current SQL server that is running a dual 1.2ghz
> Itanium 64 cpu. We just hate the lack of support for the Itanium. We are
> looking at a 2.8 dual core/dual cpu machine or a single core 3.4ghz dual
> cpu machine. Which should perform the best for SQL server? Both machines
> have 2mb cache.
> Thanks,
> Nick
>
|||Nick wrote:
> Hello everyone,
> I am about to replace my current SQL server that is running a dual 1.2ghz
> Itanium 64 cpu. We just hate the lack of support for the Itanium. We are
> looking at a 2.8 dual core/dual cpu machine or a single core 3.4ghz dual cpu
> machine. Which should perform the best for SQL server? Both machines have
> 2mb cache.
you need to look at your machines usage. the 2 slower dual cores will
give you 4 processors instead of 2. the 2 additional processors might
benefit your system or, as in my case, could seriously degrade
performance of parallel queries. i went from dual cpu to dual
hyperthreaded cpu's and had to limit queries to 1 processor because a
few parallel queries ran much slower on the 4 faster processors than the
2 slower processors.
|||Nick,
I am a little confused now as to what you originally meant.
[vbcol=seagreen]
Is the 2.8 two dual core procs or a single dual core proc? If it is indeed
two dual cores then you basically have 4 processors vs the two of the
3.4GHZ. So that would probably be my choice if you have multiple concurrent
users or lots of parallel queries.
Andrew J. Kelly SQL MVP
"Nick" <nsocha@.prodigy.net> wrote in message
news:OCIDZRtFGHA.1396@.TK2MSFTNGP11.phx.gbl...
> Thanks for the replies. I am leaning towards the 3.4 single cores.
> Nick
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uXO8yQsFGHA.2012@.TK2MSFTNGP14.phx.gbl...
>
|||You may be surprised, as the Intel 2.8Ghz Dual Cores have 2x2MB of L2 cache,
no L3 cache and 800Mhz FSB, where the 3.4Ghz have only 1MB of L2 cache, and
up to 8MB L3 cache, it has only a maximum of 667Mhz FSB. In addition each
of the Dual Core processors can be hyper-threaded, resulting in 8 Virtual
CPU's versus only the 4 Virtual CPU's the 3.4Ghz will produce, thus handling
twice as many threads simultaneously as the 3.4Ghz - and after all, the
speed difference is only 600Mhz, only slightly faster than the first PIII's.
Star Fleet Admiral Q @. your service!
Google is your friend!
http://www.google.com
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uXO8yQsFGHA.2012@.TK2MSFTNGP14.phx.gbl...
> Even though the dual cores are almost the same as two individual
> processors there is a difference. Of coarse you would have to test under
> your exact conditions but I would be very surprised if the 2.8GHZ
> processors (dual core or dual procs) would perform as well as two 3.4GHZ
> ones. All other things equal a faster proc will beat a slower one.
> --
> Andrew J. Kelly SQL MVP
>
> "Nick" <nsocha@.prodigy.net> wrote in message
> news:e3ORd7rFGHA.3684@.TK2MSFTNGP14.phx.gbl...
>
|||Well I am assuming it's apples to apples. Either two single core procs or
one dual core proc and he stated the cache was the same. But after
re-reading it I am not sure what he said now.
Andrew J. Kelly SQL MVP
"Admiral Q" <Star_Fleet_Admiral_Q(No_Spam)@.(Spam_Not)hotmail.c om> wrote in
message news:uLE5EZxFGHA.3064@.TK2MSFTNGP10.phx.gbl...
> You may be surprised, as the Intel 2.8Ghz Dual Cores have 2x2MB of L2
> cache, no L3 cache and 800Mhz FSB, where the 3.4Ghz have only 1MB of L2
> cache, and up to 8MB L3 cache, it has only a maximum of 667Mhz FSB. In
> addition each of the Dual Core processors can be hyper-threaded, resulting
> in 8 Virtual CPU's versus only the 4 Virtual CPU's the 3.4Ghz will
> produce, thus handling twice as many threads simultaneously as the
> 3.4Ghz - and after all, the speed difference is only 600Mhz, only slightly
> faster than the first PIII's.
> --
> Star Fleet Admiral Q @. your service!
> Google is your friend!
> http://www.google.com
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uXO8yQsFGHA.2012@.TK2MSFTNGP14.phx.gbl...
>

Dual CPU w/Dual Core or single core with dual CPU

Hello everyone,
I am about to replace my current SQL server that is running a dual 1.2ghz
Itanium 64 cpu. We just hate the lack of support for the Itanium. We are
looking at a 2.8 dual core/dual cpu machine or a single core 3.4ghz dual cpu
machine. Which should perform the best for SQL server? Both machines have
2mb cache.
Thanks,
NickYou might want to look at the dual core AMD boxes. You can probably get 2
dual core CPU's for less than what you think and you can run SQL2005 64 bit
edition on them.
Andrew J. Kelly SQL MVP
"Nick" <nsocha@.prodigy.net> wrote in message
news:uMnG3ckFGHA.2064@.TK2MSFTNGP09.phx.gbl...
> Hello everyone,
> I am about to replace my current SQL server that is running a dual 1.2ghz
> Itanium 64 cpu. We just hate the lack of support for the Itanium. We are
> looking at a 2.8 dual core/dual cpu machine or a single core 3.4ghz dual
> cpu machine. Which should perform the best for SQL server? Both machines
> have 2mb cache.
> Thanks,
> Nick
>|||Thanks for the reply.
I have heard great things about the dual core AMD, but I am still wondering
if the 2.8 dual core/dual cpu will outperform a single core /dual cpu 3.4'
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23OR3QsrFGHA.4036@.TK2MSFTNGP12.phx.gbl...
> You might want to look at the dual core AMD boxes. You can probably get 2
> dual core CPU's for less than what you think and you can run SQL2005 64
> bit edition on them.
> --
> Andrew J. Kelly SQL MVP
>
> "Nick" <nsocha@.prodigy.net> wrote in message
> news:uMnG3ckFGHA.2064@.TK2MSFTNGP09.phx.gbl...
>|||Even though the dual cores are almost the same as two individual processors
there is a difference. Of coarse you would have to test under your exact
conditions but I would be very surprised if the 2.8GHZ processors (dual core
or dual procs) would perform as well as two 3.4GHZ ones. All other things
equal a faster proc will beat a slower one.
Andrew J. Kelly SQL MVP
"Nick" <nsocha@.prodigy.net> wrote in message
news:e3ORd7rFGHA.3684@.TK2MSFTNGP14.phx.gbl...
> Thanks for the reply.
> I have heard great things about the dual core AMD, but I am still
> wondering if the 2.8 dual core/dual cpu will outperform a single core
> /dual cpu 3.4'
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%23OR3QsrFGHA.4036@.TK2MSFTNGP12.phx.gbl...
>|||Thanks for the replies. I am leaning towards the 3.4 single cores.
Nick
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uXO8yQsFGHA.2012@.TK2MSFTNGP14.phx.gbl...
> Even though the dual cores are almost the same as two individual
> processors there is a difference. Of coarse you would have to test under
> your exact conditions but I would be very surprised if the 2.8GHZ
> processors (dual core or dual procs) would perform as well as two 3.4GHZ
> ones. All other things equal a faster proc will beat a slower one.
> --
> Andrew J. Kelly SQL MVP
>
> "Nick" <nsocha@.prodigy.net> wrote in message
> news:e3ORd7rFGHA.3684@.TK2MSFTNGP14.phx.gbl...
>|||Are you queries compute intensive? Is your CPU a bottleneck? There is no
way to answer this as a generic configuration. It all depends upon what you
are doing on the system. Just because a processor is dual core doesn't mean
you get the equivalent of 2 processors. You get more processing capacity on
a single die, but it doesn't double.
"Nick" <nsocha@.prodigy.net> wrote in message
news:uMnG3ckFGHA.2064@.TK2MSFTNGP09.phx.gbl...
> Hello everyone,
> I am about to replace my current SQL server that is running a dual 1.2ghz
> Itanium 64 cpu. We just hate the lack of support for the Itanium. We are
> looking at a 2.8 dual core/dual cpu machine or a single core 3.4ghz dual
> cpu machine. Which should perform the best for SQL server? Both machines
> have 2mb cache.
> Thanks,
> Nick
>|||Nick wrote:
> Hello everyone,
> I am about to replace my current SQL server that is running a dual 1.2ghz
> Itanium 64 cpu. We just hate the lack of support for the Itanium. We are
> looking at a 2.8 dual core/dual cpu machine or a single core 3.4ghz dual c
pu
> machine. Which should perform the best for SQL server? Both machines have
> 2mb cache.
you need to look at your machines usage. the 2 slower dual cores will
give you 4 processors instead of 2. the 2 additional processors might
benefit your system or, as in my case, could seriously degrade
performance of parallel queries. i went from dual cpu to dual
hyperthreaded cpu's and had to limit queries to 1 processor because a
few parallel queries ran much slower on the 4 faster processors than the
2 slower processors.|||Nick,
I am a little confused now as to what you originally meant.

Is the 2.8 two dual core procs or a single dual core proc? If it is indeed
two dual cores then you basically have 4 processors vs the two of the
3.4GHZ. So that would probably be my choice if you have multiple concurrent
users or lots of parallel queries.
Andrew J. Kelly SQL MVP
"Nick" <nsocha@.prodigy.net> wrote in message
news:OCIDZRtFGHA.1396@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Thanks for the replies. I am leaning towards the 3.4 single cores.
> Nick
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uXO8yQsFGHA.2012@.TK2MSFTNGP14.phx.gbl...
>|||You may be surprised, as the Intel 2.8Ghz Dual Cores have 2x2MB of L2 cache,
no L3 cache and 800Mhz FSB, where the 3.4Ghz have only 1MB of L2 cache, and
up to 8MB L3 cache, it has only a maximum of 667Mhz FSB. In addition each
of the Dual Core processors can be hyper-threaded, resulting in 8 Virtual
CPU's versus only the 4 Virtual CPU's the 3.4Ghz will produce, thus handling
twice as many threads simultaneously as the 3.4Ghz - and after all, the
speed difference is only 600Mhz, only slightly faster than the first PIII's.
Star Fleet Admiral Q @. your service!
Google is your friend!
http://www.google.com
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uXO8yQsFGHA.2012@.TK2MSFTNGP14.phx.gbl...
> Even though the dual cores are almost the same as two individual
> processors there is a difference. Of coarse you would have to test under
> your exact conditions but I would be very surprised if the 2.8GHZ
> processors (dual core or dual procs) would perform as well as two 3.4GHZ
> ones. All other things equal a faster proc will beat a slower one.
> --
> Andrew J. Kelly SQL MVP
>
> "Nick" <nsocha@.prodigy.net> wrote in message
> news:e3ORd7rFGHA.3684@.TK2MSFTNGP14.phx.gbl...
>|||Well I am assuming it's apples to apples. Either two single core procs or
one dual core proc and he stated the cache was the same. But after
re-reading it I am not sure what he said now.
Andrew J. Kelly SQL MVP
"Admiral Q" < Star_Fleet_Admiral_Q(No_Spam)@.(Spam_Not)
hotmail.com> wrote in
message news:uLE5EZxFGHA.3064@.TK2MSFTNGP10.phx.gbl...
> You may be surprised, as the Intel 2.8Ghz Dual Cores have 2x2MB of L2
> cache, no L3 cache and 800Mhz FSB, where the 3.4Ghz have only 1MB of L2
> cache, and up to 8MB L3 cache, it has only a maximum of 667Mhz FSB. In
> addition each of the Dual Core processors can be hyper-threaded, resulting
> in 8 Virtual CPU's versus only the 4 Virtual CPU's the 3.4Ghz will
> produce, thus handling twice as many threads simultaneously as the
> 3.4Ghz - and after all, the speed difference is only 600Mhz, only slightly
> faster than the first PIII's.
> --
> Star Fleet Admiral Q @. your service!
> Google is your friend!
> http://www.google.com
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uXO8yQsFGHA.2012@.TK2MSFTNGP14.phx.gbl...
>

Dual CPU w/Dual Core or single core with dual CPU

Hello everyone,
I am about to replace my current SQL server that is running a dual 1.2ghz
Itanium 64 cpu. We just hate the lack of support for the Itanium. We are
looking at a 2.8 dual core/dual cpu machine or a single core 3.4ghz dual cpu
machine. Which should perform the best for SQL server? Both machines have
2mb cache.
Thanks,
NickYou might want to look at the dual core AMD boxes. You can probably get 2
dual core CPU's for less than what you think and you can run SQL2005 64 bit
edition on them.
--
Andrew J. Kelly SQL MVP
"Nick" <nsocha@.prodigy.net> wrote in message
news:uMnG3ckFGHA.2064@.TK2MSFTNGP09.phx.gbl...
> Hello everyone,
> I am about to replace my current SQL server that is running a dual 1.2ghz
> Itanium 64 cpu. We just hate the lack of support for the Itanium. We are
> looking at a 2.8 dual core/dual cpu machine or a single core 3.4ghz dual
> cpu machine. Which should perform the best for SQL server? Both machines
> have 2mb cache.
> Thanks,
> Nick
>|||Thanks for the reply.
I have heard great things about the dual core AMD, but I am still wondering
if the 2.8 dual core/dual cpu will outperform a single core /dual cpu 3.4'
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23OR3QsrFGHA.4036@.TK2MSFTNGP12.phx.gbl...
> You might want to look at the dual core AMD boxes. You can probably get 2
> dual core CPU's for less than what you think and you can run SQL2005 64
> bit edition on them.
> --
> Andrew J. Kelly SQL MVP
>
> "Nick" <nsocha@.prodigy.net> wrote in message
> news:uMnG3ckFGHA.2064@.TK2MSFTNGP09.phx.gbl...
>> Hello everyone,
>> I am about to replace my current SQL server that is running a dual 1.2ghz
>> Itanium 64 cpu. We just hate the lack of support for the Itanium. We are
>> looking at a 2.8 dual core/dual cpu machine or a single core 3.4ghz dual
>> cpu machine. Which should perform the best for SQL server? Both machines
>> have 2mb cache.
>> Thanks,
>> Nick
>|||Even though the dual cores are almost the same as two individual processors
there is a difference. Of coarse you would have to test under your exact
conditions but I would be very surprised if the 2.8GHZ processors (dual core
or dual procs) would perform as well as two 3.4GHZ ones. All other things
equal a faster proc will beat a slower one.
--
Andrew J. Kelly SQL MVP
"Nick" <nsocha@.prodigy.net> wrote in message
news:e3ORd7rFGHA.3684@.TK2MSFTNGP14.phx.gbl...
> Thanks for the reply.
> I have heard great things about the dual core AMD, but I am still
> wondering if the 2.8 dual core/dual cpu will outperform a single core
> /dual cpu 3.4'
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%23OR3QsrFGHA.4036@.TK2MSFTNGP12.phx.gbl...
>> You might want to look at the dual core AMD boxes. You can probably get 2
>> dual core CPU's for less than what you think and you can run SQL2005 64
>> bit edition on them.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Nick" <nsocha@.prodigy.net> wrote in message
>> news:uMnG3ckFGHA.2064@.TK2MSFTNGP09.phx.gbl...
>> Hello everyone,
>> I am about to replace my current SQL server that is running a dual
>> 1.2ghz Itanium 64 cpu. We just hate the lack of support for the Itanium.
>> We are looking at a 2.8 dual core/dual cpu machine or a single core
>> 3.4ghz dual cpu machine. Which should perform the best for SQL server?
>> Both machines have 2mb cache.
>> Thanks,
>> Nick
>>
>|||Thanks for the replies. I am leaning towards the 3.4 single cores.
Nick
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uXO8yQsFGHA.2012@.TK2MSFTNGP14.phx.gbl...
> Even though the dual cores are almost the same as two individual
> processors there is a difference. Of coarse you would have to test under
> your exact conditions but I would be very surprised if the 2.8GHZ
> processors (dual core or dual procs) would perform as well as two 3.4GHZ
> ones. All other things equal a faster proc will beat a slower one.
> --
> Andrew J. Kelly SQL MVP
>
> "Nick" <nsocha@.prodigy.net> wrote in message
> news:e3ORd7rFGHA.3684@.TK2MSFTNGP14.phx.gbl...
>> Thanks for the reply.
>> I have heard great things about the dual core AMD, but I am still
>> wondering if the 2.8 dual core/dual cpu will outperform a single core
>> /dual cpu 3.4'
>> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>> news:%23OR3QsrFGHA.4036@.TK2MSFTNGP12.phx.gbl...
>> You might want to look at the dual core AMD boxes. You can probably get
>> 2 dual core CPU's for less than what you think and you can run SQL2005
>> 64 bit edition on them.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Nick" <nsocha@.prodigy.net> wrote in message
>> news:uMnG3ckFGHA.2064@.TK2MSFTNGP09.phx.gbl...
>> Hello everyone,
>> I am about to replace my current SQL server that is running a dual
>> 1.2ghz Itanium 64 cpu. We just hate the lack of support for the
>> Itanium. We are looking at a 2.8 dual core/dual cpu machine or a single
>> core 3.4ghz dual cpu machine. Which should perform the best for SQL
>> server? Both machines have 2mb cache.
>> Thanks,
>> Nick
>>
>>
>|||Are you queries compute intensive? Is your CPU a bottleneck? There is no
way to answer this as a generic configuration. It all depends upon what you
are doing on the system. Just because a processor is dual core doesn't mean
you get the equivalent of 2 processors. You get more processing capacity on
a single die, but it doesn't double.
"Nick" <nsocha@.prodigy.net> wrote in message
news:uMnG3ckFGHA.2064@.TK2MSFTNGP09.phx.gbl...
> Hello everyone,
> I am about to replace my current SQL server that is running a dual 1.2ghz
> Itanium 64 cpu. We just hate the lack of support for the Itanium. We are
> looking at a 2.8 dual core/dual cpu machine or a single core 3.4ghz dual
> cpu machine. Which should perform the best for SQL server? Both machines
> have 2mb cache.
> Thanks,
> Nick
>|||Nick wrote:
> Hello everyone,
> I am about to replace my current SQL server that is running a dual 1.2ghz
> Itanium 64 cpu. We just hate the lack of support for the Itanium. We are
> looking at a 2.8 dual core/dual cpu machine or a single core 3.4ghz dual cpu
> machine. Which should perform the best for SQL server? Both machines have
> 2mb cache.
you need to look at your machines usage. the 2 slower dual cores will
give you 4 processors instead of 2. the 2 additional processors might
benefit your system or, as in my case, could seriously degrade
performance of parallel queries. i went from dual cpu to dual
hyperthreaded cpu's and had to limit queries to 1 processor because a
few parallel queries ran much slower on the 4 faster processors than the
2 slower processors.|||Nick,
I am a little confused now as to what you originally meant.
>> Itanium. We are looking at a 2.8 dual core/dual cpu machine or a
>> single core 3.4ghz dual cpu machine. Which should perform the best for
>> SQL
Is the 2.8 two dual core procs or a single dual core proc? If it is indeed
two dual cores then you basically have 4 processors vs the two of the
3.4GHZ. So that would probably be my choice if you have multiple concurrent
users or lots of parallel queries.
--
Andrew J. Kelly SQL MVP
"Nick" <nsocha@.prodigy.net> wrote in message
news:OCIDZRtFGHA.1396@.TK2MSFTNGP11.phx.gbl...
> Thanks for the replies. I am leaning towards the 3.4 single cores.
> Nick
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uXO8yQsFGHA.2012@.TK2MSFTNGP14.phx.gbl...
>> Even though the dual cores are almost the same as two individual
>> processors there is a difference. Of coarse you would have to test under
>> your exact conditions but I would be very surprised if the 2.8GHZ
>> processors (dual core or dual procs) would perform as well as two 3.4GHZ
>> ones. All other things equal a faster proc will beat a slower one.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Nick" <nsocha@.prodigy.net> wrote in message
>> news:e3ORd7rFGHA.3684@.TK2MSFTNGP14.phx.gbl...
>> Thanks for the reply.
>> I have heard great things about the dual core AMD, but I am still
>> wondering if the 2.8 dual core/dual cpu will outperform a single core
>> /dual cpu 3.4'
>> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>> news:%23OR3QsrFGHA.4036@.TK2MSFTNGP12.phx.gbl...
>> You might want to look at the dual core AMD boxes. You can probably get
>> 2 dual core CPU's for less than what you think and you can run SQL2005
>> 64 bit edition on them.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Nick" <nsocha@.prodigy.net> wrote in message
>> news:uMnG3ckFGHA.2064@.TK2MSFTNGP09.phx.gbl...
>> Hello everyone,
>> I am about to replace my current SQL server that is running a dual
>> 1.2ghz Itanium 64 cpu. We just hate the lack of support for the
>> Itanium. We are looking at a 2.8 dual core/dual cpu machine or a
>> single core 3.4ghz dual cpu machine. Which should perform the best for
>> SQL server? Both machines have 2mb cache.
>> Thanks,
>> Nick
>>
>>
>>
>|||You may be surprised, as the Intel 2.8Ghz Dual Cores have 2x2MB of L2 cache,
no L3 cache and 800Mhz FSB, where the 3.4Ghz have only 1MB of L2 cache, and
up to 8MB L3 cache, it has only a maximum of 667Mhz FSB. In addition each
of the Dual Core processors can be hyper-threaded, resulting in 8 Virtual
CPU's versus only the 4 Virtual CPU's the 3.4Ghz will produce, thus handling
twice as many threads simultaneously as the 3.4Ghz - and after all, the
speed difference is only 600Mhz, only slightly faster than the first PIII's.
--
Star Fleet Admiral Q @. your service!
Google is your friend!
http://www.google.com
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uXO8yQsFGHA.2012@.TK2MSFTNGP14.phx.gbl...
> Even though the dual cores are almost the same as two individual
> processors there is a difference. Of coarse you would have to test under
> your exact conditions but I would be very surprised if the 2.8GHZ
> processors (dual core or dual procs) would perform as well as two 3.4GHZ
> ones. All other things equal a faster proc will beat a slower one.
> --
> Andrew J. Kelly SQL MVP
>
> "Nick" <nsocha@.prodigy.net> wrote in message
> news:e3ORd7rFGHA.3684@.TK2MSFTNGP14.phx.gbl...
>> Thanks for the reply.
>> I have heard great things about the dual core AMD, but I am still
>> wondering if the 2.8 dual core/dual cpu will outperform a single core
>> /dual cpu 3.4'
>> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>> news:%23OR3QsrFGHA.4036@.TK2MSFTNGP12.phx.gbl...
>> You might want to look at the dual core AMD boxes. You can probably get
>> 2 dual core CPU's for less than what you think and you can run SQL2005
>> 64 bit edition on them.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Nick" <nsocha@.prodigy.net> wrote in message
>> news:uMnG3ckFGHA.2064@.TK2MSFTNGP09.phx.gbl...
>> Hello everyone,
>> I am about to replace my current SQL server that is running a dual
>> 1.2ghz Itanium 64 cpu. We just hate the lack of support for the
>> Itanium. We are looking at a 2.8 dual core/dual cpu machine or a single
>> core 3.4ghz dual cpu machine. Which should perform the best for SQL
>> server? Both machines have 2mb cache.
>> Thanks,
>> Nick
>>
>>
>|||Well I am assuming it's apples to apples. Either two single core procs or
one dual core proc and he stated the cache was the same. But after
re-reading it I am not sure what he said now.
--
Andrew J. Kelly SQL MVP
"Admiral Q" <Star_Fleet_Admiral_Q(No_Spam)@.(Spam_Not)hotmail.com> wrote in
message news:uLE5EZxFGHA.3064@.TK2MSFTNGP10.phx.gbl...
> You may be surprised, as the Intel 2.8Ghz Dual Cores have 2x2MB of L2
> cache, no L3 cache and 800Mhz FSB, where the 3.4Ghz have only 1MB of L2
> cache, and up to 8MB L3 cache, it has only a maximum of 667Mhz FSB. In
> addition each of the Dual Core processors can be hyper-threaded, resulting
> in 8 Virtual CPU's versus only the 4 Virtual CPU's the 3.4Ghz will
> produce, thus handling twice as many threads simultaneously as the
> 3.4Ghz - and after all, the speed difference is only 600Mhz, only slightly
> faster than the first PIII's.
> --
> Star Fleet Admiral Q @. your service!
> Google is your friend!
> http://www.google.com
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uXO8yQsFGHA.2012@.TK2MSFTNGP14.phx.gbl...
>> Even though the dual cores are almost the same as two individual
>> processors there is a difference. Of coarse you would have to test under
>> your exact conditions but I would be very surprised if the 2.8GHZ
>> processors (dual core or dual procs) would perform as well as two 3.4GHZ
>> ones. All other things equal a faster proc will beat a slower one.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Nick" <nsocha@.prodigy.net> wrote in message
>> news:e3ORd7rFGHA.3684@.TK2MSFTNGP14.phx.gbl...
>> Thanks for the reply.
>> I have heard great things about the dual core AMD, but I am still
>> wondering if the 2.8 dual core/dual cpu will outperform a single core
>> /dual cpu 3.4'
>> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>> news:%23OR3QsrFGHA.4036@.TK2MSFTNGP12.phx.gbl...
>> You might want to look at the dual core AMD boxes. You can probably get
>> 2 dual core CPU's for less than what you think and you can run SQL2005
>> 64 bit edition on them.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Nick" <nsocha@.prodigy.net> wrote in message
>> news:uMnG3ckFGHA.2064@.TK2MSFTNGP09.phx.gbl...
>> Hello everyone,
>> I am about to replace my current SQL server that is running a dual
>> 1.2ghz Itanium 64 cpu. We just hate the lack of support for the
>> Itanium. We are looking at a 2.8 dual core/dual cpu machine or a
>> single core 3.4ghz dual cpu machine. Which should perform the best for
>> SQL server? Both machines have 2mb cache.
>> Thanks,
>> Nick
>>
>>
>>
>|||HI Guys,
to clarify, I am looking at either a machine running 2.8ghz, with both Dual
Core as well as Dual CPU (so 2 Dual CORE cpu's) OR just a regular Dual CPU
setup with 3.8ghz XEONS
Both systems have 800mhz frontside bus and 2MB of cache.
My original message said I was looking at a 3.4ghz machine but I have now
changed that to a 3.8.....
I have read conflicting stories of which is better. I do not think my
application will really take advantage of dual core.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23ucQN9yFGHA.3532@.TK2MSFTNGP14.phx.gbl...
> Well I am assuming it's apples to apples. Either two single core procs or
> one dual core proc and he stated the cache was the same. But after
> re-reading it I am not sure what he said now.
> --
> Andrew J. Kelly SQL MVP
>
> "Admiral Q" <Star_Fleet_Admiral_Q(No_Spam)@.(Spam_Not)hotmail.com> wrote in
> message news:uLE5EZxFGHA.3064@.TK2MSFTNGP10.phx.gbl...
>> You may be surprised, as the Intel 2.8Ghz Dual Cores have 2x2MB of L2
>> cache, no L3 cache and 800Mhz FSB, where the 3.4Ghz have only 1MB of L2
>> cache, and up to 8MB L3 cache, it has only a maximum of 667Mhz FSB. In
>> addition each of the Dual Core processors can be hyper-threaded,
>> resulting in 8 Virtual CPU's versus only the 4 Virtual CPU's the 3.4Ghz
>> will produce, thus handling twice as many threads simultaneously as the
>> 3.4Ghz - and after all, the speed difference is only 600Mhz, only
>> slightly faster than the first PIII's.
>> --
>> Star Fleet Admiral Q @. your service!
>> Google is your friend!
>> http://www.google.com
>>
>> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>> news:uXO8yQsFGHA.2012@.TK2MSFTNGP14.phx.gbl...
>> Even though the dual cores are almost the same as two individual
>> processors there is a difference. Of coarse you would have to test
>> under your exact conditions but I would be very surprised if the 2.8GHZ
>> processors (dual core or dual procs) would perform as well as two 3.4GHZ
>> ones. All other things equal a faster proc will beat a slower one.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Nick" <nsocha@.prodigy.net> wrote in message
>> news:e3ORd7rFGHA.3684@.TK2MSFTNGP14.phx.gbl...
>> Thanks for the reply.
>> I have heard great things about the dual core AMD, but I am still
>> wondering if the 2.8 dual core/dual cpu will outperform a single core
>> /dual cpu 3.4'
>> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>> news:%23OR3QsrFGHA.4036@.TK2MSFTNGP12.phx.gbl...
>> You might want to look at the dual core AMD boxes. You can probably
>> get 2 dual core CPU's for less than what you think and you can run
>> SQL2005 64 bit edition on them.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Nick" <nsocha@.prodigy.net> wrote in message
>> news:uMnG3ckFGHA.2064@.TK2MSFTNGP09.phx.gbl...
>> Hello everyone,
>> I am about to replace my current SQL server that is running a dual
>> 1.2ghz Itanium 64 cpu. We just hate the lack of support for the
>> Itanium. We are looking at a 2.8 dual core/dual cpu machine or a
>> single core 3.4ghz dual cpu machine. Which should perform the best
>> for SQL server? Both machines have 2mb cache.
>> Thanks,
>> Nick
>>
>>
>>
>>
>|||HI Guys,
to clarify, I am looking at either a machine running 2.8ghz, with both Dual
Core as well as Dual CPU (so 2 Dual CORE cpu's) OR just a regular Dual CPU
setup with 3.8ghz XEONS
Both systems have 800mhz frontside bus and 2MB of cache.
My original message said I was looking at a 3.4ghz machine but I have now
changed that to a 3.8.....
I have read conflicting stories of which is better. I do not think my
application will really take advantage of dual core.
"ch" <ch@.dontemailme.com> wrote in message
news:43C5801B.189260D2@.dontemailme.com...
> Nick wrote:
>> Hello everyone,
>> I am about to replace my current SQL server that is running a dual 1.2ghz
>> Itanium 64 cpu. We just hate the lack of support for the Itanium. We are
>> looking at a 2.8 dual core/dual cpu machine or a single core 3.4ghz dual
>> cpu
>> machine. Which should perform the best for SQL server? Both machines have
>> 2mb cache.
>
> you need to look at your machines usage. the 2 slower dual cores will
> give you 4 processors instead of 2. the 2 additional processors might
> benefit your system or, as in my case, could seriously degrade
> performance of parallel queries. i went from dual cpu to dual
> hyperthreaded cpu's and had to limit queries to 1 processor because a
> few parallel queries ran much slower on the 4 faster processors than the
> 2 slower processors.|||Ok then what will your work load be like? If you have lots of concurrent
activity or lots of activity that can benefit from parallel processing the 4
procs (two dual cores) would most likely be better than the 2 single core
faster procs. But if it is only one or two concurrent users at a time and
they don't benefit much from parallel operations the faster procs may suite
you better.
--
Andrew J. Kelly SQL MVP
"Nick" <nsocha@.prodigy.net> wrote in message
news:uVHAb23FGHA.312@.TK2MSFTNGP09.phx.gbl...
> HI Guys,
> to clarify, I am looking at either a machine running 2.8ghz, with both
> Dual Core as well as Dual CPU (so 2 Dual CORE cpu's) OR just a regular
> Dual CPU setup with 3.8ghz XEONS
> Both systems have 800mhz frontside bus and 2MB of cache.
> My original message said I was looking at a 3.4ghz machine but I have now
> changed that to a 3.8.....
> I have read conflicting stories of which is better. I do not think my
> application will really take advantage of dual core.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%23ucQN9yFGHA.3532@.TK2MSFTNGP14.phx.gbl...
>> Well I am assuming it's apples to apples. Either two single core procs
>> or one dual core proc and he stated the cache was the same. But after
>> re-reading it I am not sure what he said now.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Admiral Q" <Star_Fleet_Admiral_Q(No_Spam)@.(Spam_Not)hotmail.com> wrote
>> in message news:uLE5EZxFGHA.3064@.TK2MSFTNGP10.phx.gbl...
>> You may be surprised, as the Intel 2.8Ghz Dual Cores have 2x2MB of L2
>> cache, no L3 cache and 800Mhz FSB, where the 3.4Ghz have only 1MB of L2
>> cache, and up to 8MB L3 cache, it has only a maximum of 667Mhz FSB. In
>> addition each of the Dual Core processors can be hyper-threaded,
>> resulting in 8 Virtual CPU's versus only the 4 Virtual CPU's the 3.4Ghz
>> will produce, thus handling twice as many threads simultaneously as the
>> 3.4Ghz - and after all, the speed difference is only 600Mhz, only
>> slightly faster than the first PIII's.
>> --
>> Star Fleet Admiral Q @. your service!
>> Google is your friend!
>> http://www.google.com
>>
>> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>> news:uXO8yQsFGHA.2012@.TK2MSFTNGP14.phx.gbl...
>> Even though the dual cores are almost the same as two individual
>> processors there is a difference. Of coarse you would have to test
>> under your exact conditions but I would be very surprised if the 2.8GHZ
>> processors (dual core or dual procs) would perform as well as two
>> 3.4GHZ ones. All other things equal a faster proc will beat a slower
>> one.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Nick" <nsocha@.prodigy.net> wrote in message
>> news:e3ORd7rFGHA.3684@.TK2MSFTNGP14.phx.gbl...
>> Thanks for the reply.
>> I have heard great things about the dual core AMD, but I am still
>> wondering if the 2.8 dual core/dual cpu will outperform a single core
>> /dual cpu 3.4'
>> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>> news:%23OR3QsrFGHA.4036@.TK2MSFTNGP12.phx.gbl...
>> You might want to look at the dual core AMD boxes. You can probably
>> get 2 dual core CPU's for less than what you think and you can run
>> SQL2005 64 bit edition on them.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Nick" <nsocha@.prodigy.net> wrote in message
>> news:uMnG3ckFGHA.2064@.TK2MSFTNGP09.phx.gbl...
>>> Hello everyone,
>>> I am about to replace my current SQL server that is running a dual
>>> 1.2ghz Itanium 64 cpu. We just hate the lack of support for the
>>> Itanium. We are looking at a 2.8 dual core/dual cpu machine or a
>>> single core 3.4ghz dual cpu machine. Which should perform the best
>>> for SQL server? Both machines have 2mb cache.
>>>
>>> Thanks,
>>> Nick
>>>
>>
>>
>>
>>
>>
>

Dual CPU Machine and SQL 7.0

We have a complex query that runs in 3-5 seconds on a single CPU machine. When we install the query on a Dual CPU machine, Optimizer selects a totally different execution plan that causes table scans and takes about 45 - 360 seconds to execute.
Any ideas on what to do?
ThanksWhen was the last time you updated statistics, re-built indexes and re-compiled your sps on the dual box?|||We have performed several analyses and traces on the system. We tore apart the Stored Procedure (and ended up re-assembling it the same way).

We dropped and rebuilt all indexes. Update Stats and recompile runs daily on all DBs.

We determined that on dual cpu machines, SQL Optimizer decides to use a bad Execution Path that includes Table Scans (thus the 30-40 minutes).

The data is the same across all the machines, as are the indexes, primary keys, security permissions etc.

We've eliminated flags/settings differences within SQL itself.

We eliminated the raid configuration as on single-cpu machines it runs on any raid config and won't run on dual-cpu any raid or non raid config.

When we pop out one of the CPUs, then the stored procedure runs in 3-5 seconds.|||I'm not quit sure that it's a because of a dual processor. Our development machine and UAT machine are single processors. Our Production and Reporting servers are dual processors and they created the same query plan as those on development and UAT. There is this one instance, about a month ago where a production stored procedure created a different query plan from development, UAT and the Reporting server. But there was one thing different and that was the Production server's indexes where created as CONTRAINTS, whereas on the other machines they where created with CREATE INDEX. The reason Production had to change was because transactional replication requires keys to be defined via PRIMARY KEY constraints. So to rectify the problem I coded tables in the FROM statement in the order of query optimization and adding the FORCE ORDER option.
This cleared up the problem. I never use HINTS or any of those FORCE options before, this is my first time. I'm not one to tamper with query plans, however in this one instance it helped.|||Thanks for the idea, but we have already tried the FORCE and hints options and Optimizer still overrides them. The data is the same across all the machines, as are the indexes, primary keys, security permissions etc.|||Dumb question here but is your hardware and os configured for one or two cpus?

I talked to one of our surver guys and he said you can't just reomve a cpu, reboot and expect NT to run properly.

In fact based on what you said I am wondering if NT was installed for one processor while the hardware is configured for 2 cpus!|||Thanks for the suggestion. We tried 2 different dual-cpu machines.

When configuring the machines both were wiped and WIN 2K SP2+ and SQL 7.0 SP3 were re-installed for a 2-cpu environment.

One machine (Dev) is AN HP LH4R w/Dual Pentium II Xeon 400 mhz CPUs. 2Ghz mem w/HP Netraid controller running a Raid 5 array.

The other machine (Production) is a IX Systems Tyan Motherboard Thunder model LES2510 with 2 Pentium III 1Ghz CPUs. Symbios SCSI Controller hooked to Infotran Raid Controller Model 3102 running Raid 5 array.

When the machines were taken back to 1 CPU, WIN 2K and SQL were again wiped and re-installed.|||Another "Is it Plugged in?" Question...

Are the settings correct for Paralellism in the 'Properties'
under your server in EM... Minimum query plan threshold setting...
defaults at 5 seconds (cost estimate)... for multi-CPU machines|||Hi all,

If the machine can be restarted - then boot to a single processor mode and run the tests...

just a shot...

take care
tony|||We have an sql application that runs perfecly on single processor machines. we recently installed on a dual processor capable server with only one Xeon 1.8 Ghz processor, windows2000 server. Suprisingly we find the sql performance has degraded dramatically( when compared to running it on 1 Ghz, single processpor)
I went through a number of message postings and detrmined that a number of other people have seen performace degradation or at least no increase in performance. Here are the links, the common thread is all of them have xeon processors

Wondering if this is a setup issue on the server or ....

http://216.239.33.100/search?q=cache:GokRMOJ5XtQC:dbforums.com/t363432.html+CONFIGURING+DUAL+PROCESSOR+SQL&hl=en&ie=UTF-8

http://webforums.sybase.com/nntp/nd000049.nsf/85255e6f0052055e85255d7f005ed8bc/dac80f4be40abe7352192d6d624343b1?OpenDocument

http://www.sqlmag.com/Forums/messageview.cfm?catid=5&threadid=4383

http://www.sqlmag.com/Forums/messageview.cfm?catid=5&threadid=5970

http://www.sqlmag.com/Forums/messageview.cfm?catid=5&threadid=4466

http://www.sqlmag.com/Forums/messageview.cfm?catid=22&threadid=3358

http://www.winnetmag.com/Forums/Application/Thread.cfm?CFID=19669352&CFTOKEN=65475496&CFApp=70&Thread_ID=88250|||We still haven't fixed the problem. We're currently trying different tests with setting the parallelism. I'll investigate the latest suggestions and incorporate them into our tests.

Thanks for all your help.

Dual CPU install

We have a new server with 2 CPU's but our SQL Server 2005 license is for a
single CPU. Do I have to buy a 2nd license or can I disable the setup to
only use 1 CPU? Any help on this is appreciated. Thank you.
DavidThe license states that if the edition is capable of using all the procs
then you need a license for it regardless of if you intend on using it or
not. However dual cores only count as 1 proc not two.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"David C" <dlchase@.lifetimeinc.com> wrote in message
news:%239UjrtYeIHA.288@.TK2MSFTNGP02.phx.gbl...
> We have a new server with 2 CPU's but our SQL Server 2005 license is for a
> single CPU. Do I have to buy a 2nd license or can I disable the setup to
> only use 1 CPU? Any help on this is appreciated. Thank you.
> David
>

Wednesday, March 7, 2012

Dual Core cpu performance improvment SQL Server 2005

Hi,

I'm trying to find an approximate percentage of what would be the performance gain of using a dual core CPU instead of a single core for a SQL Server 2005 dedicated server. I've been trying to find this information for may hours but could not get anything. Could someone give me a rough estimate please?

Thank you!

Maxim

I read somewhere that a 2 dual core processor machine roughly performs equal to a 3 single core processor machine. But, I didn't do any testing to validate it.

|||Thanks for your reply, but what I would like to know is what are the benefits (in %) of having a single core, single processor VS a dual core for SQL Server 2005.|||More CPUs is always better.

However, the dual cores are technically slower than the max single cores. For example, one 3.4mhz processor, might be faster for some things and one dual core 2.0mhz. But, overall for SQL more is always better, more CPUs, more memory, more/faster hard drives, etc.|||

Maxim,

A single, dual-core CPU is about 1.7 times better than a single, single-core processor. Two, single core processors are about 1.8 times better than one, single-core processor. SQL Server 2005 processor licensing goes by physical CPU, so having dual core CPUs is a free bonus from a licensing point of view. If the bean-counters are asking you to choose between a single, dual core and two single cores, the former wins.

It also depends on your workload. For an OLTP workload, or if you have MAXDOP set to 1, queries will run on a single processor, so you are better off with single fast processor rather than two slower processors. For a DSS or DW workload, multiple slower processors are often better.

Besides, if this is for a new server, its basically impossible to still buy single-core Xeons in the two-way space, although you can still get them for quad processor boxes.

|||You are using some abbreviations I'm not familiar with (sorry I mostly speak french...). Could you tell me what MAXDOP and DSS are? (DW = Data Warehouse I presume).

We intent on using this SQL Server for a Sharepoint portal. In what category would this be?

|||

MAXDOP stands for Max degree of parallism, it is a SQL Server setting that controls how many CPU's can be used in a query. DSS stands for decision support system. What it means in this context is that you have a database that does much more reads than writes.

I would guess that most Sharepoint databases would favor reads over writes. This would affect your indexing strategy. Also, if you have long-running, complex queries that might benefit from being "parallelized" (split between multiple CPU's), then this might affect your choice of which CPU's to get.

Friday, February 24, 2012

DTS: single SELECT from 2 databases possible?

Just wondering, in DTS, can I run a SELECT script that selects from 2 different databases (both on the same server)?

I can run this in Sql Query Analyzer, but in a DTS, it doesnt accept my database name prefixes:

SELECT
a.something
FROM
DB_ONE.dbo.product a, DB_ONE.dbo.mp_brand b, DB_TWO.dbo.lk_pcat_cutover c
WHERE
a.PCat <> c.Pcat

(where DB_ONE and DB_TWO are the 2 different db names)

I have one connection to DB_ONE... does this mean I cant access DB_TWO when using this connection? I want to try and avoid using a temporay table for storing DB_TWO's data in DB_ONE... Is this possible?

Thanks,

Andre

Dont know if this is the one and only answer, but by changing the datasource to the MASTER db, it then allows me to use my original SQL.

Friday, February 17, 2012

DTS w/dynamic source & query

I'm looking for a way to transform the contents of n source tables
into a single destination table. This by itself is no problem.

However, the name of the source tables change, so I'll need to base
the transform task on a global variable that I can update via external
code. Not sure how to do that. I'm ok with executing the package 10
times if there's 10 source tables.

The last unknown piece is modifying the query used for the transform.
There are 10 columns in the source table, but there are 12 columns in
the destination table. I must provide the 2 missing columns. They will
simply contain a year and month, ie. 05 2003.

I'm taking a bunch of source tables (for a given month and year) and
rolling them together into one destination table, and carrying over
the month and year. I assume the month and year would also be globals.
But I'm not sure how to incorporate them into the transform task since
it wants strict SQL syntax.

Any help is appreciated, thanks in advance!"znelson" <znelson@.hpis.net> wrote in message
news:f5fff72a.0405060627.796ea9cb@.posting.google.c om...
> I'm looking for a way to transform the contents of n source tables
> into a single destination table. This by itself is no problem.
> However, the name of the source tables change, so I'll need to base
> the transform task on a global variable that I can update via external
> code. Not sure how to do that. I'm ok with executing the package 10
> times if there's 10 source tables.
> The last unknown piece is modifying the query used for the transform.
> There are 10 columns in the source table, but there are 12 columns in
> the destination table. I must provide the 2 missing columns. They will
> simply contain a year and month, ie. 05 2003.
> I'm taking a bunch of source tables (for a given month and year) and
> rolling them together into one destination table, and carrying over
> the month and year. I assume the month and year would also be globals.
> But I'm not sure how to incorporate them into the transform task since
> it wants strict SQL syntax.
> Any help is appreciated, thanks in advance!

One way to pass in a global variable at runtime is as a parameter to
dtsrun.exe - you can use dtsrunui.exe to build a sample command line for
you, then parameterize it using your preferred language:

http://www.sqldts.com/default.aspx?301

This is useful when the number of parameters is fairly limited. An
alternative if you have many global variables is to put the values in a
database table or .INI file, and use a Dynamic Properties task to retrieve
them and assign them to the variables. This allows for more complex logic,
conditional values based on server name, AD site name etc. Finally, you can
assign global variable values directly in an ActiveX task.

As for how to pass in the month/year to an INSERT, these pages may be
useful:

http://www.sqldts.com/?234
http://www.sqldts.com/?205

Simon|||"Simon Hayes" <sql@.hayes.ch> wrote in message news:<409a6999$1_2@.news.bluewin.ch>...
> "znelson" <znelson@.hpis.net> wrote in message
> news:f5fff72a.0405060627.796ea9cb@.posting.google.c om...
> > I'm looking for a way to transform the contents of n source tables
> > into a single destination table. This by itself is no problem.
> > However, the name of the source tables change, so I'll need to base
> > the transform task on a global variable that I can update via external
> > code. Not sure how to do that. I'm ok with executing the package 10
> > times if there's 10 source tables.
> > The last unknown piece is modifying the query used for the transform.
> > There are 10 columns in the source table, but there are 12 columns in
> > the destination table. I must provide the 2 missing columns. They will
> > simply contain a year and month, ie. 05 2003.
> > I'm taking a bunch of source tables (for a given month and year) and
> > rolling them together into one destination table, and carrying over
> > the month and year. I assume the month and year would also be globals.
> > But I'm not sure how to incorporate them into the transform task since
> > it wants strict SQL syntax.
> > Any help is appreciated, thanks in advance!
> One way to pass in a global variable at runtime is as a parameter to
> dtsrun.exe - you can use dtsrunui.exe to build a sample command line for
> you, then parameterize it using your preferred language:
> http://www.sqldts.com/default.aspx?301
> This is useful when the number of parameters is fairly limited. An
> alternative if you have many global variables is to put the values in a
> database table or .INI file, and use a Dynamic Properties task to retrieve
> them and assign them to the variables. This allows for more complex logic,
> conditional values based on server name, AD site name etc. Finally, you can
> assign global variable values directly in an ActiveX task.
> As for how to pass in the month/year to an INSERT, these pages may be
> useful:
> http://www.sqldts.com/?234
> http://www.sqldts.com/?205
> Simon

Simon,

Thanks a lot, very helpful!