Staying Safe when Traveling
Today, Grant talks about keeping your laptop and phone safe while traveling.
2020-02-05
270 reads
Editorials
How to Get Started with Version Control for Databases
Today, Kendra talks about why version control for databases is important and how to get started.
2020-02-04
523 reads
2020-02-03
182 reads
Why Getting Data Right Matters
An InfoWorld article from 2017 suggests that 80 percent of a data scientist’s job is cleaning and transforming data, and I believe this is probably only true for organizations that spend at least an average effort in designing and implementing their data storage. These persons who have trained to analyze data using complex math formulas […]
2020-02-01
205 reads
2020-01-30
247 reads
Why A Query May be Faster the Second Time it Runs
Today, Kendra Little explains why a query may run faster the second time you run it.
2020-01-29
2,571 reads
2020-01-28 (first published: 2018-12-06)
645 reads
2020-01-27
233 reads
Towards an efficient interface between application and database
As JSON documents becomes increasingly widely used, as the interface between application and database, Phil Factor reckons it's about time JSON Schema was built-in to SQL Server, alongside XML Schema.
2020-01-25
341 reads
2020-01-24
315 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
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
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