Could you spare 3 minutes to help us out at SQL Server Central/Simple Talk? Take this short survey, tell us about who you are and why you come to Simple Talk/SQL Server Central, and you could win a $50 Amazon voucher.
Introduction In response to my approach in the pop...
A reprint from the early days of SQLServerCentral as Steve is on vacation. Here is Steve Jones' Open Source Musings from February 3, 2005.
Table variables can cause performance issues with joins when they contain a large number of rows. In SQL Server 2019, Microsoft has improved how the optimizer works with table variables which can improve performance without making changes to your code. In this article, Greg Larsen explains how this feature works and if it really does make a difference.
Phil Factor demonstrates a cunning way to test stored procedures or functions, such as after refactoring, by storing the 'before' and 'after' results in views and then using SQL Data Compare to spot any discrepancies.
It can be hard to evaluate your career and job situation, but Steve has some ideas today.
You want to check for corruption, but you don’t want to slow down your primary production server. In this post, I’m specifically talking about offloading the corruption checking process. I’m not talking about doing corruption checking on both the primary and other servers – that’s wonderful, and if you’re doing that, you should hug yourself. You’re doing a good job. Who’s a good dog? You are! Good dog.
Distributed workforces have very quickly become the norm. The 2020 State of Database Monitoring survey explores the impact of remote working on estate management and how organisations are responding. You can read the full findings in the free report, here.
Get a basic introduction to Terraform by deploying and removing SQL Servers and a failover group to Azure.
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
A while back I posted about a couple of side projects that I’ve been...
Comments posted to this topic are about the item Identities and Sequences II
Comments posted to this topic are about the item Using PostgreSQL as a NoSQL...
Comments posted to this topic are about the item Is Your Time "Free"?
In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?
See possible answers