Google "sql number of rows in each table" and win.

Check out sys.indexes and sys.objects in Books Online. However, if you are on a developed system, you will probably be overwhelmed by a list of all indexes on all...

My understanding is that the index will be less efficient for data insertions/updates/deletions because the values of the included columns are stored at the leaf level, but a potential query...

Pretty sure that this will happen regardless of what you do if you want to return X in the table without having an index that covers all X columns you...

Yeah I'm not sure ... I didn't do a ton of research, just some quick Google lookups. I know there are other 3rd party driver providers though.

Your worst case...

DataDirect is a 3rd party so all their money is made off these drivers, which is why they're a bit pricey. There are also some other 3rd parties you...

lmu92 (6/2/2010)

---

The only thing I would change in bteraberry's solution is the split string function. I would use the DelimitedSplit8K function (search this site for the string) to avoid the...

And I should add that I'm testing against:

declare @vc_test varchar(100)

select @vc_test = '&ACCT=100&USER=Steve.Jones&PERIOD FROM=01/01/2010&PERIOD TO=05/01/2010&LEVEL=Detail&SORT BY ?=Date';

Now I'll say first off I'm sure there are more efficient ways to do this with tally tables, etc ... so if you're looking at a large amount of data...

richard.noordam (6/2/2010)

---

I'm having trouble with the following bit. I have a fairly complex set of case statments but the following is what I'm having trouble with (most inside portion)

...

a.shahnazi (6/1/2010)

---

Hi,

In SQL 2000, we could have a list of all indexes on a table at a glance.

How can I provide this in Management Studio ? I don't like...

What are you wanting to return?

As it is, when you SET @AcctNbr = '0269%*83970', everything is returning exactly as it should.

You should check this in your particular environment ...

I don't think you will see a difference in the execution plan between

with EMP_CTE(EMPID, NAME)

AS

(

SELECT EMPID,

NAME

...

I don't disagree with much of...

Yes, you can update your CID field if you want to. However, generally it's better to leave the data split into the first 3 columns and then do the...