Ok - I was guessing at what his colleague might have actually heard rather than what he said he heard:hehe:

We are guessing what he may have meant but he may have meant...

Creating a filegroup and adding files to that file group which exist on separate drives and then putting...

They may also mean splitting data out into other tables and using a Primary/Foreign key to join them - eg taking someone's address and putting it into an address table.

Can...

The backup should be smaller - it won't back up the empty space

Have you had a look in activity monitor to see if there are any locks blocking the shrink job?

I say this whilst agreeing with the previous posters about shrinking in...

I just ran this to re-upgrade my developer edition back to standard:

:: You need disk 1 in servers and disk 2 in tools underneath c:\sqladmin\sql2005

@echo off

Set ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_Tools90,SQL_Replication

Set INSTANCENAME=MSSQLSERVER

Start /wait...

Hi

The problem you have here is that Developer is a higher version than Standard so you can't upgrade that way.

You would need to uninstall standard then install Developer.

Backup and reinstall...

Hi

We had a problem almost the same - Looked at CPU affinity, network cards etc.

In the end I found it was because Priority Boost was enabled on the installation (it...

I'll look into the Test licensing as that could be really useful - we have about 5 test server for different live applications.

I guess I will just have to take...

You may be right - these servers were installed before I got here.

There is a lot of junk and packages to clear up for an re-install but could be worth...

That's strange - or not as that is what I'd expect it to say.

I wonder what the difference between SP3 and 3 was htat makes it crash. (I have SP3...

The whole things goes down - you get Visual studio debugger come up and then SSM closes. You might get the chance to save some work if you ignore the...

Hi

Although I didn't say it explicitly I did say SSMS with sp3 which means SQL 2005.

It's true it works in SQL 2008 but crashes 2005 so I guess they have...

It is odd - I know you can't put variables in a view but you'd think SSMS would just return a TSQL error rather than commit suicide.

I'm not sure 'Geometry and Geography' are a new data type - they are two different data types.

Perhaps just one should have been put in the question rather than grouping...