Jack's right.

The table you asked about is where SQL Server tries to maintain the dependency chain between objects (although it doesn't do a great job at it). It's important...

wtipton (3/3/2008)

---

Howdy. I have a customer table rm00101 that has a field userdef2 that needs to be updated with the data in a response code field from a credit card...

I was just going to post the exact same link. Cool!

Oh come on, it'll have an effect. You're inserts will be faster because you're not maintaining a useless index.

😀

As everyone else has already pointed out, if you pass in brackets, you can make a table named almost anything, including [].

But, if we assume you either strip the brackets...

I definately recommend you NOT use a function for this type of query. It's a straight select statement. It should be done within a stored procedure or a parameterized query....

The function is probably presenting itself as (doing this from memory, so forgive me if I'm slightly off) a table scan or an external operation, but I think if you...

What does the execution plan look like?

I suspect, but this is a guess, you're getting an index scan and then a bookmark lookup to get to the data and then...

Again? Damn!

Me too. I haven't a clue where to begin with SSAS. I have done some SSIS, but I'm just barely functional, not competent. SSRS is probably going to become a...

A covering index is one in which all the columns needed by the query are contained within the index.

When you listed the row count and distinct value count, was that...

create (3/3/2008)

---

Thanks Grant

I didn't mention that I was working in vbscript so that was my mistake.

I must be missing something though because I am still not sure how we...

Sorry, I wasn't clear. I showed how to build the SQL string in TSQL. You're correct. To build an execution string in VB, you'd use the &.

However, as Roy mentioned...

You're preaching to the choir now. I have a name plate (made by my boss as a joke/award) that says "The Scary DBA" because I've lifted scalps in the past....

Oh, I just thought of another one you can do. When you suggest some change to schema or process that will improve up time or performanc and the developers baulk,...