I cannot find anything that states that it has become mandatory, but I did find someone claiming that the BOL for SQL 2008 (not R2) stated that it was...

Great Post!

+1

forceman29 (12/13/2012)

---

I have a server 2008 R2 server were Database A is replicating to Database B. A full snapshot was done without any issues. I have the publication setup as...

I second all those that said Itzek Ben-Gan. There are some great stairways on this site. I would say that Greg Larson's Stairway to DML and Celko's Stairway to Data...

capnhector (12/12/2012)

---

This looks like a running total (from the math in the rCTE). Have a look at Jeff Modens article on the "Quirky Update" http://www.sqlservercentral.com/articles/T-SQL/68467/ It will at...

CELKO (12/12/2012)

---

Read about the Window clause, which makes it very easy to write running totals:

CREATE VIEW Running_Balance (payment_nbr, receipt_date, payment_amt, acct_balance)

AS

SELECT payment_nbr, receipt_date, payment_amt,

...

Sean Grebey (12/11/2012)

---

If I use 2012 Management Console from the Express version to Manage an Enterprise version of 2008, will things like Maintenance plans be available, or have those features...

I like this guy's blog and am using it to study for the SQL Serve 2012 certs. Note how he passed and why he...

SSIS is the best tool for this.

Your Name Here (12/5/2012)

---

Sorry to be a bit off-topic but this thread flashed me back to an interview I had years ago. The 'technical' questions about troubleshooting were surprisingly...

I want to start by saying that I am not providing an answer here but rather providing a little food for thought....

But the...

Great, great article Dwain. Amazing work and perhaps your best article yet on SSC IMHO (it's certainly your longest).

I would have been delighted to propose a looping solution as...

mike 57299 (11/28/2012)

---

Hi All...

... As part of our backup plan, we do transaction log backups every hour during the work day.

I would like to copy the logs to...

Indexes usually make queries faster. Primary keys usually make queries faster because an index is created when you...