DLathrop (8/25/2009)

---

If you're using ER/Studio, you can do (and should) do sub-models fairly easily. Some things you may not have found yet.

1) Make sure the Overview window is open: View...

Basically, my question to the forum is:

Was uninstalling BIDS with Control panel not the correct way to uninstall it?

Here's a screen shot of my control panel. and some VS stuff I found still laying around on the server. (See attachments)

Pam,

Thanks,ER Studio is looking somewhat promising.

I was able to create a data model but it's so darn big...

Eddie Wuerch (8/21/2009)

---

I use the following script to pull a list of tables and space used. Add a HAVING clause to only return those tables with > 0 rows,...

Just to Chime in here. I think my network staff had to modify the server's boot.ini file in order to put the finishing touch on increasing the memory available...

Checking on both now.

I'll keep you posted.

And THANKS for you suggestions!!!

Keep em coming!!

Chris

I've tried to run this tool against my SQL2005 database of roughly 4000 tables and it always seems to hang or grind to a halt. Please advise.

Or is there...

Point taken.

Thanks!!

Chris

Jeffrey Williams (6/26/2009)

---

Chris (6/26/2009)

---

Wow, thats an elaborate script!!

Ever get the following error when running it?

"

Procedure dba_indexDefrag_sp dropped

Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the...

Wow, thats an elaborate script!!

Ever get the following error when running it?

"

Procedure dba_indexDefrag_sp dropped

Cannot add rows to sys.sql_dependencies for...

GilaMonster (6/24/2009)

---

Chris (6/24/2009)

---

DBCC SHOWCONTIG scanning 'APPROVALS' table...

Table: 'APPROVALS' (202639965); index ID: 1, database ID: 5

TABLE level scan performed.

- Pages Scanned................................: 2

- Extents Scanned..............................: 2

- Extent Switches..............................: 1

- Avg. Pages per...

balbirsinghsodhi (3/4/2009)

---

I know it does not matter but my question is why using rebuild index command does not make logical fragmentation to 0%.

May be it is related to filegroup...

By the way this is the DBCC for the Index I tried to manually rebuild:

DBCC SHOWCONTIG scanning 'APPROVALS' table...

Table: 'APPROVALS' (202639965); index ID: 1, database ID: 5

TABLE level scan performed.

-...

Mani Singh (6/23/2009)

---

select db_name(sind.database_id) as dbname,object_name(sind.object_id,sind.database_id) as objname,sind.index_id,sind.index_type_desc,sind.avg_fragmentation_in_percent,'ALTER INDEX ON '+db_name(sind.database_id)+'.dbo.'+object_name(sind.object_id,sind.database_id)+'.'+si.name+' REBUILD WITH (FILLFACTOR = 85, SORT_IN_TEMPDB = ON STATISTICS_NORECOMPUTE = ON) ' as executethsestatemetns

from sys.dm_db_index_physical_stats(NULL,NULL,NULL,NULL,DEFAULT) sind join sys.indexes si

on...