Is the first versionn (the better one) missing INNER before the JOIN clause?

Whoa. syscolumns is a system table and I strongly recommend you do not update it. It might just break your database.

Hi Jan - I think it will. To check put your query in query analyzer and generate the expected execution plan. You should see index seek operations.

You could try something like this where 'a' is the column containing your data

select  SUBSTRING(a, (LEN(a) + 2 - CHARINDEX('=',REVERSE(a)) ),10), COUNT(a) AS Occurances from tblTest

where a like '%&track%'

group by...

You can also try the sp_MSforeachtable in master. I think i'ts undocumented but I've seen lots of posts that use it.

Hi Ralf,

Yep .760 is sp3 (or 3a). How are you getting your SQL AS version number. I open Analysis manager -> right mouse Analysis Servers -> About Analysis Services ->...

Hi Zaza - your script was fine - I think table is a reserved word so it needs square brackets around it. Also column names with spaces in them like...

Is that correct about fields in an OR statement not being SARG-able. I just tried it on a simple table and got an index seek.

Can anyone comment?

Is your device a disk or tape? If you have the space I would do it to disk.

If you are happy using SQL uin query anayzer try

BACKUP DATABASE <Your DB...

I think Zaza's script works fine with some small amends

SELECT a.ID,

 a.NAME,

 b.

,   -- Bracket reseerved word

 b.MEMO

FROM  SALE a LEFT OUTER JOIN MEMO b

ON  a.ID = b.RECORDID AND

LIKE 'SALE' ...

The similar data type in SQL is the bit datatype. It can hold the values 0, 1 or NULL (if NULLS allowed)

You can query it with

   where MyBit = '1'

   or...

I'm with Phill on this one. I always load data as raw as it comes and then transform it through stored procedures into tables where my users can look at...

I think in practice this is what SQL does through the Access Methods Manager and the Buffer Manager. Check the Cache Hit Ratio and you should see most (90 %...

I dont fully understand your table structure but I'm guessing you need somethiong like

WHERE ......

    AND TBQTY <= GDMIN

Is TBQTY an absolute value for the Item No or is it...

I understand you want to find how to build an in memory database for SQL server but SQL manages it's memory to keep as much data in memory as possible. Take...