That would be correct as part of a SELECT statement. CASE isn't a statement, it's an expression used within a query.

So

SELECT

CASE WHEN fmwa.GroupNbr<>'' THEN 'NO'

WHEN dind.DefaultIndicator='Y' THEN 'YES'

ELSE 'NO'

END AS...

Depending on the type of disaster, you may be able to take a tail-log backup (google or see BoL).

If you can, then your restore would be last full backup,...

You don't really optimise schemas, so not sure what you're asking. The Line Items table needs either normalisation or sensible column names, can't tell which.

As for the query, you can...

Look closer. That has SQL started in minimal config, which means TempDB...

Don't think you can use alter database to set a lower size than current. Unless someone went and explicitly grew the database ALTER DATABASE TempDB ... to set the files...

sql-lover (5/14/2013)

---

HanShi (5/14/2013)

---

No databases will go offline. It wil generate error level 17 messages stating "object xx can't be created in filegroup yy for database TempDB" and the transaction(s) will...

DO NOT shrink TempDB with DBCC ShrinkFile or DBCC ShrinkDatabase unless the instance (not the database) is running in single user mode, it is documented to be able to cause...

The clustered index IS the table.

But, my question stands, will the Alter Index...

About the only use is as part of a rolling upgrade, so install a second SQL instance (same version), configure mirroring, make sure everything works and the app redirects properly,...

Yes. If the OS requests SQL to reduce it's memory usage, SQL will do so, down to the value of min server memory.

Since you have locked pages enabled, SQL is using the physical alloc API to allocate memory for the buffer pool, that shows up as AWE memory (nothing to do with...

Tools -> Options. Environment -> General

Your master database is not missing, if it was SQL wouldn't even start.

It's in the system database folder under databases, along with model, msdb and tempDB

Read up on Log Shipping. Not that many other options on SQL 2000.

p.s. please post SQL 2000 questions in the SQL 2000 forums. Thanks

It is possible to have the mirror a higher version, but as I said it's a stupid thing to do and iirc it takes extra work to even set up...