Search results

DECLARE @sqlcommand NVARCHAR(500)
DECLARE @getid CURSOR
SET @getid = CURSOR FOR 
SELECT 
      'USE [' + d.name...

Drop all tables in Postgres DB:

DROP SCHEMA public CASCADE;
CREATE SCHEMA public;

1. Download and install the latest Docker for Apple Silicon
2. Once Docker Desktop is running, open the Dashboard and go...

Here's how you shrink a database in AG:

USE master
GO
ALTER AVAILABILITY GROUP AG\_NAME REMOVE DATABASE DB\_NAME;
GO


use "DB\_NAME"
ALTER DATABASE "DB\_NAME"
SET RECOVERY SIMPLE;...

So I had a case today where if I wanted to paginate over 60k document pages that pagination was very...