Jeff Moden (3/23/2009)

---

If you want to learn about real world problems and some of the awesome solutions there are, then start hanging around here... some of the best and brightest...

You would need to do this whilst the job was running rather than afterwards.

Can you please post the results of DBCC SQLPERF(LOGSPACE) for the relevant database.

One potential cause is an open transaction which will prevent truncation of the log even in simple recovery mode. DBCC OPENTRAN will tell you if this is the problem.

I absolutely agree. Databases (MDF, NDF) should only be shrunk when the space isn't going to be required any more. A typical example might be where adequate housekeeping wasn't in...

Michael Valentine Jones (3/20/2009)

---

It is often better to shrink database files in small increments so that it can make continuous, incremental progress, instead of trying to shrink by a large...

Grant Fritchey (3/19/2009)

---

Oh yeah. We did a lot of tests to see if we could put GUID to work. It made developers lives easier, but it really seriously impacted the...

shnex (3/19/2009)

---

Now I'm choosing my indexes, so I have another question: I have a bigint column with 90% different values, the duplicate values are rare, but the column is not...

Grant Fritchey (3/19/2009)

---

I have several issues with GUID's as clustered indexes. First, they're very wide. This means fewer per page and more pages per index, making them somewhat less efficient....

shnex, you clearly want a solution that involves you in making minimal changes, which makes clustering the GUID an obvious choice for you.

Gail, Grant, can I ask you why you...

A good rule of thumb is that you should always have a clustered index. There are very limited circumstances where this is not such a good idea but they are...

Sorry and for clarity you should always test any schema changes like this before implementing them on a live system!

shnex (3/18/2009)

---

I found the problem, I think

The Pk-indexes are non-clustered,and that's why there are heaps. I don't know if this is ok, or if the person that was here before...

If you are looking to change the code you posted towards the beginning of the thread, selecting only index_id = 1 will have the same result as your code but...

Have a look at

SELECT * FROM sys.dm_db_index_physical_stats (DB_ID(),NULL,NULL,NULL,'SAMPLED')

The 'Sampled' parameter will populate avg_page_space_used_in_percent (and te other columns) by sampling the underlying pages. You can use DETAILED instead of SAMPLED to...

GilaMonster (3/18/2009)

---

Not necessarily. It's very...