Paul

What login does SQL Server Agent use to connect to the database?  Does it have permission to execute DBCC SHRINKFILE?

John

That's helpful, but it's not a perfect analogy.  The very fact that you have to go to the page to get the data means that it isn't a covering index for the...

Davor

I can't think of any way of doing that server-side.  You'd need to configure your application to do that.

John

Anders

That'll probably be it, then.  A quick fumble in Books Online and I found this: "Scalar-valued functions must be invoked by using at least the two-part name of the function". ...

Davor

If you change the default schema of the calling user to dbo then you shouldn't need to qualify the name of the function.  Bear in mind that if the user...

One more thing in favour of separate instances is collation.  Although you can have different collations for each database (indeed you can specify collation down to the column level), if...

Carl

I'm not sure about using -c -m.  I've only tried it with -f.  See if that works for you.

John

Yes, or back up msdb2 and restore as msdb.  This has the advantage of avoiding stopping SQL Server (I think you can restore msdb without starting SQL Server with special...

Carl

The mssqlsystemresource database has to be moved to the same location as master, but it doesn't automatically get moved with it.  Start the server with the parameters /f /T3608, then...

Jan

Yes, but only the data in the indexed columns.  Going back to my example, if you wanted SELECT d, e, f FROM MyTable WHERE a = 10, the index would...

Jan

A covering index is a covering index with respect to a particular query.  So if your table contains columns a, b, c, d and f, and you have a non-clustered index...

Ganesh

Not sure how well this would perform, but one way of doing it would be to create a temp table with an identity column, say tempID.  Create an index on...

I think the DENSE_RANK function is what you're looking for.

John

Backup

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/89a4658a-62f1-4289-8982-f072229720a1.htm

Restore

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/877ecd57-3f2e-4237-890a-08f16e944ef1.htm

Andrew

This is tedious if you've pasted a lot of lines in, but it works.  At the end of each line, delete the carriage return and then hold down Shift and...