I just re-read and my typing\spelling sucks.

Thougt as much, but nice to have it confirmed.

Thanks.

I'll ponder which way I'll implement this. Trying not to create too many new indexes. Trying to consoliodate missing indexes.

Agian Thanks

Nice one,

So 4 steps really. If I've got it right.

1 Create a new FG

2 Create a new data file.

3 Alter Scheme (NEXT USED = NEW FG)

4 ALTER FUNCTION split range...

Thanks

Both of you.

Create another account and grant it the ability to delete see if that works.

Then try and sort out the permission issue with your account if that works.

Shouldn't really be using SSMS on the Live server. It takes memory away from the system. SSMS should always be used remotely from your PC in my books. Especially when...

Personnaly I hate AM in SQL2008. It is generally slow and painful to use. I rarely use it these days and do most thing via script. Querying DMVs can be...

In my case all PKs are unique but non clustered. It seems to me that a trick was missed when they were implemented. They should have been created as clustered...

Try this for table and index usage info. If updates are high since last sql server restart then set the fill factor should be set low.

use databasename

go

SELECT

OBJECT_NAME(S.[OBJECT_ID]) AS [OBJECT...

Try this

-- Table and row count information

SELECT OBJECT_NAME(ps.[object_id]) AS [TableName],

i.name AS [IndexName], SUM(ps.row_count) AS [RowCount]

FROM sys.dm_db_partition_stats AS ps

INNER JOIN sys.indexes AS i

ON i.[object_id] =...

Execellent always good to have it confirmed. The new server will have no reports on there so all seems fine. These are test servers so I imagine they will have...

capnhector (11/9/2012)

---

Bobby Glover (11/9/2012)

---

Praise the lord for this post. I have the same issue 1000 tables 750 are heaps, the wierd thing is they have NON-CLUSTERED PKs in all the...

Praise the lord for this post. I have the same issue 1000 tables 750 are heaps, the wierd thing is they have NON-CLUSTERED PKs in all the tables. Some quite...

Its not wise to do shrink operations on production dbs.

I have a script (not on this laptop) that shows the size of all the tables in the db.

If you...

Can two service broker queues use the same contract.