DBAs Take Sixth Place
The hot jobs for 2013 are compiles and a number of tech jobs make the top 100. DBAs come in 6th and Steve Jones thinks that's good news for data professionals.
2012-12-24
259 reads
The hot jobs for 2013 are compiles and a number of tech jobs make the top 100. DBAs come in 6th and Steve Jones thinks that's good news for data professionals.
2012-12-24
259 reads
A woman sues Best Buy for $54million. That's absurd, but her laptop is worth more than the hardware. This editorial was originally published on Mar 3, 2008. It is being re-run as Steve is traveling.
2012-12-24 (first published: 2008-03-03)
340 reads
This Friday Steve Jones asks what the load on your systems are. Do you know what it is and how it compares to other systems?
2012-12-21
95 reads
Automobiles are becoming more complex, with more computerized systems every year. Steve Jones talks about some advances and how we must be sure that security is a part of future design considerations.
2012-12-20
103 reads
Does certification help your career? Is it the choice for those that can't actually accomplish something in the real world? Steve Jones says that it can go either way, but it's up to the individual.
2012-12-19
254 reads
A look at what passes for technology from Bill Nicolich in our guest editorial.
2012-12-18
138 reads
Why is SQL Server licensing so complex? Today Steve Jones asks the question and wonders if Microsoft would make some changes to make it easier to understand.
2012-12-17
200 reads
2012-12-17
74 reads
Today Steve Jones talks about deployment and how well it can work. He also asks about the problems from you and how easily it can fail.
2012-12-14
129 reads
Security is a concern in the cloud, but should it be your number one concern? Steve Jones notes that business continuity might be a bigger issue.
2012-12-13
172 reads
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
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...
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