As a purist, I tend to avoid cursors. But, there are times when I find a cursor the better option.

Perhaps the biggest reason I will use a cursor is...

Good article - and some good comments. Nice to have a succinct summary of why you should use sp's or sometimes not. Yes there are times when dynamic...

If you just want the web cube structure used by the analysis service tool, go to this folder if you have the SQL2K version:

C:\Program Files\Microsoft Analysis Services\Help80\Data

I suggest...

If this works, it could be a good approach.

With out a better understanding of the requirements, its hard to offer a better approach.

Yes, complex business rule jobs often are best put on dedicated report layers, but in practice, I usually see the job falling to experienced SQL developers. These are guys &...

Contrary to popular belief, there are times when temporary tables, cursors, etc. are the best way to go.

Business Rule driven month end reports are often such an example. I've...

This sounds like a significant application architecture problem. First off, do your end-user clients really need immediate notification of all inserts and updates, what is the acceptable time lag,...

I think Andy is right on with his comment about industriousnous. And no employer or client that I would want to do work for, would rely soley on a cert.

I...

I'm using a my own DIY, that is based on the Simple Log shipping found in the 2K resource kit.

I needed a warm standby, already had Std, not Ent version...

For availability, has anyone looked at the hardware based redundant windows servers offered by Stratus? (http://www.stratus.com/)

No one recommends using software based RAID 5, and for this reason,...

Hey Steve,

I clicked on your book link (Transact-SQL)

and it took me to the Rudoldph Giuliani Leadership Book: Here is the link http://btob.barnesandnoble.com/home.asp?userid=6XGEFW0ANE&btob=Y

However, have to say that quite...

Steve,

Good idea.

I too like having printed material to review.

I stare at a computer monitor way to long.

Andrew

While cursors are best avoided in most situations, there are processes that benefit from a cusor. It is one of many tools that you can use, so don't be...

While we are on the topic of unicode, and

UTF-16/UCS-2 to UTF-8 conversion. Does anyone know where I can get some sample VB code to do the conversion. I...

And now back to Unicode.

SQL Server stores unicode in what is known as UTF-16/UCS-2 format, which is effectively a two-byte format. Most windows apps support this format. DTS only reads...