Loved how they stated this with NT and never provided a tool, then 2000 hits and guess what built in defragmentor. Clue?

I remember somewhere someone stateing they can only use it with OPENQUERY.

I think there is a limitation in the ability to return UDF with table returns that prevents them. Or...

I agree with guarddata, the values are treated as floats until the end when they are implicitly converted to money. Floats is notorious for many issues and really should not...

Here is a nice little article from I believe our very own Brian Knight (bet he doesn't think we read his stuff)

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=15542

As for me, no experience but if you check...

Honestly I have no idea. I think that most want you to know the proper principals of normalization and when not to normalize. But the best way to find out...

The only thing I remember is you cannot apply any service pack to the evaluation version. Don't know about hot fixes but I believe they did not work as well....

See what you mean now. Looks like an incomplete feature. I find no way to get the details either.

There unfortunately is not a definitive answer. I would monitor cache hits, after every new time you make use of a table variable. If you notice a significant drop after...

Actually, Yes and No. The master database can be whereever you want to put it during the istall, SQL finds it via the reigstry entry made during install. As for...

Open your DTS Package in EM. Then double click each item in the package, they all have description fields, this is where that comes from. Also, if you have any...

Please keep question and answer in the same thread. See answer in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8170&FORUM_ID=5&CAT_ID=1&Topic_Title=found+my+answer&Forum_Title=Administration

Also, look at the details on filegrups, make regulare backups of this filegroup and you can restore it if lost. However, it will have to be restored to the same...

Please keep question and answer in the same thread. See question in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8169&FORUM_ID=5&CAT_ID=1&Topic_Title=adding+primary+key+to+converted+database&Forum_Title=Administration

RAID 0 is not redundant in anyway, you lose part of the set the whoel thing is gone.

As for creating mulitple files for a single filegroup, unless you have IDE...

Also, I don't understand your query, this should be the same.

DELETE FROM corpsys.dbo.organisation

WHERE last_updated_by = 'NTISImport'

Unless you have multiple items with orig_id then this may help a bit.

DELETE FROM...