Brandie Tarvin (1/9/2012)

---

I have this image in my head of me wearing a monocle and top hat while holding cane in one hand and a cuppa in the other.

Oh,...

Roy Ernest (1/9/2012)

---

I see lots of comments regarding post counts... Does everybody have a target? I have never thought about it at all.

When I get time post some thing,...

san43 (1/9/2012)

---

Thank You all for the reply.

I am specifically looking for any document published by Microsoft regarding T-SQL standard coding guidelines or best-practices, so that I can suggest developers...

Perry Whittle (1/4/2012)

---

Jeffrey Williams 3188 (1/4/2012)

---

Perry Whittle (1/4/2012)

---

If all you're doing is joining the server to a domain then it won't make any difference whether you install SQL Server before...

WayneS (1/6/2012)

---

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

---

Top 10 from 2011

User posts

SQLRNNR ...

GilaMonster (1/6/2012)

---

Grant Fritchey (1/6/2012)

---

Brandie Tarvin (1/6/2012)

---

Evil Kraig F (1/5/2012)

---

One of the things we almost have to discuss is issues and problems. The trick is who are you throwing under...

Yeah, Paul Randal's bottom. Ha!

1000 pags is a good a guideline as anything. I...

Brandie Tarvin (1/6/2012)

---

Evil Kraig F (1/5/2012)

---

One of the things we almost have to discuss is issues and problems. The trick is who are you throwing under the bus when...

No, you'd need to use one of the standard methods, OPTIMIZE FOR, local variables, stats updates... which ever one worked best for your situation.

Backups. Make sure everything is backed up. And that's SQL Server backups, not file backups. Biggest error for people starting out is not getting good backups in place.

YEah 1gb is going to be very hard to work with. However, creating a table, dropping a table, these operations should be fairly quick. You're probably just hitting resource contention....

If the size is less than 8 pages, it's going to be stored on mixed extents and defragging is going to be an utter waste of time. You might even...

Just one point worth considering, how much are the differen applications dependent on the data from each other. If it's fairly light, splitting up allows you to have multiple indepdendent...

CELKO (1/5/2012)

---

No, not really. However, there are some ISO-11179 standards for data element names and meta-data, the SEI has a ton of research, and so forth.

My book SQL PROGRAMMING STYLE...

Just a note, the use of no_lock CAN reduce time because it reduces locking, but it's not an automatic. Not trying to get into the whole no_lock discussion, but we...