First of all, there is no reason to insert the rows in any specific order. The rows in a table (or a set) does not have any specific order. They...

Ah ok, that explains it.

Well, like you might have noticed in DBCC MEMORYSTATUS second section you can see the minimum number of pages...

However if there is only a single INSERT, inserting multiple rows using a select statement, I do not think that this would be a problem. The rows would need to...

Well, it might of course turn out that I went too far when I said that "COUNT(*) and COUNT(1) will never return different results and will always use the same...

I, and I know a lot others, have April CTP installed and running on Virtual PC. I am running XP Professional in my VPC (and have also tried Win 2003),...

Yes, you are right in that the queries return different results. The reasons were also mentioned earlier in this thread and in my article. As noted the reason is that...

>If the first column is NOT NULL, COUNT(*) and COUNT(1) have the same result. If it's NULLable, the result may be different.

Could you elaborate on that please?

Afaik, DBCC MEMUSAGE shows the 20 objects that have the most pages cached in memory. So I am not sure how you found "The DBCC statement shows that free buffer...

Configuration options for SQL Server version 6.5 and 4.21 is not of much help here unfortunately.

Vidas, I have still not completely understood which...

Well, that depends on what you want/need to do. You should try to use the virtual tables in a set-based fashion. Cursors and/or procedural code with loops will hurt performance.

Which cache are we talking about here? Is it the cache of the hardware raidsystem, or SQL Server data cache??

Pages are always fetched from cache in SQL Server, if they...

Or you could add a computed column and use that in the index.

Yep, as you noted there used to be some config options in 6.5, but to my recollection they were mostly used to throttle the lazywriter (and log writer), not make...

Of course an application can use two or more databases. A database should never be "owned" by an application. That means going back to the pre-relational days of data management,...

The trigger fires once for the entire statement. Using the INSERTED and DELETED virtual tables you can get access to all the rows that where inserted/deleted or updated (using both...