Stupid T-SQL Tricks – Part 1: Logarithms
Not just for math geeks, logarithms and their inverse functions (the exponentials) can have useful and often unexpected capabilities in...
2014-05-01
2,431 reads
DAX #2 – Installing AdventureWorks DW Tabular Model SQL Server 2012
OK, first thing first. We all know the famous Adventure Works multidimensional sample project. To learn the tubular mode/DAX, we...
2014-05-09 (first published: 2014-04-30)
14,334 reads
Speaking at Connections
I just got my acceptance to the DevConnections, SQLConnections in September for two sessions:
Continuous Integration for DatabasesMaintaining High Performance When...
2014-04-30
1,375 reads
SQL #53 – Keyboard shortcut Alt + F1 works now in SSMS 2012
Keyboard shortcut Alt + F1 works now
SSMS has a rich set of keyboard shortcuts that works by default. But in SSMS...
2014-04-30
6,249 reads
And I wonder, where that column is?
I wouldn't have decided to write this post if I didn't see my boss at one of my previous jobs...
2014-04-30
1,718 reads
The Cardinality Estimator in SQL Server 2014 – Going Forward and Backward
I saw a talk from Joe Sack (b | t) on the cardinality estimator (CE) in SQL Server 2014 and found...
2014-05-08 (first published: 2014-04-30)
3,528 reads
Decks & Demos Live
Hello Dear Reader! Just a quick update. I've been traveling a lot and I'm behind in posting some Decks & Demos....
2014-04-30
1,376 reads
Building the SQLSaturday Orlando Marketing Plan–Part 3
Not to short change fund raising, but the toughest goal to meet for this year is registration/attendance if we’re going...
2014-04-30
1,527 reads
Modern Data Warehousing Presentation
I will be presenting the session “Modern Data Warehousing” on Saturday at the PASS SQLSaturday Business Analytics edition in Dallas...
2014-04-30
1,767 reads
A New Stressor
I tend to be amused when I run into something that causes me stress because I like to think – foolishly...
2014-04-30
1,430 reads
Blogs
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Forums
BCA KCP Pasar Kebayoran Lama Telp:0821-8200-174
Telp/Wa 62 8218200174 Jl. Raya Kby. Lama No.174, RT.8/RW.3, Cipulir, Kec. Kebayoran Lama, Kota...
ALAMAT BCA KCU SCBD Telp/Wa:0821-8200-233
Tlp Cs Bca 08218200233 Equity Tower, Ground Floor, Unit D & Lantai 8, Unit...
Alamat BCA KCP Mayestik Telp/Wa:0821-8200-2031
Phone Cs 08218200203 Jl. Kyai Maja No.77, RT.12/RW.3, Gunung, Kec. Kby. Baru, Kota Jakarta...
Question of the Day
ORDER BY alias
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