Thanks Sean,

Appreciate the feedback.

Sean Lange (7/11/2014)

---

The biggest issue is this will miss things that get run very rarely. Consider procedures used during a year end process or something similar. These may not show...

wak_no1 (7/11/2014)

---

Hi

Having just archive quite a bit of data from the main Production DB, I now have around 15% free, reclaimable space sat in the data file.

I reluctant to run...

Uwe Ricken (7/1/2014)

---

sql-lover (7/1/2014)

---

utterly rubbish!

There is no difference between Unique Index and Unique Constraint, besides the obvious syntax of course.[/QUOTE]

I don't know your knowledge but such an ignorance of ANSI...

Uwe Ricken (7/1/2014)

---

sql-lover (6/30/2014)

---

We can't tell you, as only you know how your Index, table and data are being accessed. Plus we don't even know your table's schema.

The main advantage...

Joe Fuller (6/30/2014)

---

I'd like to ask what are everyone's thought on the use of non-clustered unique indexes.

I've found these useful for the following reason.

Our DBA's re-index on a weekly schedule...

Uwe Ricken (6/30/2014)

---

There will be no additional...

I would personally stay away of GUI when creating PKs. This is not only because additional locks that the GUI will create, but the extra control that the DBA will...

By Aaron ... and like I suspected..

Not everyone needs to be concerned about this issue. If you are not running Enterprise (or an equivalent)...

Answering myself. Found this: Potential for Data Loss in SQL Server 2012 SP 2

It seems that Aaron expands more on this. And it seems that the issue is when doing...

Gail,

Appreciate the heads up.

Any...

SQL Guy 1 (6/11/2014)

---

It will be much longer. Shrink with emptyfile pushes data page-by-page (or extent-by-extent) from one file to another, while rebuilding whole index is faster. Compare when...

SQL Guy 1 (6/11/2014)

---

You can't shrink file that has no empty space. Shrinking just releases empty space from files to OS.

If you want to get rid of a smaller...

You need to run this...

DBCC Shrinkfile(filename2, emptyfile)

... where filename2 is the secondary database file that you created.

This command will basically move whatever data you still have there to the...

ntrovato (6/11/2014)

---

Thanks for the advice ... your explanation in step 3 was exactly what I was thinking of doing. When you say ignore the Master, System database ... is this...