Today's editorial was originally published on May 13, 2007. It is being re-run as Steve is at SQL Server Connections. Today Steve Jones talks about the need to train yourself, just like people in other professions.
2012-03-30
215 reads
Today's editorial was originally published on Apr 17, 2007. It is being re-run as Steve is at SQL Server Connections. Today Steve talks about the Mechanical Turk process at Amazon.
2012-03-29
234 reads
Today's editorial was originally published on Apr 27, 2007. It is being re-run as Steve is at SQL Server Connections. Today Steve talks programming.
2012-03-28
383 reads
Today's editorial was originally published on Apr 29, 2007. It is being re-run as Steve is at SQL Server Connections. Today Steve Jones talks about purchasing software.
2012-03-27
78 reads
Today we have a guest editorial from Andy Warren as Steve Jones is at SQL Server Connections. Today Andy talks about how we can make those dreaded daily events, meetings, better.
2012-03-26
165 reads
You need a quiet couple of hours poking about with DMVs, and checking execution plans to get to the bottom of the a query issue, but you can't make a copy the production database either. It's too big, and the data is private....
2012-03-26
246 reads
This Friday Steve Jones asks about maintenance. Do you have regular windows? Flex time? Or is maintenance just added on whenever it is needed and added onto your work week.
2012-03-23
146 reads
Today we have a guest editorial from Andy Warren as Steve Jones is on vacation. Today Andy talks about personality tests and what they might tell you about yourself.
2012-03-22
397 reads
Today Steve Jones talks about the pace of data growth looking to outpace the IT budget changes. As data professionals, we need to learn to do more with less.
2012-03-21
230 reads
How can a company attract talent? First, be a good company to work for, and then be real.
2012-03-20
209 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