peter-757102 (6/8/2011)

---

Demonstrating something you have done is getting harder by the day, because all work is hidden on inaccessible servers when at an interview location. So it is just your...

Lowell has explained it well, and I'd second his advice.

Just grant what you need to a role, and add users to a role. Even if it's one person, at some...

SQL Server doesn't track when something was inserted. There is no ordering to records, meaning that if you inserted

1 11 ABC 100

1 11 ABC 101

2 12 XYZ 102

2 12...

You want this based on Acct_ID and acct_row then. When you specify the ordering, you are choosing this based on some other value. There is no ordering in SQL Server,...

I think I've phrased it wrong. The weighting has to do with free space, so if you have different size files (I've never done this), it can result in some...

ALZDBA (6/7/2011)

---

I get to see it in...

SQL has, and still does, use proportional fill, meaning that it attempts to distribute data so that the total data in the files is equal, not the data you add....

Good

cfradenburg (6/7/2011)

---

I'm pretty sure he didn't ride horses down to Florida which is where...

A couple notes.

first, this was a reprint for 2006, and the story in question from 2005, so it's a bit dated.

There wasn't a set aside time for reading, not sure...

GSquared (6/7/2011)

---

Steve, when you originally envisioned SSC, did you imagine it would end up having debates on the meaning of "philosophy" and the definitions of "1" as part of the...

We've talked about Powershell. we need an enhancement to the engine that renders the different codes, but I'll see what we can do.

the "plain" should work for cmd stuff.

My apologies. The question has been corrected with a count(*) instead of a SELECT *. I am sure that I saw 50 results in testing and let it go as...

Craig Farrell (6/6/2011)

---

calvo (6/6/2011)

---

wow. I was about to question this when I looked it up, totally threw me for...

If you do have a very large distribution database, it could indicate something is wrong. Transactions sit in the distribution database until all subscribers have picked them up. If you...