Is the table in the same database or a different database?

Error messages for the ones not working?

Steve Jones - SSC Editor (1/7/2013)

---

GSquared (1/7/2013)

---

sqlpadawan_1 (1/7/2013)

---

With a terabyte of storage for less than $100, free utilities like Sync Toys from Microsoft, and unlimited online backup services as cheap...

Jeff Moden (1/6/2013)

---

What I've found is that a DBA is usually the voice-of-one against many and that the DBA is usually the only one with a mind out for silly...

:sick:

GilaMonster (1/6/2013)

---

Stefan Krzywicki (1/6/2013)

---

GilaMonster (1/6/2013)

---

Stefan Krzywicki (1/5/2013)

---

In this galaxy, the laws of physics are different (the best explanation of, well, everything in Star Wars) and space there is not the...

You should consider the page density (Internal Frag) in addition to the External Fragmentation. And the value to consider for internal frag depends on your data and page density...

SQLCrazyCertified (1/4/2013)

---

SQLRNNR, There are only 50 active connections.....so, I don't think this is the issue.

Joie Andrew, Had complains that everything is running slow and I coudn't find anything else other...

Perry Whittle (1/5/2013)

---

KcV (1/4/2013)

---

Hi,

I have just shifted my database of sql 2000 to sql 2008 64 bit after running Upgrade adviser.

then i run DBCC DBREINDEX in all tables.

After that when...

What is the query you are using to determine fragmentation?

What is the size of some of these tables? How many pages? Is there a Clustered Index on the tables in question?

Load the data into a different table. Drop the current table, then rename this secondary table to what the dropped table was (the one you are currently truncating etc).

Please provide sample data so a better solution can be provided.

haha

lsalih (1/4/2013)

---

Gail - As always, I enjoy reading your answers... Thank you.

you mentioned that by just rebuilding the indexes, that should help... I have to say, I run into same...