http://msdn.microsoft.com/en-us/library/ms147834.aspx

TOP 10 can grab one page (or a few) and return 10 rows. Any 10.

The order by means you must load the entire table to ensure you have the top...

A few free books we offer:

http://www.sqlservercentral.com/articles/books/76296/

http://www.sqlservercentral.com/articles/books/67441

Tx, corrected the typo.

Insurance sucks, in general

Ninja's_RGR'us (1/5/2012)

---

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

---

In terms of depreciation, it sucks, but it's real. The value of your stuff is lower over time, and if you had to replace...

jeff.mason (1/5/2012)

---

That brings up an interesting question -- how many DBAs have their backups go straight to tape? In my professional career I have never had a backup infrastructure...

Interesting. I wouldn't think it would matter since all editions can restore compressed backups, but apparently the header stores this.

Since I use separate media sets for all backups, not an...

jmiceli (1/5/2012)

---

...

I do not even allow automatic application of updates to my home machine. I allow the machine to download them, but then I pick and choose what I...

Brandie Tarvin (1/5/2012)

---

Ninja's_RGR'us (1/5/2012)

---

I have some research, I have found a lot of items that are REAL match in the same store I bought them in in the first place....

GilaMonster (1/5/2012)

---

Desperation or laziness?

Explain everything about partitioning: http://www.sqlservercentral.com/Forums/FindPost1229215.aspx

Post on old thread asking how to partition an existing table: http://www.sqlservercentral.com/Forums/FindPost1230706.aspx

Post on old article asking for script to partition existing table: http://www.sqlservercentral.com/Forums/FindPost1230714.aspx

Anyone...

We're not going to explain in detail the steps that are needed for your very large database. You need to learn how to do it.

How? Ask specific questions on things...

TravisDBA (1/5/2012)

---

Auto-Updates IMHO are generally a BAD idea and the reasons are plentiful, just google it and see all the reasons, but here are just a few to start:

Sometimes updates...

Steve Smith-307669 (1/5/2012)

---

Suppose, for a second, that you have only one browser installed on your computer (pretend it's IE 9.0.0.1873). The automatic update comes, upgrades it to 9.0.0.1875, but...

Never know when they apply. When I started writing this, I was at 15, apparently now 16.

I don't use Chrome for...