Faster than what?

The short answer is probably this: it uses its own compression algorithm that is more efficient than that in native backups.  The long answer?  Probably best...

Arshad

I'm not sure what he means by the metadata in the new binaries.  Everything that's in the database is backed up with the database.  Sure, there are some...

Arshad

I'm sure (s)he'll be able to explain why (s)he thinks that!  If it doesn't sound right to you, please post back here.

John

Yes - everything that is part of the database is backed up in a full database backup.  Is it really important, though?  It's easy enough to rebuild the statistics after...

I think such events are captured in the default trace, so you can query that.  If you want to store this information on an ongoing basis, you might prefer to...

Logins are in sys.server_principals; users are in sys.database_principals in each database.  You can join the two to find out which database users are orphaned and/or which logins don't have explicit...

Run the command exactly as Lowell posted.  You missed the hyphen out.

John

No, the table is dropped when the connection that created it finishes.  So if the code in question will be executed multiple times from the same connection then yes, you...

SELECT STUFF(STUFF(RIGHT('0' + '92332',6),5,0,':'),3,0,':')

John

This is a question that only you can answer, I think.  From here, it looks as if you enjoy the work, you enjoy the company and you're well paid, so...

Check the ExecutionLog table in Reporting Services to see how much of the time the report took to execute was query time and how much was rendering time.  Also check...

Yes, I noticed that as well.  It disturbs me a little, too.  I suppose only Ola knows the reason for it.  I have been known to go through the jobs...

I typed "function v stored procedure" into my favourite search engine and got a whole load of results.  You could do the same.

I'm not sure what your expert...

You're going to need a sysadmin to something for you, whether that's enabling ad hoc distributed queries, or setting up a linked server object.  There are other options, as long...

There's a hostname column in sysprocesses - have you looked at that?  You shouldn't be using sysprocesses at all, though - it's only provided for backwards compatibility with SQL Server...