Why are you restoring a development database to production?

Lynn Pettis (7/2/2009)

---

Hey Jeff, you have a spare high-velocity pork chop launcher you can send me?? I think I'm going to lose my halo soon and I might as...

Enterprise edition refers to SQL, not to the OS, but I too think that's Server 2008. SQL Enterprise edition only runs on Server 2003 and Server 2008. The editions of...

From that I'd conclude you have more then one resume for some of the emails. In those cases, which resume do you want back?

Please post table definitions, sample data and...

Anyone want to take a stab at this?

http://www.sqlservercentral.com/Forums/Topic746075-360-1.aspx

Converting the while to a select off a (large) tally table's the easy part. The no duplicate values and exact number of returned...

Could you explain in more detail what it is that you're trying to do?

Jeffrey Williams (7/2/2009)

---

MichaelJasson (7/2/2009)

---

Microsoft SQL Server 2000 - 8.00.2055 (Intel X86) Dec 16 2008 19:46:53 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows...

Table definitions, index definitions and execution plan please.

I have a gut-feel that this is not the best approach. What uses these codes and why can a code not be generated when it's needed rather than a few...

I can possibly write a set-based alternative, but it's not going to perform much better. The function will still have to be called a couple million times and that's going...

Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Update all statistics. With fullscan if possible

Run CheckDB with the data_purity option

Set page verify to checksum

Run DBCC updateusage

Can you post the code for that function? Running a function repeatedly in a loop is not the fastest way of doing things, but if I put the function into...

What are you trying to achieve here? What is this function supposed to do and why?

Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/