A Fine Slice Of SQL Server
Tomaz Kastrun does a bit of benchmarking:
After an interesting conversation on using data. frames or strings (as a vector), I have decided to put this to a simple benchmark test.
The problem is straightforward and simple: a MapReduce or Count with GroupBy.
Click through for three potential solutions to the problem and how they compare in terms of performance.
Comments closedI was recently working on a client server and need to install the Az PowerShell module. I opened and administrator window and typed
Install-Module Azand received this error:
WARNING: Unable to find module repositories.
Turns out that was not the real answer. Click through to see what Frank ended up needing to do.
Comments closedMichael J Swart recommends a unique index:
To avoid deadlocks when implementing the upsert pattern, make sure the index on the key column is unique. It’s not sufficient that all the values in that particular column happen to be unique. The index must be defined to be unique, otherwise concurrent queries can still produce deadlocks.
Read on for Michael’s thoughts as well as some smart commenters adding on.
Comments closedLouis Davidson receives a nastygram from SQL Server’s graph functionality:
Just understand that if you need any of the graphDb underlying data structures, you will need to find their actual physical name and use it. I would definitely suggest never accessing these columns via any method other than the pseudocolmns for production code (because you have no way to predict the column names from dev to prod (you cannot specify the names when creating a table), but this following code does work:
Click through to see the issue and Louis’s workarounds.
Comments closedKendra Little announces a new article:
We’ve just published a new article in the SQL docs, Tune nonclustered indexes with missing index suggestions . The article explains what the missing index feature is, limitations of the feature, and how to use missing index DMVs and missing index suggestions in Query Store to tune indexes.
Read on to understand the impetus behind this article and then go check it out yourself.
Comments closedChris Webb looks at a new addition to Power Query:
Anyone with previous experience of Table.Buffer will see that BufferMode.Eager is the existing behaviour, but what is BufferMode.Delayed for?
It turns out that it’s there to make development faster.
Read on for the answer and what it does.
Comments closedErik Darling continues a series on understanding execution plans. First up, what some of those warnings mean:
The good news is that SQL Server’s query plans will attempt to warn you about problems. The bad news is that most of the warnings only show up in Actual Execution Plans. The worse news is that a lot of the warnings that try to be helpful in Estimated Execution plans can be pretty misleading.
Next, Erik reviews some interesting properties:
There’s a lot of stuff flying around in a query plan. Data and what not.
Sure, you can hover over operators and arrows and see some stuff, but if you really wanna see stuff — I mean REALLY wanna see stuff — you gotta get into the properties.
Check out both posts.
Comments closedZadhid Powell has an example of working with ML.NET:
Machine learning is one of those areas of programming which is very capable of invitations and creativity. But, are you limited to any particular language like Python or R to develop either AI or ML projects? Who says that?
Nowadays, many developers have started learning to program with C#. But, if you’re one of them, you’d probably have heard that C# is not the best choice to start programming or it’s just useful for windows applications which is a wrong belief.
I mean, I’m still going to the mats for F# here but yeah, anybody who says C# is a bad starting language for programmers or that you can only build Windows apps with it lacks sufficient information on the language to make a sound judgment.
Comments closedBryan Shalloway has fun with network plots:
In previous posts and threads I’ve alluded to the potential utility of visualizing the relationships between parsed functions/packages and files as a network plot.
I added the function
network_plot()to funspotr. In this post I’ll simply output the network plots of the parsed-out packages from the code collections discussed in the prior two posts:
Click through for interactive plots of what different people in the R community use.
Comments closedKenneth Fisher has a use for temporary stored procedures:
The other day I was asked to create a SQL Audit on several different databases. Completely unexpectedly (sarcasm warning!) the list grew, not once, not twice, but enough times that I’ve lost count, and each time I would copy and paste my code for the new databases and change the database name in each piece. Then on one notable occasion I had to change the code for each of the, at that point 10, copies of the code. Talk about a headache.
Then there was the epiphany.
Comments closed