Jeff Moden (7/30/2008)

---

Heh... space used... the Tally or "Numbers" table only takes 136KB for an 11,000 row table and that includes the clustered index in the form of a primary...

You're trying to UNPIVOT or re-normalize your data. The 2005 method is the UNPIVOT; past versions would require a series of SELECT statements smushed together with UNION or UNION...

Grant Fritchey (7/30/2008)

---

gcopeland (7/30/2008)

---

Scott, you took the words right out of my mouth. I have always disagreed with the mindless use of sprocs in the design of systems, and...

Jack Corbett (7/30/2008)

---

I'll admit I'm in the "USE stored procedures camp" and one of the main reasons is this quote from your editorial which you use as a reason to...

cs_troyk (7/28/2008)

---

Hi Steve;

Here's a link to a more detailed account of the problems one can run into with an EAV design: http://www.simple-talk.com/opinion/opinion-pieces/bad-carma/

In a nutshell, expect:

1) Difficult or impossible to declare...

Alex Rosa (7/26/2008)

---

Hi everybody,

I'm a little bit late in this posting, but I'd like to share with you my similar case.

Some months ago I was fired, don't worry, I got...

I keep trying to look at the bright side. The ETL is process some 10,000 records through...

hmm...must summon the Chi for some skills today.

Just walked into a new gig today, and let's just say the first procedure they wanted me to "look at" (not to tune...

That's what I get for freehanding it....:D

Glad it helped, typo notwithstanding....

It's kind of hard to tell on some of the things, but here would be a couple of them.

Sum(case when finish betweeen 1 and 9 then 1 else...

Jeff Moden (7/18/2008)

---

Steve Jones - Editor (7/18/2008)

---

I think Grant and Jeff must be related to Dwight Shroot. Sorry you guys lost your privileges to bring nunchakus and stars into the...

Performance-wise, it sounds like you need to break that up in to much smaller chunks. You could use something like

declare @n int

declare @rn int

set @n=50000

set @rn=1

While @rn>0

BEGIN

DELETE top(@N)...

Instead of referencing the tables directly - perhaps set up a view to act as your data source in this case. This way you can build the new table...

On the analytical SQL side:

1. I am starting a new company and you have lined up most of your resources to do so, but am still deciding how to...

If the names "look" different on different servers, then CustName cannot be your key, since it will not help you identify cust1 on server1 and cust1a on server2 as being...