DBA Myths: TRUNCATE TABLE deletes all the rows of a table instantly.
Most DBAs and developers I’ve talked to over the years have felt that TRUNCATE TABLE is an instant DELETE. However...
2014-04-30
2,727 reads
ERROR OPENING SSRS REPORT MANAGER IN INTERNET EXPLORER
Writing this post only for internet explorer as not aware of the settings of other browsers such as chrome/mozilla.
To be...
2014-04-30
1,256 reads
Colorado SQL Events for May 2014
SQL Meetings are training events for SQL Server professionals and those wanting to learn about SQL Server. Please note that...
2014-04-29
1,539 reads
Most important feature of SQL 2014
There are a whole raft of cool new features in 2014 including things like In-Memory OLTP, increased Azure integration/options and...
2014-04-29
1,677 reads
Find SQL Database Owner with T-SQL
One thing that on occasion bugs me about PDW or APS or whatever it happens to be called this week...
2014-05-08 (first published: 2014-04-29)
4,438 reads
Building the SQLSaturday Orlando Marketing Plan–Part 2
Our attendance number for last year was 285, so we’re going to aim for increasing that by 20% to 342....
2014-04-29
1,294 reads
Building the SQLSaturday Orlando Marketing Plan–Part 2
Our attendance number for last year was 285, so we’re going to aim for increasing that by 20% to 342....
2014-04-29
1,366 reads
Back to Work
After surgery Fri am, I’ve been mostly taking it easy, but now it’s back to work. Got kids to school...
2014-04-29
1,433 reads
Speaking At the Pinellas SQL Group on August 18, 2014
I’ve committed to presenting but haven’t decided on the presentation yet. It will probably be a remote presentation because it’s...
2014-04-29
1,269 reads
Installing and Configuring Active Directory in Window Server 2012
Hello Friends,
Sometimes life is so uneasy that you didn’t get time for the work which you like the most. Now...
2014-04-29
1,885 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