(Daniel Janik) I’ve read a lot of things lately pointing to scalar functions as if they were the devil. In this blog I’m going to explore if that’s the case. Let’s have a look.
Tag: sql server
(Robert Sheldon) The Gen2 version of Azure SQL Data Warehouse gives Microsoft’s cloud data warehouse a shot in the arm on performance, making it more competitive with rival technologies.
(Pedro Lopes) Over the years you have read a number of blogs advocating for or against trace flags that influence SQL Server’s query execution model.
(Prashanth Jayaram) The ability to combine results from related rows from multiple tables is an important part of relational database system design. In SQL Server, this is accomplished with the SQL join clause.
(Grant Fritchey) A question that came up recently around Query Store is what happens when there are log backups in use on the database. Let’s talk about it.
(Thomas LaRock) Everyone’s pegging quantum computing as the next big thing in enterprise technology. Quantum computing is becoming as overhyped as Blockchain, if such a thing is possible.
(Pinal Dave) One of my blog readers sent me the following mail after reading my earlier blog posts about Random Function and OTP Code. Before you read the email, you can read those blog posts here, here, and here.
(Kenneth Fisher) tl;dr; While the difference is very important 90% of the time you won’t care and should just add the two numbers together.
(Ed Price) This topic of ARM template best practices (and getting started instructions) has a regular and consistent cloud scenario over the years. AzureCAT has written whitepapers on this.
(Koen Verbeeck) In the first part we introduced the reasoning behind type 2 slowly changing dimensions. We also discussed different implementation options in Integration Services (SSIS).