John K. N.'s user avatar
John K. N.'s user avatar
John K. N.'s user avatar
John K. N.
  • Member for 11 years, 3 months
  • Last seen this week
27 votes
Accepted

Understanding CleanupTime in Ola Hallengren's SQL Server scripts in relation to FULL backups and LOG backups

23 votes
Accepted

Automatically execute query in MS SQL Studio every hour

18 votes
Accepted

OLE DB provider "MSOLEDBSQL" with SQL Server not supported?

17 votes
Accepted

Creating an Index on a varchar(1024) column succeeded. Does it work?

16 votes

Online page restore hitting 1000 limit

15 votes

cannot execute as the database principal because the principal does not exist - DB Restoration

15 votes

Changing sa password

13 votes
Accepted

Is Microsoft SQL Server 2016 fully ANSI SQL-92 compliant?

13 votes
Accepted

How to tell if a backup log chain is broken?

13 votes
Accepted

Logon failed for login due to trigger execution

13 votes

Making sense of sys.objects, sys.system_objects, and sys.sysobjects?

13 votes

SQL Server Management Studio slow opening new windows

13 votes
Accepted

How to lock a sql login after N unsuccessful login attempts

12 votes

Log4j CVE-2021-44228 - vulnerability in MySQL hosts

12 votes
Accepted

How to backup an Oracle database from SQL Developer

11 votes
Accepted

Backup SQL Server 2016 Instance Logins

11 votes

SSMS 2014 Gives an exception when opening the new query window

10 votes
Accepted

What is the SQL server mechanism to ensure that the page being restored isn't corrupted?

10 votes

Password character issues for } and ' in SQL connection string

10 votes

Internally, how does OpenRowset(TABLE ...) work?

10 votes
Accepted

How many cores are used for serial plans in SQL Server?

9 votes
Accepted

Will non copy only full backup impact transaction log backups chain?

9 votes
Accepted

What is the difference between database snapshot and VSS database snapshot backup?

9 votes

Upgrading from SQL Server 2012 SP1 to SQL Server 2019

9 votes
Accepted

Can anyone explain to me the concept "incarnation" in Oracle database in an easy-to-understand way?

8 votes
Accepted

How to know which application or user put the SQL Server Database in single user mode

8 votes
Accepted

Do database connections get automatically reconnected if a database is restored?

8 votes
Accepted

What is an orphan incarnation?

8 votes

Cannot remove filegroup with no files associated

8 votes
Accepted

How to force users to specify a filegroup when creating tables/indexes

1
2 3 4 5
17