You cannot make a dynamic view.

You can make the same view in every db and then call it with the 3 part naming (db.owner.view).

So I can create MyView in every...

It matters after a point. I'd say if you've never managed anything larger than 50GB, and you're asked to run a 500GB database, you might not be prepared.

At some point...

Are you sure you have exact copies? Data distribution matters as well. Perhaps increase the statistics sampling size?

I'm with Grant. Something has to be different.

Depends on production DBA, development DBA, etc.

Lots of debate on this:

http://www.sqlservercentral.com/articles/Administering/dbaroles/517/

http://www.sqlservercentral.com/articles/Administering/thevalueofadba/1806/

http://www.sqlservercentral.com/articles/State+of+the+Business/deathoftheproductiondba/432/

http://www.sqlservercentral.com/articles/Certifications/3176/

http://www.sqlservercentral.com/articles/Miscellaneous/2989/

To add to David...

With DTS you could deploy this to run from a workstation or other location (watch file paths) and distribute the load. It does not need to run...

The only way I know is to save them out as VB files and then check them with some editor.

I'm afraid this is probably a manual process for you to...

How did you move? Backup/restore? Statistics usually comes to mind here.

You can also use the DATENAME functions in SQL Server to get the name

The sp_dropserver/addserver doesn't work?

I'd be surprised as this is the same codebase as the Workgroup/Standard/Enterprise versions.

I agree with Jeff and highlight what you know, don't sweat what you don't. Show them you can learn and are willing to tackle any project. Show experiences from your...

select t1.name

from table1 t1

where t1.id not in (select id1

...

You get signals up in Alaska?

Surprisingly, no neighbor is within 1000 ft of my house, yet for some reason I see 2 other Routers appearing in my wireless network.

Maybe...

select *

from information_schema.columns.

Look at the result set, add your filter

This is typically a disk error meaning the file can't be read. Can you copy the file over? It would eliminate network issues.

There is a runtime for DTS packages on 2005, so you can run them in that. I believe this is only 32-bit, but I thought a 64-bit version was coming.

You...