C# Screw (11/20/2009)

---

I think DBA folk are interested in CPU time to see if the server is being strained? but that could be seen by looking at CPU Percentage utilisation...

Excellent work so far, C# Screw. In particular, multiple runs with averages should allow much more consistent results, as later runs should end up with more consistent cache behavior.

If...

Jeff Moden (11/17/2009)

You and another poster said about the same thing... I'm going to have to give it a try. Although it's not likely to have 8000 spaces (almost silly...

I didn't see it later on, but my solution in the past has been very simple; nest REPLACE() two spaces with one space as deep as required for the maximum...

Steve Jones - Editor (11/10/2009)

---

You can't performance tune without some testing of how efficient things are. I guess I was wondering as well whether people actually think about testing beyond...

JustANumber (11/10/2009)

---

In spare moments we would generate the missing tests and, as you might have foreseen, found deficiencies in some stored procedures. Some were minor, some were critical. ...

As others have said, there are more uses for SQL than an application returning specific rowsets.

SELECT * when you only want some of the columns is indeed bad.

SELECT * when...

The short form:

1) Always hash passwords (to prevent just reading the...

Note that the salt (appending something like the username [if it will never change without the password being changed just after as part of the transaction] or the row's primary...

Richard Gardner-291039 (10/2/2009)

---

Quite - as the DBA you should be revoking all privileges on all tables and only allowing pre designed updates via stored procedures - that's the only way...

Philosophically, with this argument, why do you...

Jason Whitney (10/1/2009)

---

I have run into this before, and the article gives the first half of the solution. The second part is what I can't figure out; how to avoid...

Unfortunately, with SQL and temporal databases, you appear to have missed one of the most difficult aspects of generalized date based fields: how to be both efficient and prevent bad...

Benchmark, benchmark, benchmark.

Microsoft's "SQLIO" provides at least some very controlled benchmark capabilities for random vs. sequential reads and writes (each independent of the other), while IOMeter allows for mixed loads....

Sir Slicendice (9/3/2009)

---

True simultaneous drive failure is extremely unlikely in a conventional home server; with power shared with CPU and integrated controller, the only way you get to simultaneous failure...