Skip to main content
HandyD's user avatar
HandyD's user avatar
HandyD's user avatar
HandyD
  • Member for 6 years, 9 months
  • Last seen this week
15 votes

transaction log in RAM or physical file?

14 votes
Accepted

Can I connect to the database as the user "dbo"?

11 votes
Accepted

Why is dropping a primary key expensive?

10 votes
Accepted

How we can we know SQL Replication components installed in SQL server

7 votes
Accepted

PowerShell command 'New-Item' fails when invoked through SQL Server Agent job

7 votes

How to use GROUP BY in a way that concatenates data in one column, but filters for specific data in another

6 votes
Accepted

How to verify Force Encryption is enabled for SQL Server

6 votes
Accepted

SQL Server: Should the same log records be backed up multiple times?

6 votes
Accepted

How to delete rows from relational database

6 votes
Accepted

Does the SQL Server Service Account have to have access to a network share to perform a backup?

6 votes
Accepted

Truncate all Tables in Database with T-SQL

5 votes
Accepted

Hidden operation of rebooting a SQL server database

5 votes
Accepted

70-761 Practice exam Question about @@Trancount final value

5 votes

Can I bulk insert into an empty page-compressed table and get full compression?

5 votes
Accepted

Piecemeal restore only one filegroup without primary filegroup restore

5 votes
Accepted

What happens when there's no tempdb space for version store operations?

5 votes
Accepted

minimum space is required on disk to restore a backup in SQl Server?

5 votes

Strange JOIN ON clause in T-SQL

5 votes

How does the disk and file share witness work?

5 votes

MS SQL Server 2014: which stored procedure is my error in?

5 votes
Accepted

SQL Server RAM usage - how to find out where it is going?

5 votes

What does non clustered index points to when the table has clustered index that is not unique?

4 votes
Accepted

How to reset the logon for the sql server services?

4 votes
Accepted

What is the word that means a query predicate can use an index

4 votes
Accepted

On premise to cloud restore - Automated?

4 votes
Accepted

Update Rows From Table If Table Exists Without Using sp_executesql

4 votes
Accepted

SQL Server 2019 (RTM) - 15.0.2000.5 period has expired after upgrade to CU 8

4 votes
Accepted

Need advice on how to migrate from existing database mirroring to availability groups

4 votes
Accepted

How can I add time and date to a query output file name in sql server agent job

4 votes

sp_MSforeachdb Continue on failure when running DBCC CHECKDB

1
2 3 4 5
13