GilaMonster (2/6/2012)

---

The usual trick is a unique filtered index.

CREATE UNIQUE INDEX <index name> ON <table name>(<column name>)

WHERE <Column name> IS NOT NULL

Uniqueness only enforced over the non-null portion of the...

And I stick them outside of the proc.

Mostly because I hate 10-15 lines of green stuck between the name of the procedure and the code... some days I'll be looking...

I still don't get it... then again SSAS leaves me confused on days that end with Y

1. Say I have a well functioning cube.

A. How do I...

Lowell (2/2/2012)

---

now to the issue at hand:

i'd say it's best practice to never store a rollup of information in another table.

so if you need a total in another table, that...

And 60 isn't that many... I was involved in doing it for closer to 600.

It's a good practice and requires you to review older stored procs. Another good practice.

Lets see what I can remember from our jump...

Are you aware that 2005 is already EOL ?

If you're upgrading, I'd go straight to either 2008 R2, or if you feel adventurous 2012 which comes out in like 2...

cengland0 (2/2/2012)

---

Exactly. You don't need that information in the main table -- just the audit table.

Also, what...

cengland0 (2/2/2012)

---

mtassin (2/2/2012)

---

KWymore (2/2/2012)

---

mtassin (2/2/2012)

---

cengland0 (2/2/2012)

---

I like using this function for audit tables. If you have an application that allows users to add, edit, and delete, you can use...

KWymore (2/2/2012)

---

mtassin (2/2/2012)

---

cengland0 (2/2/2012)

---

I like using this function for audit tables. If you have an application that allows users to add, edit, and delete, you can use this method...

cengland0 (2/2/2012)

---

I like using this function for audit tables. If you have an application that allows users to add, edit, and delete, you can use this method to keep...

Sorry, but I had too much trouble getting past the poor design.

i.e. instead of writing a query and appending the short descriptions via query, the original table should have been...

It's pretty cool.. but it only seems to load one row from the file.

And when you add SQL Server Full Text onto that search you get an entirely useless set of links 🙂

Thanks... I take it the file is in SQL Server ready...

SQL Kiwi (1/24/2012)

---

That's a fair point. ...