All or nothing from every test I took. No partials as this shows you don't fully know the material as far as the test is concerned.

As for why you are seeing the issues I am not sure. I have SP3 on 3 servers and not one has shown a change in working.

However for situation...

If they need to have a copy for testing they can install MSDE which has a few limitations but for the most part works just like the Full Engine versions...

Found it, check out http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fileio/base/file_compression_and_decompression.asp if the file is greater than 30GB it may not succeed in compression. And it goes into the compression format used.

Are we talking NT4 and early drive compression or the newer found in 2000 and later. I remember there being an article on MSDN about a change to this and...

If you fail you pay again and I believe you can fail the same test 2 or 3 times in a row before you have to wait a period of...

quote:

---

you can use "TRUNCATE TABLE mytable", which is in fact a DDL statement (*not* DML) and therefore not logged at all.

that means...

quote:

---

Hi Greg,

the 3 stars are the plus sign - for some reason the plus sign doesnt appear in my machine here...

and Antares'...

1 additional note I have found, sometimes the shrink database piece doesn't work with tempdb. But even if you have no SQL 2K machine using the SQL 2K EM on...

We originally were running Netop and tried PC-Duo and found TS/RA to be quite agreeable on memory in comparison. However, keep I would say mutiple TS/RA connections at the same...

This is the way I would normally go about it.

select sqPMT.*

FROM

(select *

from

(SELECT distinct machine_id from tblForum) as sqMchs

cross join

(select distinct product_key from tblForum) AS sqKeys) as sqPMT

LEFT JOIN

tblForum

ON

sqPMT.machine_id = tblForum.machine_id...

Tempdb is recreated to a default size defined in master not based on model (I believe it is the size value in sysaltfiles). However, it is not uncommon the file...

When testing make sure each run is done with clean buffers otherwise you are not really in the realm of apples to apples.

Use

DBCC FREEPROCCACHE

DBCC DROPCLEANBUFFERS

Or restart the SQL Server Service...

This can help partially, I need to update it so it can get all items without need to seperate so email me and I can send the update to you.

http://www.sqlservercentral.com/scripts/contributions/184.asp

Sorry...