Viewing 15 posts - 24,856 through 24,870 (of 26,490 total)
Based on what I have read regarding Microsofts licensing, nope. With that number of users, per processor is the best way to go.
😎
April 22, 2008 at 1:00 pm
Not really, substitute the pricing for EE (approx $25K per processor), or for Oracle (I don't even feel like computing that).
The key to deciding whether to purchase per processor or...
April 22, 2008 at 11:02 am
Microsoft goes by physical processor, not cores, so your server has 4 processors.
😎
April 22, 2008 at 9:52 am
CTE's have the disadvantage that they need to be used in the statement immediately after they are declared after which they disappear.
This is how they are designed to be used....
April 22, 2008 at 7:00 am
Microsoft doesn't use concurrent licensing anymore. The only options are per processor, user CAL's, or device CAL's. And, as was mentioned earlier, if you are using a middle...
April 22, 2008 at 6:52 am
Before I started evaluating HyperBac, I was using PKZip to zip up the DW dtabases (and I still use it at this time on our production PeopleSoft servers). Although...
April 22, 2008 at 6:36 am
I will say this about Hyperbac, they are a hands on company. I work in Colorado Springs (USA) and Hyperbac is in Melbourne (Australia). I have talked to...
April 21, 2008 at 10:43 pm
If you are going to look at litespeed, you should also consider RedGate SQL Backup and HyperBac's HyperBac.
😎
April 21, 2008 at 3:33 pm
Not to defend MS, but it could be an issue with the ODBC connector to MySQL. I have used the Import/Export wizard to pull data from other systems and...
April 21, 2008 at 2:29 pm
Can't help you with an ROI, but I'd also look at HyperBac from HyperBac. It was selected as the Editors Choice in the latest version of SQL Server magazine...
April 21, 2008 at 2:18 pm
insert into tablename (column list)
select column list
from ...
For more details look in BOL (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/1054c76e-0fd5-4131-8c07-a6c5d024af50.htm)
April 21, 2008 at 12:16 pm
If you have a lot of jobs running you will want to increase this: Maximum job history log size(in Rows): to something more that 1000 rows.
April 21, 2008 at 12:09 pm
Yes, there is, but I think that would be a good exercise for you to work on using the test code I initially provided along with the change for using...
April 21, 2008 at 10:52 am
My first question is what are you using the date for in the package?
April 21, 2008 at 8:36 am
Viewing 15 posts - 24,856 through 24,870 (of 26,490 total)