Ryan Duckworth (11/25/2008)

---

Thank you for the quick reply.

The restore is actually done on a local drive.

The production server runs the backup and saves the backup file on the development server.

This...

One option you have without having to upgrade the hardware would be to restore from a local drive instead of across the network. My guess is that your network...

Well, first - your understanding is incorrect. Object are not created under the 'dbo' schema by default. Objects are going to be created (by default) in the users...

To add to what Lynn has stated - I will say that you need to look in Books Online for the subjects: CTE (Common Table Expression), Derived Tables and CASE....

SQL Server 2005 now has an option to verify that user passwords pass the policy settings for the system. My guess is that most of the passwords for the...

The problem you ran into has nothing to do with views or the use of views. The problem has to do with your understanding of how outer joins work.

In...

The recommendation should be to NOT shrink your data or log files on a regular basis as normal daily/weekly/monthly operations.

If you have an unusual event where either the data or...

Yes - that sounds right. I would verify whether or not I actually needed the ltrim - which you can do easily enough with a like statement checking for...

In SQL Server 2005 and greater, there is a default trace that is enabled. You can search the default trace for the creation, alter or deletion of an object.

The...

Are you sure that you need to upper case the username? This would only be required if the collation on the column or database is case sensitive. I...

You also need to verify that your client tools have been upgraded to the same version. If your client tools are not upgraded - you will see some issues...

craig (11/13/2008)

---

Makes sense. I just figured since the join clause is evaluated before the where clause it would be a good idea to do as much filtering as possible on...

You really shouldn't rely on auto grow to manage your database. The auto grow process is very expensive and can cause response time issues as the system waits for...

To answer your first question, you would JOIN the tables in your select query. By joining the tables, you now have access to all columns from both tables. ...

No problem - if you look at my query, you will see that I forgot to include the index name (oops).

The modified query is:

EXEC sp_msforeachdb 'Use ?;

INSERT INTO #Frag (

DBName,

TableName,

SchemaName,

IndexName,

AvgFragment

)

Select...