Nothing major, in fact, not much at all in months. My developer is working on Simple Talk, so not much happening here.

Rackspace hosts us, so perhaps they changed something.

Joins have nothing necessarily to do with duplicate rows. Those are structures by which different data from two tables are combined. The duplication depends on the data and the filtering...

A few things here. One...

Please post correct DDL. Don't try to avoid typing to make us type more.

Sample data need insert statements. There are formatting commands to the left of the edit box, please...

roryp 96873 (6/5/2012)

---

Steve Jones - SSC Editor (6/5/2012)

---

Did you see the replay on the 6th inning foul ball? I didn't, but heard about it all over the radio Sat. Is...

harri.reddy (6/5/2012)

---

ok.

what i want is you see the dates in bold is repeating at the end.

so i want 1 section from 09/30/2010 to 12/31/2010

and another 08/31/2008 to 12/31/2010

but in...

Did you see the replay on the 6th inning foul ball? I didn't, but heard about it all over the radio Sat. Is it an asterisk if the umpire blew...

I'm not sure what you mean by the date is repeating. What do you want back? All rows?

Just change the dates in the queries as shown by cfradenburg.

SQL doesn't work...

I think these are too vague and hard to enforce with hard rules.

Here's what I'd do instead.

- Make a solid argument for why these rules exist. Provide ROI, admin cost,...

jay-h (6/5/2012)

---

Eric M Russell (6/4/2012)

---

I understand that the goal is to translate voice commands into web search or iPhone commands, but I don't see why it's necessary to steam the...

You can keep trying to do this without impacting production, but you run the risk, perhaps a serious risk, of losing lots of your data. You need to spend the...

You cannot prevent people from connecting to Access with another front end either. Once they know the password, same as a login in SQL Server, they can connect from any...

Very true,...

I would think about setting a process that deletes a few chunks, and them take a log backup. Monitor the size of the backups. If it's low enough, raise the...

Some of these you may be able to enforce, but in some cases, you've provided things that aren't really patterns, but formatting standards.

For example, a "use" statement for scripts. SQL...