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...

ben.brugman (6/4/2012)

---

Grant Fritchey (6/4/2012)

---

When all you have available is the full backup, that's all you're going to get. If you have log backups available, you can restore right to the...

First, please don't edit the question to change it as it then wrecks the flow of the discussion. If you have a follow up, ask it. If you have a...

To build on Grant's note.

The RDBMS always does a recovery when you restore. This means that all commits in the log are verified as being in the data files as...

So very true.

Any of our data, even things we might not expect (like images/recording of our person, or...