Passwords: http://www.pcworld.com/article/2978316/security/tired-of-memorizing-passwords-a-turing-award-winner-came-up-with-this-algorithmic-trick.html

tim.mckay (9/1/2015)

---

Just my two cents, but this points to a defect in client management. A strong project manager, business analyst and systems analyst should be able to nail...

julienchappel 38298 (8/31/2015)

---

Hi Steve, did you proof read this article before posting it. I got used to from you brilliant ideas, samples and solutions to follow, but this latest effort...

Not sure if I'll be in town, so I'm hoping Yahoo treats me fair.

Eric M Russell (9/1/2015)

---

Hi Steve,

What makes software and database estimating so difficult, even more so than legal defense or medical procedures, is that the client is telling us not only...

Joel Ewald (9/1/2015)

---

I think changing scope and situations occur in every industry and the entire reason we are paid is because as professionals we deal with it.

When you are billing...

xsevensinzx (9/1/2015)

---

I'm not really seeing the connection between the first linked stories in the first paragraph.

A solution--which is what the doctor is aiming to apply--is totally different than the benefit...

Is it me, or is the runner loafing from third?

http://m.mlb.com/video/topic/6479266/v434180983/nyybos-bradley-jr-makes-catch-throws-out-bird

We had a similar play this weekend. Hard grounder to deep short, and the runner on third goes at the...

That's a good analogy.

You can add tables in your update statement and join them, as shown here:

update table1

set x = y

from table 2

where table1.pk = table2.fk

Since many of you find issues and problems and answer them, maybe a few of you would want to submit some questions of the day?

http://www.sqlservercentral.com/Contributions/New/Question

Ed Wagner (8/31/2015)

---

SQLRNNR (8/31/2015)

---

Luis Cazares (8/31/2015)

---

Brandie Tarvin (8/31/2015)

---

I am planning to upgrade at least one of my machines. Haven't decided if it'll be the 8.1 or 7. But I'm waiting...

Don't use the GUI.

Use DBCC Shrinkfile( tempdbdata, 1500);

Or something close to the current size. Just get it to run. If it does, then work on slowly shrinking.

Desktop

Windows: 38.2GB

Program Files: 12.8GB

Program Files (x86): 21GB

Lots of crap here though.

Laptop (< 1yr old)

Windows: 33.5GB

Program Files: 3.75GB

Program Files (x86): 11.9GB

These are both VS2013. Need to upgrade.

You need to restart SQL Server. What is the initial size for tempdb? Also, what code did you run? Did you manually run dbcc shrinkfile?

You do want to be in...