My mistake. I was confusing "with execute as owner", which doesn't use single-quotes, with the rules for "with execute as 'login'", which does require single-quotes. You'd want to...

I posted a simplified explanation of each. Hopefully it's neither too simplified nor not simplified enough. Hard to judge that sometimes in these cases.

They don't relate to the same thing. ASCII is a set of characters for computers. When you type on...

Of course, the real way to get this kind of thing from SQL is to use sets. Like this:

set nocount on;

create table #Numbers (

Number smallint identity primary key);

go

insert into...

If you want to put the images in the database, a CLR proc should be able to do that pretty easily. It would connect to the file (filesystem object...

GilaMonster (4/14/2009)

I saw it. I had a half-written, very snarky reply that I deided was better not posted....

I guess I don't see it that way. I've had to process millions of names (used to work for a couple of direct mail marketing companies) in mail lists,...

Todd, the problem with it is that a human being has to go through, row by row, and identify what format each name has, then record that somewhere so that...

Not that another vote of confidence is needed, but I'm going to add one anyway. Good intro to the subject, Barry. Certainly a lot less dry than many...

It will also depend on what recovery model your database is in. If you're in Simple, then batch-deletes probably won't cause it to grow much. If Full, then...

One thing that does sort of turn me off on this idea is an experience I had a few years ago. We were migrating a business-critical app from Access...

You're welcome.

Are you puting the username in single-quotes? If so, don't.

Ah. Makes sense. Thanks.

What do you mean by performance? Most of the time, that means speed, and you already said (correctly) that truncate is faster. So, what exactly do you mean?