Well, if you look at what dbo.split is doing, it is basically creating a table variable using the values that you pass in.  Your concern is that your need to...

Where do the values in the INLIST come from?  You can build a derived table for your join without having to use dbo.split. 

Well, first of all, a database does not have to be in single user mode for a backup to take place.  Odds are, he is bringing the database into single...

Yes, another good suggestion.  I would also run a SQLDiag on the server.

"Buffer Cache Hit ratio is around 65% on average."

65% is much too small of a Buffer Cache Hit ratio.  You want this number to be consistantly above 90% and idealy...

Also, given the broad task of 'checking the box', I don't think you want to only capture SQL Profiler data.  I would also capture some Windows Performance Monitor metrics.  SQL...

Is this in a test environment?  I would set up a SQL Profiler trace.  Make sure you use the following events: SP:Starting, SP:Completed, SP:StmtStarting, SP:StmtCompleted, SQL:StmtStarting, SQL:StmtCompleted.  Also, in the Columns...

From BOL: "If EXPIREDATE or RETAINDAYS is not specified, expiration is determined by the media retention configuration setting of sp_configure. These options only prevent SQL Server from overwriting a file....

Make sure you use the EXPIREDATE or RETAINDAYS options in all of your backups.  WITH INIT will only overwrite the backup if it is expired or past the retention days...

Yes, right-click on the job and select Properties.  Go to the Schedules tab and click on Edit.  Press the change button.  Select the Monthly radio button.  Under the Monthly Section,...

You could place this one table in a filegroup so that it is in a different data file and use DBCC ShrinkFile on it.  While this may not normally be...

I would say that you need to size your tempdb back to where it was.  Whatever size your tempdb was before changing it, it got that way because it needed...

First off, you do not have to drop the column to drop the clustered index.  Since it is a clustered index /PK, use ALTER TABLE MyTable DROP CONSTRAINT PK_MyTable.  This...

We've not used SQL Server 2005 yet, but in 2000, you can move your non-clustered indexes into a filegroup and then place the physical files for that index filegroup on...

I have a couple of questions for you.  First, is there a reason why you would allow an application to drop/recreate the Primary Keys on all tables in your database? ...