I Read Quite a Bit
Today Grant talks about the challenges of sometimes finding good, current information.
2020-06-15
136 reads
Editorials
What is Azure SQL Database Serverless?
I remember when the first SQL databases were available on Azure. The size limits and missing features made them impractical for most uses at the time. Fast forward 10 years and you can you create a terabyte database and take advantage of configurations like Hyperscale, Elastic Pool, and Managed Instances. You get automatic high-availability and […]
2020-06-13
731 reads
Are You a Gatekeeper?
One of the problems that I've seen in many parts of life is the belief that things must proceed a certain way. I caught an article on ways teachers have made school less fun for kids because they adhered to some rule or belief too tightly. I think many of those stories are true because […]
2020-06-12
196 reads
The Benefits and Detractions of Remote
Working from home during the pandemic is likely to change many things, and Steve discusses a few today.
2020-06-11
136 reads
2020-06-10
148 reads
What's a Normal SQL Server?
Many of us have worked in environments that have a number of SQL Server instances. Different versions, editions, and mostly different hardware profiles. We deal with different applications and software that places different demands and requirements on our database systems. Some of us are even dealing with multiple datastores, trying to integrate SQL Server with […]
2020-06-09
203 reads
Double Half and Quarter
I've worked in a a couple very high performing organizations that adapted to changing conditions and built software well. I've worked in more poorly performing organizations that struggled to release updates and patches, causing tremendous stress for the IT staff. DevOps is designed to help improve our software delivery and quality, if you work on […]
2020-06-08
113 reads
The Social Impact of Data
Let the data drive your decisions. This has been something of a mantra for many technical people, and even many business people, across the last twenty or so years. The allure of business intelligence is harnessing lots of data to make decisions that are rooted in some rational analysis of what has happened. Many companies […]
2020-06-06
100 reads
2020-06-05 (first published: 2016-04-29)
221 reads
Do You Think About CheckDB?
Running checkdb is part of ensuring your database health and data integrity. Steve notes that you might want to review that you have the best strategy for your organization.
2020-06-04
169 reads
Blogs
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...
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
Forums
Marshall??????????
??????????,??????????????????????????????MARSHALL ????????????????,??????????????????????????,??????????????????????? MARSHALL ?????????? ???? MARSHALL ???,?????????????,???????????????????????????????????,??????????????????????? ?????,??????????????,?????????????????????? ???????????? ??????????,????????????????????,?????????????????????????? MARSHALL ??????????????,????????????? ??????????????,???????????????????????? ????????????...
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
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