You could use "not exists", until you compare query plans and execution time, and then you'd go back to using an OUTER JOIN...

🙂

You can't!

Profiler will suppress all text of events such as "sp_addlogin..." to prevent exposure of passwords etc.

It will also suppress the text if you are using "WITH ENCRYPTION" in your...

I was playing this morning with a SQL 2005 instance and I'd stopped the "SQL Service Broker" service and couldn't connect from my PC with a similar message.

A long shot, and...

If you have no common link column, then you cannot specify JOIN (INNER, OUTER, whatever).

And your request then makes no sense at all  - you have nothing to join on!

Is...

I would choose having all the databases on one default instance to reduce resource contention. It's easier than using "WITH MOVE" etc for restore or messing with SQL startup parameters.

It does...

sp_updatestat updates the statistics

It does not display or update space usage.

That's sp_spaceused, which can call that DBCC if you specify @updateusage as true

dbcc indexdefrag does not update statistics, whereas dbcc...

I'd be careful with the UDF - you may end up forcing a cursor implicitly, because it will be called for each output row. So if you scan a table...

Use this:

declare @newname varchar(56)

set @newname = 'table_' + convert(varchar(50), getdate(),112)

exec sp_rename 'table', @newname

Please, all databases, or just system databases?

A rollback would be done in reverse order to how they are in the transaction, so backward pointers make sense. You go backwards through the log records to roll back...

In C:\Program Files\Microsoft SQL Server\80\Tools\Binn, run rebuildm.exe.

For more info, read BOL.

The only gotcha mainly is when you browse for the mdf and ldf files... make sure they are not "read...

No probs.

In a previous life, there was a mix of enterprise and standard with the occasional multi-instance box...

Rudy: "It depends"

Std edition: Per-processor or Server/CAL makes difference

From MS site:

http://www.microsoft.com/sql/howtobuy/faq.mspx

Q. How does licensing work with the multi-instance feature in SQL Server 2000?

A. You can run multiple...

Even if you set AWE, it will be ignored by SQL if you less than 3GB RAM anyway (from BOL)

It happens for table variables as well.

Both temp tables and table variables are created in tempdb.

It only happens if you join or compare on text data.

*edit*

If you're being fancy, using...