The only way, really, to restrict the use of the statements you mention is via the security model in SQL Server. Just don't assign the users the permission to...

I would recommend using the Profiler method to see what's actually getting called. In addition though, you might want to consider using a grep program to sift through the...

quote:

---

However, you can use a clustered index to store in a sorted manner

---

To an extent...

I use surrogate keys almost exclusively when I have design control over a system.

I find that composite keys make it more difficult to get good performance out of a join....

Wow, thanks for looking that up Frank. I must have read that in my 6.5 days... 🙂

That explains why sometimes it works when I restort to using derived...

Maybe I'm dreaming this up, but I thought I had read somewhere that the query optimizer considers tables in groups of four, starting with how they are listed in the...

I use a similar trick to make sure I don't wind up with row after row of nulls. The only real difference is that after I paste it into...

I use WinRAR for pretty much any compression I need to do, but if you're looking for an archiver, you have to account for how slow WinRAR is. Zips...

Quick couple of notes:

Regarding locking... you generally don't have to worry a whole lot about this when working with ASP. Unless you're putting the connection and recordset object in...

Oh, and there's no problem with searching it. You just create some indexes that cover the struct_name, field_idx, and n_val or s_val fields. Searching is another reason I...

Something that no one has mentioned is that you could use a single table that looks something like:

create table legacy_struct (

struct_name varchar(255) , -- the...

Just to chime in on the UDF issue... I think they are amazingly cool, but should be used in select statements with great caution.

We were working on an application...

I don't think that the exam, by itself, really measures anything other than the determination require to study for the exam. I do think, however, that a professional looking...

Nice article, Mindy.

DirkFrazier, I think your solution is equivalent to Mindy's. The [value] field on the [sysproperties] table is a sql_variant type, so you could store just about anything...

Good article. Dynamic DTS is one of the areas I want to become more familiar with.

GoTroppo noted the use of INI files; I wanted to throw in my copper...