I have a question about the composite index.

Should a composite index be in the same order as it appears in the WHERE clause?

For example, the composite index is (address_id,...

AJ Ahrens, That Sql stmt doesnt' modify the schema of the table. It only updates the table just when you run that stmt.  My Question is how to modify the...

 Finally I found the formula I've forgotten: DateAdd(day,0,DateDiff(day,0,@DateVar))

...but I think using edwin_fredrick's way to cast it to varchar(11) is much more efficient ......

Happy Holidays,

Thanks all for your suggestions.

I find that using a global table to store sequences and using SP to get the NextKey from that table is the affordable solution...

Gabor, Thanks for your response. However, using Convert function with a defined style will query syslanguages table so there's a bit of I/O hit.

I got that info from somewhere in...

I can't use identity field since there's a business rule to reset the number to 0 for every new month.

It's a requirement to store the sequential number as it's part...

Hi Guys,

Thanks for the suggestions, now I come across an idea to use Disk Partitions instead of RAID. I try to put heavy transaction tables on different Hard disk partition....

Thanks Bard, That's what I'm looking for.

Hendry

noeld, the link you sent to me is broken. I got "Sorry, the page you requested is not available" from the site.

I'm still curious with that link...

Thanks,

Hendry

Thanks for that!

Hendry

Andy and Jonathan, Thanks for the suggestion. Both is really worthy for me. However, I have one more question. Why the uniqueidentifier is slower than other data type? Is that...

That's what I'm looking for.

Thanks a million,

Hendry

Hi Andy,

Thanks for the input. Anyway, Could you tell me how to Merge several XML docs, possibly using the .NET Framework. Any sample or web resource is Ok. I appreciate...

Thanks guys for the help. I learn alot here.

Cheers

Hendry

Great! It works.

Thanks very much.

Hendry