PASS Summit

Technical Article

Microsoft to Headline PASS Data Summit 2024 as Sapphire Sponsor

  • Article

Join Microsoft at PASS Summit 2024 to explore the latest database innovations and how Azure solutions enhance app performance, security, and scalability in the AI era. Learn new SQL database capabilities, connect with Microsoft engineering leaders, and attend expert-led sessions on topics from database migration to modernization.

You rated this post out of 5. Change rating

2024-10-09

164 reads

Technical Article

Introducing the PASS Data Community Summit Keynotes from Microsoft, Redgate, and a Community Star

  • Article

After meeting the stellar pre-con speakers and exploring the 5 learning pathways at #PASSDataSummit 2024, we’re excited to reveal the keynote lineup. Each day will kick off with inspiring keynotes from Microsoft, Redgate, and a special community-driven session led by industry experts. Don’t miss out on these insightful sessions designed to energize and empower you throughout PASS Summit 2024.

You rated this post out of 5. Change rating

2024-10-07

Blogs

A Last Minute Trip to the EU

By

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

By

In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...

Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework

By

I’m excited to announce the release of a new open-source project that fully automates...

Read the latest Blogs

Forums

Marshall??????????

By bkdscbclw26

??????????,??????????????????????????????MARSHALL ????????????????,??????????????????????????,??????????????????????? MARSHALL ?????????? ???? MARSHALL ???,?????????????,???????????????????????????????????,??????????????????????? ?????,??????????????,?????????????????????? ???????????? ??????????,????????????????????,?????????????????????????? MARSHALL ??????????????,????????????? ??????????????,???????????????????????? ????????????...

Server-Level Table sizes

By Artur Sanin

Comments posted to this topic are about the item Server-Level Table sizes

ORDER BY alias

By aniap

Comments posted to this topic are about the item ORDER BY alias

Visit the forum

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) + 1
Which of the following queries produces the expected ordering and why? (Select all correct)

See possible answers