There was an interesting article about how telecommuting is the secret to employee happiness and it makes some sense in today's fast-paced, highly connected world. There are a number of job surveys that list flexible hours as one of the most desired benefits.
2012-10-05 (first published: 2007-10-10)
878 reads
Does it make more sense for a company to build it's own software or buy a package?
2012-10-04 (first published: 2007-10-23)
234 reads
Should you dog food your own software? Steve Jones thinks this is a good idea if it works for your particular product.
2012-10-03 (first published: 2007-09-28)
644 reads
There's still hope for all you DBAs out there looking for a telecommuting job that allows you to work in your pajamas. Someone sent me this case study about remote DBAs and I decided to pass it along. It's a one page PDF, and it's a fluff piece to some extent for Bluewolf, a company that has outsourced IT staffing, but has a section on remote DBA work as well
2012-10-02 (first published: 2007-09-19)
1,374 reads
Challenge yourself to find new tools and use them in your work. That's today's message from Steve Jones. (This editorial was originally published on Aug 5, 2007. It is being re-run as Steve is away on the SQL in the City US 2012 tour.)
2012-10-01
308 reads
Index fragmentation can certainly cause performance problems, but should it really dictate the way we design our clustered indexes?
2012-10-01
403 reads
Companies may look to outsource security in order to take advantage of experts' skills at a lower price. What will that mean for data professionals?
2012-09-27
114 reads
Today Steve Jones talks about pair programming and when it might make sense for data professionals.
2012-09-26
199 reads
When working on a project, you have to make trade-offs. Unfortunately, some managers don't realize this. Steve Jones says we need to help them understand that doing things the right way, and working with trade-offs, makes for better systems.
2012-09-25
141 reads
The forecast for IT work is growing. That's good for those of us working in the field.
2012-09-24
173 reads
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
I’m excited to announce the release of a new open-source project that fully automates...
Comments posted to this topic are about the item Server-Level Table sizes
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers