I did see that one. I was hoping that area had more...

Steve Jones - SSC Editor (5/12/2015)

---

You can query DMVs for fragmentation. Do this before and after.

Note that unless this is a read only database, you need some free space for...

Looks like I cant use sys.dm_db_index_physical_stats. My ISP doesnt allow this.

But thank you for your information. I will give it a look.

Edit: I can use the...

I can upload a copy of the DB to a test site and see what happens if I do a SHRINK of the DB. Is there something I can...

ALZDBA (1/30/2015)

---

another...

Alvin Ramard (12/15/2014)

---

I don't like using the error output when I can remove the erroneous data myself. I would do it differently.

I would add a condition split in the data...

Sean Lange (9/10/2014)

---

Ahh gotcha. OK, back on track. Let's use your Schools table as an example. My former comments about normalization would apply if this is your real table but...

Sean Lange (9/10/2014)

---

cbernardes (9/10/2014)

---

Sean Lange (9/10/2014)

---

The biggest issue you have is that you have a base table and audit table but there are no columns to record the time something...

Steve Jones - SSC Editor (9/10/2014)

---

Sorry, Type II Slowly Changing Dimension - http://www.1keydata.com/datawarehousing/slowly-changing-dimensions-type-2.html

It's kind of what you have, but not quite.

As Sean mentioned, you need to record time. Without time,...

Sean Lange (9/10/2014)

---

The biggest issue you have is that you have a base table and audit table but there are no columns to record the time something happened. This means...

Steve Jones - SSC Editor (9/10/2014)

---

I'm not sure I completely understand. You're giving data, but you haven't explained what in the data you'd like changed, so I'm not sure I'm...

Ahhh.... Thanks so much. That was it.

I think that you will need to use a value from the main reports dataset as the parameter value you are passing to the sub report.

By use the...

Perry Whittle (8/26/2014)

---

That's because they're set in excel, you'll need...

twin.devil (8/26/2014)

---

cbernardes (8/25/2014)

---

Eirikur Eiriksson (8/25/2014)

---

cbernardes (8/25/2014)

---

I am using the DTS wizard and having problems importing excel into an existing table.

Problem is that various column in excel are defined as double...