That's an immensely wide question. It's like asking which is better, a peppermint milkshake or an espresso.

Are you asking theoretically? Are you trying to decide for a project? What's the...

Why no good backup?

If checkDB with repair is not working, then your only remaining option is to script out the DB, bcp out what data you can (some won't export...

That's not because of the datalength needs to be multiplied by 2. It's because the /2 is outside the CASE statement but only applies to the ELSE portion of the...

@@identity will get you the identity value that you just inserted. MAX(ID) will get you the last value inserted. If multiple users cn be inserting at the same time, the...

I'll add one more to the list.

Disaster recovery

- Know how to fix corruption

- Know what to do when someone drops a table (though if you've done the security...

No.

You can detache and reattach the DB and it may get a different database ID, but no way to set which one it gets.

No, because datalength already takes unicode/non-unicode into account.

SELECT DATALENGTH('abc') returns 3

SELECT DATALENGTH(N'abc') returns 6, because it's a unicode string and hence requires 2 bytes/character

The problem with express is that it doesn't have SQL Agent and hence cannot run any of the replication jobs. I don't know if it's possible to run all of...

Somehow I don't think indexes are going to help. From what I can see, none of the conditions that may be in the where clause are sargable. All of the...

The recommended way to fix corruption is to restore a clean backup. Repair should be a last resort when there is no good backup available.

p.s. Rebuild your indexes after the...

As far as I know, only two of the TS exams are currently available (432 and 448) The third of the TS exams (433) is in beta. I think that...

DECLARE @MaxID INT

SELECT @MaxID = Max(ID) FROM Customer

Does the script you posted here (http://www.sqlservercentral.com/Forums/Topic581019-146-1.aspx) not work?

Replace sys.databases with sysdatabases. Replace sys.server_principals with syslogins and replace sys.database_principals with sysusers

Looks like the took the 'don't use distinct' to heart too. Guess they didn't realise that a group by with no aggregations does exactly the same thing