I think the answer is incomplete, the log file also contains the boot page:

One of the system pages stored in both the primary data file and the first log file...

I think the QOD is just fine. The default for these features is disabled - whether they are installed or not is a different question. Just my opinion.

I am not sure whether I agree with the solution to this QOD.

I think it actually might make sense to rebuild the indexes, especially since the table is heavily used.

Imagine...

I would also be interested in a resolution of this...

By BOL has the Version where the h switch is required.

Thanks!

Did you leave your database in 2k compatibility mode?

If yes, try switching to 90.

I am singing in the bathroom if that counts 😀

Besides that had some years of Classical Guitar training and still have a Virus at home http://www.access-music.de/products.php4?product=virusclassic. But haven't had much...

I dont have the exact requirements, but if you need only the customers you should be able to do something like this:

SELECT CUS.CustomerID

FROM T_CustHeader CUS

WHERE NOT EXISTS(

...

Hi,

you need to delimit your parameters with the percent sign.

Example:

: Run on dev

@ECHO OFF

set /p dbname=Enter dbname

osql -E -dmaster -Q "EXEC sp_helpdb @dbname = '%dbname%'"

PAUSE

Edit: Provided better example

What a nasty question... 😛

Is this standard SQL behaviour or just MS style?

Glad i could help 🙂

Thanks RBarryYoung for this 123 post long excursion into "Effects of unclear requirements in Software Engineering"

Your fantastic article that went live by now made me too curious and I have...

Awesome article.

And awesome technique.

And although "prohibited" in the article (a "Loop" is used), I cannot withstand to post another possible solution to this type of task:

[font="Courier New"]DECLARE @Current nvarchar(4000); --...

Finally found the source of confusion:

instead of

But the answer possibilities...

Hi Hugo,

This is a misunderstanding. What I meant to say was that when you open a static cursor, you have a point in time copy of the data as it...

I find this question a little confusing. It should be clearly stated in the question that you do not need to see updates made to the underlying data. Because that...