I'll have to see that video to be sure of that.

You don't even my adress... you could try to get your lies together before telling them .

AS I said, one of so many .

How's that coin tossing coming Sushila??

If it is recreated or changed, then yes. I've never heard that about DBCC REINDEX.

HTH..

Now don't go deleting the Model db... You actually need this one (just in case it's actually doable without a warning).

Thanx govinn...

Are you sure there's a match for 883??

Just on a final note, pubs and northwind are there only for demo and testing purposes. But if you don't need them, you're better off deleting them from the...

Top n from X rank (only one of so many ways)

/*

Ivica Masar

pso@vip.hr

*/

USE pubs

DECLARE @var1 VARCHAR(12)

DECLARE @var2 VARCHAR(30)

SET ROWCOUNT 17

SELECT @var1 = au_id, @var2 = au_lname FROM authors ORDER BY au_lname,...

It's not obvious but it's there :

in insert / insert (description)

sorry for the french version but I don't ahve the books in english :

INSERT [ INTO]

...

Any reason why the record is not directly inserted in its final destination?

What error message are you getting when trying to remove it?

If you are speaking about reasons not to do it, then there's none... actually it's a best practice to remove...

Select max(CrDate) as SecondMax from dbo.SysObjects where CrDate not in (Select max(CrDate) from dbo.SysObjects)

HTH. Was fun (read a freaking pain in the @$$) to make that cumputed column indexable ... but still worth it

Could someone post the whole thing (create table, insert date and some test).. I'd like to save that somewhere for safekeeping... and actually understanding what's happening

Yup... getting tired here. Too many questions answered and not enough good sleep .