Viewing 15 posts - 46,876 through 46,890 (of 49,571 total)
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...
April 17, 2008 at 6:22 am
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.
April 17, 2008 at 6:13 am
If you're using SQL 2005, rather use the view sys.database_files. the statuses are given in text, no decoding necessary.
April 17, 2008 at 5:48 am
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...
April 17, 2008 at 5:46 am
Use sp_executesql insead of EXECUTE. It allows you to pass variables in and out of dynamic SQL
books online has plenty examples
April 17, 2008 at 4:33 am
chandrachurhghosh (4/17/2008)
Well, to support my opinion about storage and clustered index, try out the following....create a view with schema binding......then try to create a non-clustered index on it......
Indexed views are...
April 17, 2008 at 4:25 am
chandrachurhghosh (4/17/2008)
Isn't...
April 17, 2008 at 4:19 am
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...
April 17, 2008 at 2:45 am
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...
April 17, 2008 at 2:24 am
Lookup the ISNULL function. Should do what you want.
April 17, 2008 at 1:55 am
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...
April 17, 2008 at 1:52 am
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...
April 17, 2008 at 1:49 am
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
April 17, 2008 at 1:41 am
Ahmad Osama (4/17/2008)
Well..I think that we cant use CASE statement in update query..however,
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...
April 17, 2008 at 1:38 am
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...
April 17, 2008 at 1:33 am
Viewing 15 posts - 46,876 through 46,890 (of 49,571 total)