REGEXP_SUBSTR equivalent in MSSQL
All we need is an easy explanation of the problem, so here it is. I migrate from Oracle DB to Postgres/MS-SQL and I want to use REGEXP_SUBSTR equivalent with these…
Taking a weekly snapshot of table and appending it to a separate "history" table. Is this good practice?
All we need is an easy explanation of the problem, so here it is. I have set up a small project in work. Let's just say it's a list of…
Is there a way to add INCLUDE for a UNIQUE NONCLUSTERED index?
All we need is an easy explanation of the problem, so here it is. we have a table with 4 columns ( example ): create TABLE [dbo].[myTable] ( [Id] BIGINT…
SQL | Shuffle order set by row_number based on another table
All we need is an easy explanation of the problem, so here it is. I need to manually shuffle the order set by row_number in a table based order mentioned…
Logging just one table in an Azure SQL Database
All we need is an easy explanation of the problem, so here it is. Our company is ISO27001 certified. As such, it is required for us to log database events.…
Two OPENJSON, return each array element in separate rows
All we need is an easy explanation of the problem, so here it is. I have a table where I save in JSON format the quantity that exit and return…
Known issues with in place upgrade of SQL Server 2016 to SQL Server 2019
All we need is an easy explanation of the problem, so here it is. Closed. This question needs to be more focused. It is not currently accepting answers. Want to…
How do I change the default database owner for new databases in SQL Server?
All we need is an easy explanation of the problem, so here it is. I had cause to change my computer name (it’s running in a virtual machine). I have…
Duplicate resource on deadlock xml
All we need is an easy explanation of the problem, so here it is. As I was debugging a deadlock, I noticed that in the xml's resource-list, the first and…
Obtaining Auto-Generated Primary Key Values for Use as Foreign Keys
All we need is an easy explanation of the problem, so here it is. I am running a local instance of Microsoft SQL Server 15 (2019) and am using Microsoft…
- 1
- 2
- 3
- 4
- …
- 343
- Go to the next page