It's Friday night, and I just can't help myself. I keep giggling when I see the title of this editorial because of this cheesy commercial that keeps playing in...

I don't know what constitutes "best" in this case - I'm pretty Peter's beats mine performance-wise.

That being said - thanks for the feedback!

Also - datetimes are already numeric (albeit float/double). I'd say the deficits outweigh any benefits (nothing like having to cast it to varchar first, then to datetime), just to...

Here here....

You buy dev "licenses" as CAL's. 10 developers = 10 developer editions = 10 *45$. If you have ten testers, throw 10 more in. It's still less...

If you're starting out with a table, why are you extracting the data to variables, and then inserting the variable back into another table?

what about

Insert table2

select id1, name, address from...

I think it all really comes down to - what is the business trying to "purchase"? In the days of yore when consultant = high-level expert, the relative COST...

Also - keep in mind that if it IS a virtual server - the hardware is actually being shared with other instances. Meaning - it's entirely possible that the...

Brandie - (I was actually agreeing with...

Brandie Tarvin (11/9/2007)

---

Or, if you have to sum the entirity of Col1 first, then create a second Temp table with a column that is the sum of the entirity of...

happycat59 (11/8/2007)

---

I am inclined towards mirroring. It is so much easier to manage and if you do wish to have automatic failover, that is just so easy to get...

Given that SQL server is essentially a large set processor, in my mind, no - there really aren't a lot of disadvantages. Or rather - since SQL is so...

hmm... several issues.

First - unless you plan on inserting the literal 'select jobname from job' (meaning - the STRING "'select jobname from job'") into every jobname, the syntax is wrong....

if you copy it directly from a CD - at times the RO flag is set on the file as well...

Also - the cheapest way to license a DEV/QA environment is to license each of the DEV users with SQL Server Develoiper EDITION (45$/seat or so). No server component...