You know, I'm glad there's no chance that I'll ever be involved at a company you're working at.

Tell me, what will you do if you have to demonstrate the skills...

What defines your ordering?

Please post SQL 2000 related questions in the SQL 2000 forums. Posting in the 2005 forums means you'll probably get answers that use SQL 2005-specific features.

If you're using SQL 2005, rather use the view sys.database_files. the statuses are given in text, no decoding necessary.

Could you post the code please?

Are you getting the error every time?

Are you using snapshot isolation level, or read committed snapshot isolation?

Is it possible that other queries are accessing the...

Use sp_executesql insead of EXECUTE. It allows you to pass variables in and out of dynamic SQL

books online has plenty examples

Indexed views are...

chandrachurhghosh (4/17/2008)

---

well....logically or functionally you can have n number of indexes at place for your database, but physically it depends upon how many copies of data you want to keep....

Isn't...

That is not true.

The definition of a heap is a table that does not have a clustered index, not a table with no index at all.

It is very possible...

Because the index is not covering and the table scan is cheaper

To do an index seek in this case requires 3 reads. 2 of the index tree and one of...

Lookup the ISNULL function. Should do what you want.

Then the interviewer is either wrong (the syntax is valid and works fine in sQL 2005) or he has something else in mind.

If someone told me that, I would...

If there's no cluster on the table, then the Rid (Row identifier) is the file ID, page number and slot index for the row.

I don't think there's any definitive...

I believe that's the partition_id.... Try this query in whatever DB has the ID 9

SELECT object_id, index_id from sys.partitions where partition_id = 72057594112638976

Why not?

CREATE TABLE [dbo].[TheTable](

[ID] [int] identity,

[TheName] [varchar](50) NULL

)

GO

insert into TheTable (TheName) Values ('Tom')

insert into TheTable (TheName) Values...

The first and the third are equivalent, though the first is using an older form of joins that is not recommended any more.

The 2nd and 3rd should be equivalent. The...