The situation is quite easy.

where Dogs='Y' AND Gardner='Y'

That kind of where clause will never use any index as the selectivity is very bad (there can be only Y and N...

Hey Steve,

That kind of situation is so typical for your country. And all this story is quite weel described in Ferenheit 9/11. Here the govenment's aim (and in this particular case use...

Could you give us the DDL (including all the indexes) as well as your query to see where your problem is located

Easy.

You have to install and configure the DB2 client on your SqlServer box. Then you can use it as an ODBC server. So you can use it as linked server...

Jules,

Merci. But I only have read only access to the database. So I ndd a select statement. CTE is OK as well

Colin,

Thanks for reply. But my problem is that my DB is very large and the number of tables are very high. Therefore running a dbcc showcontig for that purpose is...

Deadlocks and such things are important at operating level, but not at executive level.

What execs want to see is how business is going on, do they need to plan an...

Himalay,

You don't need to have an identity column to be able to use my virtual Lastkex idea. In your case Lastkey is composed of several columns. So you just have...

You have to rewrite you query by memorizing the last retrieved key.

So you could write your proc like this:

create proc S_page @lastkey int

as

select top 10 a, b, c

from table

where a > @lastkey...

Joan,

You have 2 possibilities:

Either you drop your existing clustered index and recreate a new one on f3, f4

or you create a covering index on f3, f4, f1, f2. This covering...

You can check the sysindexes table for the rowmodctr columns. It holds the data of the total number of inserted, deleted, or updated rows since the last time statistics were...

Basically if you are the administrator you can do what you want (this why the administrator id for )

Otherwise Andy's solution is a...

that's why I'm just drinking tee.... (and some good red wine)

Jeff,

I think you are mixing up 2 things reindexing (removing the fragmentation) and file or db shrinking (remiving the unused space from the and of the files

According to the BOL...

The question is not about formating the data.

If you have a varchar column of format mm/dd/yyyy then you have to use convert(datetime, DateCol, 101) or if you have a format...