I subscribe to SQL Server Magazine, and it is well worth the investment.

😎

Jeff, Only problem with that, what if they don't have the budget for Enterprise Edition? That puppy can get expensive at street prices, and most discounts that private industry...

Plus the cost of the Developer Edition is well worth the investment ($49 per developer).

As Matt also indicated, if you will not be deploying to Enterprise Edition, be sure to...

If its a staging table that is emptied and reloaded everytime, then I'm sorry but truncate would be faster.

What you may want to do is setup a seperate stage environment...

Jeff, the real killer in that process at my previous employer wasn't the cursor, but the data. About half of the processing time was a result of about 20...

When you say the lookup transformation failed, how did it fail? How were you trying to use it?

😎

I agree with Jeff. That's what I started doing at my last employer when I was trying to learn more about Analysis Services and OLAP cubes. I created...

Now for your other 2 questions.

Max number of columns: 1,024

Max number of rows: probably restricted by the amount of disk space available.

😎

I'll answer your third question right now. Don't use text, ntext, or image data types in SQL Server 2005. If converting a SQL Server 2000 data base to...

There is a side note to the cursor solution, each pass (a single record from the restrictions table) is applied to the inventory records in a set based fashion. ...

Well, unfortunately, I do know of a case where a cursor is the best option (at least at the time). Last employer we had a restrictions table for documents...

I have to agree with Jack. Use the correct data type for the correct data element. I agree, unless you really need to record the time of birth,...

Great!!

😎

Cursors may be evil, but they may be a necessary evil. Where possible use set based solutions, but sometimes you may find cursors are necessary, and therefore knowing how...

Jeff Moden (3/10/2008)

---

Lynn Pettis (3/10/2008)

---

Jeff, since the OP wants the end of the year wouldn't you want this:

SELECT @startdate = CAST('2007' AS DATETIME)

SELECT @enddate = DATEADD(yy,1,CAST('2007' AS DATETIME)) - 1

I...