Another very nice trick is that you can use the OUTPUT clause of an INSERT operation to get all of the ID's you just created, so it becomes easy to...

then try something like :

select

ref_no,

item_no,

sum(ee_amt) as ee_amount,

...

It was to give you an easy way to pass info between calling procedures. Because it's permanent - there's no visibility issue. Also - because it's indexed, the...

But it's now in the definition of what is being sold. In the case of the chairs - if you sell the chair to someone, and they use it...

Also - you will want to make sure you use the appropriate column ordering for it. The first ones mentioned should be the ones used in the joins and...

Frank Carrelli (12/18/2007)

---

Not to defend the RIAA but is it not the same when buying software designed for one OS and having to purchase another version ported to a different...

Jeff - it's a sequential file setup. look at the multiple segments (1 relates to the next "2" by previous.col3=current.col2).

You're going to need something more than physical order to...

Is the site prompting you to log in? Meaning - is anonymous access turned on in the Virt. Dir. settings? if it is - turn it off. ...

I was referring to the Data Developer track specifically, but there are several strains that might be of use as well (like the BI developer). From what I can...

You could also just look at firing the query once "just because" as SQL Server starts up....Especially if you increase the minimum RAM as Gila described earlier. wrap it...

Without the context in which you use that - it's going to be hard to know whether it will or not.

Would a query run faster without a case if it...

Wayne West (12/17/2007)

---

It depends on the version of SQL Server. Technically (I studied this earlier this year) if you're running SS 2000 Standard Edition, if I recall correctly you...

If you honestly think you have the skills and you're rusty in some areas, then hit the books, hard. Get back into the game as much as you can....

That's going to be difficult - SQL2005 only allows for 1024 columns (in 32-bit) or 4096 (in 64-bit) per table, and 4096 per select statement.

SQLBill (12/17/2007)

---

Here is a quote from the BOL:

Covered queries can improve performance. Covered queries are queries where all the columns specified in the query are contained within the same index....